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);