Lines Matching refs:stmt
30 if (!$stmt = mysqli_stmt_init($link))
33 // stmt object status test
34 if (false !== ($tmp = mysqli_stmt_execute($stmt)))
37 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
40 // stmt object status test
41 if (false !== ($tmp = mysqli_stmt_execute($stmt)))
44 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT 1"))
45 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
47 if (true !== ($tmp = mysqli_stmt_execute($stmt)))
49 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
51 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)"))
52 printf("[009] [%d] %s\n", mysqli_stmt_execute($stmt), mysqli_stmt_execute($stmt));
55 if (false !== ($tmp = mysqli_stmt_execute($stmt)))
60 if (!mysqli_stmt_bind_param($stmt, "is", $id, $label))
61 printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
63 if (true !== ($tmp = mysqli_stmt_execute($stmt)))
64 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
67 mysqli_stmt_close($stmt);
68 if (!$stmt = mysqli_stmt_init($link))
71 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT ?"))
72 printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
75 if (!mysqli_stmt_bind_param($stmt, "i", $limit))
76 printf("[015] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
78 if (true !== ($tmp = mysqli_stmt_execute($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))
84 printf("[017] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
89 if (true !== ($tmp = mysqli_stmt_reset($stmt)))
91 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
93 if (true !== ($tmp = mysqli_stmt_execute($stmt)))
95 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
98 if (!mysqli_stmt_fetch($stmt))
99 printf("[021] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
104 mysqli_stmt_close($stmt);
105 if (!$stmt = mysqli_stmt_init($link))
108 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT 1"))
109 printf("[024] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
111 if (true !== ($tmp = mysqli_stmt_execute($stmt)))
113 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
115 if (true !== ($tmp = mysqli_stmt_reset($stmt)))
117 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
119 var_dump(mysqli_stmt_execute($stmt));
120 var_dump(mysqli_stmt_fetch($stmt));
124 if (false !== ($tmp = mysqli_stmt_execute($stmt)))
127 mysqli_stmt_close($stmt);
129 if (false !== ($tmp = mysqli_stmt_execute($stmt)))
