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

Lines Matching refs:stmt
20     if (!$stmt = mysqli_stmt_init($link))
23     // stmt object status test
25         mysqli_stmt_execute($stmt);
30     if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
33     // stmt object status test
35         mysqli_stmt_execute($stmt);
40     if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT 1"))
41         printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
43     if (true !== ($tmp = mysqli_stmt_execute($stmt)))
45             gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
47     if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)"))
48         printf("[009] [%d] %s\n", mysqli_stmt_execute($stmt), mysqli_stmt_execute($stmt));
51     if (false !== ($tmp = mysqli_stmt_execute($stmt)))
56     if (!mysqli_stmt_bind_param($stmt, "is", $id, $label))
57         printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
59     if (true !== ($tmp = mysqli_stmt_execute($stmt)))
60         printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
63     mysqli_stmt_close($stmt);
64     if (!$stmt = mysqli_stmt_init($link))
67     if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT ?"))
68         printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
71     if (!mysqli_stmt_bind_param($stmt, "i", $limit))
72         printf("[015] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
74     if (true !== ($tmp = mysqli_stmt_execute($stmt)))
76             gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
79     if (!mysqli_stmt_bind_result($stmt, $id) || !mysqli_stmt_fetch($stmt))
80         printf("[017] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
85     if (true !== ($tmp = mysqli_stmt_reset($stmt)))
87             gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
89     if (true !== ($tmp = mysqli_stmt_execute($stmt)))
91             gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
94     if (!mysqli_stmt_fetch($stmt))
95         printf("[021] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
100     mysqli_stmt_close($stmt);
101     if (!$stmt = mysqli_stmt_init($link))
104     if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT 1"))
105         printf("[024] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
107     if (true !== ($tmp = mysqli_stmt_execute($stmt)))
109             gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
111     if (true !== ($tmp = mysqli_stmt_reset($stmt)))
113             gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
115     var_dump(mysqli_stmt_execute($stmt));
116     var_dump(mysqli_stmt_fetch($stmt));
120     if (false !== ($tmp = mysqli_stmt_execute($stmt)))
123     mysqli_stmt_close($stmt);
126         mysqli_stmt_execute($stmt);