4
<?php require_once('skipif.inc'); ?>
9
/*** test mysqli_connect 127.0.0.1 ***/
10
$link = mysqli_connect($host, $user, $passwd);
12
mysqli_select_db($link, "test");
14
mysqli_query($link,"DROP TABLE IF EXISTS test_store_result");
15
mysqli_query($link,"CREATE TABLE test_store_result (a int)");
17
mysqli_query($link, "INSERT INTO test_store_result VALUES (1),(2),(3)");
19
$stmt = mysqli_prepare($link, "SELECT * FROM test_store_result");
20
mysqli_execute($stmt);
22
/* this should produce an out of sync error */
23
if ($result = mysqli_query($link, "SELECT * FROM test_store_result")) {
24
mysqli_free_result($result);
25
printf ("Query ok\n");
27
mysqli_stmt_close($stmt);
29
$stmt = mysqli_prepare($link, "SELECT * FROM test_store_result");
30
mysqli_execute($stmt);
31
$result1 = mysqli_get_metadata($stmt);
32
mysqli_stmt_store_result($stmt);
34
printf ("Rows: %d\n", mysqli_stmt_affected_rows($stmt));
36
/* this should show an error, cause results are not buffered */
37
if ($result = mysqli_query($link, "SELECT * FROM test_store_result")) {
38
$row = mysqli_fetch_row($result);
39
mysqli_free_result($result);
45
mysqli_free_result($result1);
46
mysqli_stmt_close($stmt);