if (!mysqli_stmt_bind_param($stmt, "b", $label)) { printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); } $label = 'abc'; for ($i = 0; $i < 10; $i++) { if (!mysqli_stmt_send_long_data($stmt, 0, $label)) { printf("[015 - %d] [%d] %s\n", $i, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); } } if (!mysqli_stmt_reset($stmt)) { printf("[016] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); } if (!mysqli_stmt_execute($stmt)) { printf("[017] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); } if (!($res = mysqli_query($link, "SELECT label FROM test"))) { printf("[018] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); } if (!($row = mysqli_fetch_assoc($res))) { printf("[019] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); } mysqli_free_result($res); if ($row['label'] != '') { printf("[020] Expecting empty string, got string/%s\n", $row['label']); } mysqli_stmt_close($stmt); if (NULL !== ($tmp = mysqli_stmt_reset($stmt))) { printf("[021] Expecting NULL, got %s/%s\n"); } mysqli_close($link); print "done!";
if ($result = mysqli_query($link, "SELECT * FROM test_057_table_1")) { mysqli_free_result($result); printf("Query ok\n"); } mysqli_stmt_close($stmt); /* now we should try mysqli_stmt_reset() */ $stmt = mysqli_prepare($link, "SELECT * FROM test_057_table_1"); var_dump(mysqli_stmt_execute($stmt)); var_dump(mysqli_stmt_reset($stmt)); var_dump($stmt = mysqli_prepare($link, "SELECT * FROM test_057_table_1")); if ($stmt->affected_rows !== 0) { printf("[001] Expecting 0, got %d\n", $stmt->affected_rows); } var_dump(mysqli_stmt_execute($stmt)); var_dump($stmt = @mysqli_prepare($link, "SELECT * FROM test_057_table_1"), mysqli_error($link)); var_dump(mysqli_stmt_reset($stmt)); $stmt = mysqli_prepare($link, "SELECT * FROM test_057_table_1"); mysqli_stmt_execute($stmt); $result1 = mysqli_stmt_result_metadata($stmt); mysqli_stmt_store_result($stmt); printf("Rows: %d\n", mysqli_stmt_affected_rows($stmt)); /* this should show an error, cause results are not buffered */ if ($result = mysqli_query($link, "SELECT * FROM test_057_table_1")) { $row = mysqli_fetch_row($result); mysqli_free_result($result); } var_dump($row); mysqli_free_result($result1); mysqli_stmt_close($stmt); mysqli_close($link); echo "done!";
if (!mysqli_stmt_fetch($stmt)) { printf("[021] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); } if ($id !== 1) { printf("[022] Expecting int/1 got %s/%s\n", gettype($id), $id); } mysqli_stmt_close($stmt); if (!($stmt = mysqli_stmt_init($link))) { printf("[023] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); } if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT 1")) { printf("[024] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); } if (true !== ($tmp = mysqli_stmt_execute($stmt))) { printf("[025] Expecting boolean/true, got %s/%s. [%d] %s\n", gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); } if (true !== ($tmp = mysqli_stmt_reset($stmt))) { printf("[026] Expecting boolean/true, got %s/%s. [%d] %s\n", gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); } var_dump(mysqli_stmt_execute($stmt)); var_dump(mysqli_stmt_fetch($stmt)); mysqli_kill($link, mysqli_thread_id($link)); if (false !== ($tmp = mysqli_stmt_execute($stmt))) { printf("[027] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); } mysqli_stmt_close($stmt); if (NULL !== ($tmp = mysqli_stmt_execute($stmt))) { printf("[028] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); } mysqli_close($link); print "done!";