Home
last modified time | relevance | path

Searched refs:stmt (Results 76 – 100 of 467) sorted by last modified time

12345678910>>...19

/PHP-7.4/ext/mysqli/tests/
H A Dmysqli_stmt_close.phpt24 if (!$stmt = mysqli_stmt_init($link))
32 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
40 if (!$stmt = mysqli_stmt_init($link))
44 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
48 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
51 if (!mysqli_stmt_execute($stmt))
52 printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
66 printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
70 printf("[015] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
72 if (!mysqli_stmt_execute($stmt) || !mysqli_stmt_fetch($stmt))
[all …]
H A Dmysqli_stmt_data_seek.phpt31 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
39 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
47 if (!mysqli_stmt_fetch($stmt))
48 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
56 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
60 if (!is_null($tmp = mysqli_stmt_data_seek($stmt, mysqli_stmt_num_rows($stmt) + 100)))
63 if (mysqli_stmt_fetch($stmt))
64 printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
72 printf("[016] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dmysqli_stmt_errno.phpt24 if (!$stmt = mysqli_stmt_init($link))
28 if (0 !== ($tmp = mysqli_stmt_errno($stmt)))
31 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
35 if (0 === ($tmp = mysqli_stmt_errno($stmt)))
38 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id"))
39 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42 if (0 != ($tmp = mysqli_stmt_errno($stmt)))
47 if (true === ($tmp = mysqli_stmt_execute($stmt)))
51 if (0 === ($tmp = mysqli_stmt_errno($stmt)))
54 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_error.phpt24 if (!$stmt = mysqli_stmt_init($link))
28 if ('' !== ($tmp = mysqli_stmt_error($stmt)))
31 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
35 if ('' === ($tmp = mysqli_stmt_error($stmt)))
38 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id"))
39 printf("[007] [%d] %s\n", mysqli_stmt_error($stmt), mysqli_stmt_error($stmt));
42 if ('' !== ($tmp = mysqli_stmt_error($stmt)))
47 if (true === ($tmp = mysqli_stmt_execute($stmt)))
51 if ('' === ($tmp = mysqli_stmt_error($stmt)))
54 mysqli_stmt_close($stmt);
[all …]
H A Dmysqli_stmt_execute.phpt33 // stmt object status test
45 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
49 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
61 printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
64 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
72 printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
76 printf("[015] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
80 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
83 if (!mysqli_stmt_bind_result($stmt, $id) || !mysqli_stmt_fetch($stmt))
91 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dmysqli_stmt_execute_stored_proc.phpt35 if (!mysqli_stmt_close($stmt))
47 printf("[017] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
52 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
55 mysqli_stmt_close($stmt);
90 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
125 printf("[034] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
130 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
133 mysqli_stmt_close($stmt);
167 printf("[044] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
172 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dmysqli_prepare.phpt37 mysqli_stmt_close($stmt);
45 mysqli_stmt_close($stmt);
52 if (!mysqli_stmt_bind_param($stmt, 'i', $id) || !mysqli_stmt_execute($stmt))
54 mysqli_stmt_close($stmt);
60 if (!mysqli_stmt_bind_param($stmt, 'i', $id) || !mysqli_stmt_execute($stmt))
62 mysqli_stmt_close($stmt);
71 mysqli_stmt_close($stmt);
77 if (!mysqli_stmt_bind_param($stmt, 'i', $where) || !mysqli_stmt_execute($stmt))
85 if (!mysqli_stmt_bind_param($stmt, 's', $testvar) || !mysqli_stmt_execute($stmt))
97 if (!mysqli_stmt_execute($stmt) || !mysqli_stmt_bind_result($stmt, $id, $testvar))
[all …]
H A Dmysqli_insert_id_variation.phpt70 $stmt = $link->prepare("SELECT 1");
76 if (0 != $stmt->insert_id || 0 != mysqli_stmt_insert_id($stmt)) {
77 … printf("[008b] mysqli_stmt doesn't initialise insert_id: %s", var_export($stmt->insert_id, true));
81 unset($stmt);
83 printf("[009] stmt free changes insert_id: %s", var_export($link->insert_id, true));
H A Dmysqli_ps_select_union.phpt31 if (!$stmt->execute() || !$stmt->bind_result($column1))
32 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error);
57 if (!$stmt->bind_result($column1) || !$stmt->execute())
87 if (!$stmt->execute() || !$stmt->bind_result($column1))
88 printf("[010] [%d] %s\n", $stmt->errno, $stmt->error);
136 if (!$stmt->execute() || !$stmt->bind_result($column1))
137 printf("[017] [%d] %s\n", $stmt->errno, $stmt->error);
177 … if (!$stmt->bind_param('ss', $three, $two) || !$stmt->execute() || !$stmt->bind_result($column1))
196 … if (!$stmt->bind_param('ss', $three, $two) || !$stmt->bind_result($column1) || !$stmt->execute())
217 … if (!$stmt->bind_param('ss', $three, $two) || !$stmt->execute() || !$stmt->bind_result($column1))
[all …]
H A Dmysqli_get_warnings.phpt137 $stmt = mysqli_stmt_init();
138 $warning = new mysqli_warning($stmt);
H A Dmysqli_get_client_stats.phpt328 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
336 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
365 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
370 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
374 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
406 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
411 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
415 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
454 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
459 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
[all …]
H A Dmysqli_fetch_array_large.phpt54 if (!$stmt = mysqli_prepare($link, "SELECT id, label FROM test")) {
60 if (!mysqli_stmt_execute($stmt)) {
61 …= %d, [%d] %s, [%d] %s\n", $offset, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), mysq…
66 if (!mysqli_stmt_bind_result($stmt, $id, $label)) {
67 …= %d, [%d] %s, [%d] %s\n", $offset, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), mysq…
71 while (mysqli_stmt_fetch($stmt)) {
74 … $offset, $random_char, $label, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
79 mysqli_stmt_free_result($stmt);
80 mysqli_stmt_close($stmt);
H A Dmysqli_get_client_stats_ps.phpt25 if (!$stmt = mysqli_stmt_init($link))
30 !mysqli_stmt_execute($stmt) ||
31 !mysqli_stmt_store_result($stmt) ||
33 printf("[002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
36 while (mysqli_stmt_fetch($stmt))
39 mysqli_stmt_free_result($stmt);
61 !mysqli_stmt_execute($stmt) ||
63 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
66 while (mysqli_stmt_fetch($stmt))
81 mysqli_stmt_free_result($stmt);
[all …]
H A Dmysqli_class_mysqli_warning.phpt25 $stmt = new mysqli_stmt($mysqli);
26 $warning = new mysqli_warning($stmt);
28 $stmt = $mysqli->stmt_init();
29 $warning = new mysqli_warning($stmt);
H A Dmysqli_explain_metadata.phpt66 $stmt = mysqli_stmt_init($link);
68 … if ($stmt->prepare('EXPLAIN SELECT t1.*, t2.* FROM test AS t1, test AS t2') && $stmt->execute()) {
69 if (!mysqli_stmt_store_result($stmt))
70 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
72 if (!$res_meta = mysqli_stmt_result_metadata($stmt))
73 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
104 $stmt->execute()) {
105 if (!$res_stmt = mysqli_stmt_get_result($stmt)) {
107 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
113 if ((mysqli_stmt_num_rows($stmt)) !== 0) {
[all …]
H A Dmysqli_class_mysqli_stmt_interface.phpt94 assert(mysqli_stmt_errno($stmt) === $stmt->errno);
95 printf("stmt->errno = '%s'\n", $stmt->errno);
97 assert(mysqli_stmt_error($stmt) === $stmt->error);
98 printf("stmt->error = '%s'\n", $stmt->error);
101 var_dump("stmt->error = ", $stmt->error_list);
107 printf("stmt->id = '%s'\n", $stmt->id);
110 printf("stmt->insert_id = '%s'\n", $stmt->insert_id);
113 printf("stmt->num_rows = '%s'\n", $stmt->num_rows);
119 printf("stmt->sqlstate = '%s'\n", $stmt->sqlstate);
122 printf("stmt->unknown = '%s'\n", @$stmt->unknown);
[all …]
H A Dbug55653.phpt18 if (!($stmt = $link->stmt_init()))
21 if (!($stmt->prepare("SELECT ?")) ||
22 !($stmt->bind_param("s", $in_and_out)) ||
23 !($stmt->execute()) ||
24 !($stmt->bind_result($in_and_out)))
25 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error);
27 if (!$stmt->fetch())
28 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error);
H A Dbug62046.phpt15 if (FALSE === ($stmt = $link->prepare('SELECT 42'))) {
18 if (FALSE === $stmt->execute()) {
19 printf("[003] Execute failed, [%d] %s\n", $stmt->errorno, $stmt->error);
21 if (FALSE === $stmt->store_result()) {
22 printf("[004] store_result failed, [%d] %s\n", $stmt->errorno, $stmt->error);
25 if (FALSE === $stmt->bind_result($one)) {
26 printf("[005] bind_result failed, [%d] %s\n", $stmt->errorno, $stmt->error);
28 if (FALSE === $stmt->reset()) {
29 printf("[006] bind_result failed, [%d] %s\n", $stmt->errorno, $stmt->error);
31 while ($stmt->fetch()) {
[all …]
H A Dbug66043.phpt19 $stmt = $db->stmt_init();
20 $stmt->prepare("SELECT User FROM user WHERE password=\"\"");
21 $stmt->execute();
22 $stmt->bind_result($testArg);
H A Dbug69899.phpt2 Bug #69899: Segfault on stmt close after free_result with mysqlnd.
26 $stmt = $mysqli->prepare('SELECT 1');
30 $stmt->free_result(),
31 $stmt->close()
H A Dbug70949.phpt23 if ($stmt = $mysql->prepare($sql))
25 $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY);
27 if ($stmt->bind_result($name)) {
29 if ($stmt->execute())
31 while ($stmt->fetch())
38 $stmt->free_result();
39 $stmt->close();
H A Dbug_mysql_49406.phpt30 if (!$stmt = $link->prepare($query))
33 if (!$stmt->execute() || !$stmt->store_result())
34 printf("[006] [%d] %s\n", $stmt->errno, $stmt->error);
64 $meta_res = $stmt->result_metadata();
81 if (!$stmt->bind_result($row_stmt) || !$stmt->fetch())
82 printf("[007] [%d] %s\n", $stmt->errno, $stmt->error);
90 $stmt->close();
H A Dbug66124.phpt34 $stmt = $link->prepare($table_insert);
35 if (!$stmt) {
41 $stmt->bind_param('i', $id);
43 if ($stmt->execute()){
44 echo "insert id:{$id}=>{$stmt->insert_id}\n";
62 $stmt->close();
68 $stmt = $link->prepare($table_insert);
69 $stmt->bind_param('s', $id);
73 if ($stmt->execute()){
H A Dbug67839.phpt36 if (!($stmt = mysqli_prepare($link, "SELECT id, fp4, fp8 FROM test"))) {
45 if (!mysqli_stmt_bind_result($stmt, $id, $fp4, $fp8)) {
50 if (!mysqli_stmt_execute($stmt)) {
56 if (!(mysqli_stmt_fetch($stmt))) {
H A Dbug76386.phpt39 $stmt = $link->prepare('SELECT * FROM ts_test;'); // must be statement
40 if ($stmt) {
41 $stmt->execute();
44 $stmt->fetch();
46 $stmt->free_result();
67 $stmt = $link->prepare('SELECT * FROM t_test;');
68 if ($stmt) {
69 $stmt->execute();
71 $stmt->bind_result($tid, $t, $t2, $t4, $t6);
72 while ($stmt->fetch()) {
[all …]

Completed in 47 milliseconds

12345678910>>...19