Lines Matching refs:stmt
13 if (!$stmt = mysqli_stmt_init($link))
16 // stmt object status test
18 mysqli_stmt_execute($stmt);
23 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
26 // stmt object status test
28 mysqli_stmt_execute($stmt);
33 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT 1"))
34 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
36 if (true !== ($tmp = mysqli_stmt_execute($stmt)))
38 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
40 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)"))
41 printf("[009] [%d] %s\n", mysqli_stmt_execute($stmt), mysqli_stmt_execute($stmt));
44 if (false !== ($tmp = mysqli_stmt_execute($stmt)))
49 if (!mysqli_stmt_bind_param($stmt, "is", $id, $label))
50 printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
52 if (true !== ($tmp = mysqli_stmt_execute($stmt)))
53 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
56 mysqli_stmt_close($stmt);
57 if (!$stmt = mysqli_stmt_init($link))
60 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT ?"))
61 printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
64 if (!mysqli_stmt_bind_param($stmt, "i", $limit))
65 printf("[015] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
67 if (true !== ($tmp = mysqli_stmt_execute($stmt)))
69 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
72 if (!mysqli_stmt_bind_result($stmt, $id) || !mysqli_stmt_fetch($stmt))
73 printf("[017] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
78 if (true !== ($tmp = mysqli_stmt_reset($stmt)))
80 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
82 if (true !== ($tmp = mysqli_stmt_execute($stmt)))
84 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
87 if (!mysqli_stmt_fetch($stmt))
88 printf("[021] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
93 mysqli_stmt_close($stmt);
94 if (!$stmt = mysqli_stmt_init($link))
97 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT 1"))
98 printf("[024] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
100 if (true !== ($tmp = mysqli_stmt_execute($stmt)))
102 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
104 if (true !== ($tmp = mysqli_stmt_reset($stmt)))
106 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
108 var_dump(mysqli_stmt_execute($stmt));
109 var_dump(mysqli_stmt_fetch($stmt));
113 if (false !== ($tmp = mysqli_stmt_execute($stmt)))
116 mysqli_stmt_close($stmt);
119 mysqli_stmt_execute($stmt);