mysqli_stmt_execute.phpt - OpenGrok cross reference for /PHP-8.2/ext/mysqli/tests/mysqli_stmt

Lines Matching refs:stmt
19     if (!$stmt = mysqli_stmt_init($link))
22     // stmt object status test
24         mysqli_stmt_execute($stmt);
29     if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
32     // stmt object status test
34         mysqli_stmt_execute($stmt);
39     if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT 1"))
40         printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
42     if (true !== ($tmp = mysqli_stmt_execute($stmt)))
44             gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
46     if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)"))
47         printf("[009] [%d] %s\n", mysqli_stmt_execute($stmt), mysqli_stmt_execute($stmt));
50     if (false !== ($tmp = mysqli_stmt_execute($stmt)))
55     if (!mysqli_stmt_bind_param($stmt, "is", $id, $label))
56         printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
58     if (true !== ($tmp = mysqli_stmt_execute($stmt)))
59         printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
62     mysqli_stmt_close($stmt);
63     if (!$stmt = mysqli_stmt_init($link))
66     if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT ?"))
67         printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
70     if (!mysqli_stmt_bind_param($stmt, "i", $limit))
71         printf("[015] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
73     if (true !== ($tmp = mysqli_stmt_execute($stmt)))
75             gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
78     if (!mysqli_stmt_bind_result($stmt, $id) || !mysqli_stmt_fetch($stmt))
79         printf("[017] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
84     if (true !== ($tmp = mysqli_stmt_reset($stmt)))
86             gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
88     if (true !== ($tmp = mysqli_stmt_execute($stmt)))
90             gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
93     if (!mysqli_stmt_fetch($stmt))
94         printf("[021] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
99     mysqli_stmt_close($stmt);
100     if (!$stmt = mysqli_stmt_init($link))
103     if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT 1"))
104         printf("[024] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
106     if (true !== ($tmp = mysqli_stmt_execute($stmt)))
108             gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
110     if (true !== ($tmp = mysqli_stmt_reset($stmt)))
112             gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
114     var_dump(mysqli_stmt_execute($stmt));
115     var_dump(mysqli_stmt_fetch($stmt));
119     if (false !== ($tmp = mysqli_stmt_execute($stmt)))
122     mysqli_stmt_close($stmt);
125         mysqli_stmt_execute($stmt);