Lines Matching refs:stmt
23 if (!$stmt = mysqli_stmt_init($link))
26 // stmt object status test
28 mysqli_stmt_fetch($stmt);
33 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
34 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
37 if ((NULL !== ($tmp = mysqli_stmt_get_result($stmt))) && (false !== $tmp))
40 if (!mysqli_stmt_execute($stmt))
41 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
43 if (!mysqli_stmt_store_result($stmt))
44 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
46 if (is_object($tmp = mysqli_stmt_store_result($stmt)))
49 mysqli_stmt_close($stmt);
51 if (!$stmt = mysqli_stmt_init($link))
54 // stmt object status test
56 mysqli_stmt_fetch($stmt);
61 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
62 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
65 if ((NULL !== ($tmp = mysqli_stmt_get_result($stmt))) && (false !== $tmp))
68 if (!mysqli_stmt_execute($stmt))
69 printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
71 if (!is_object($tmp = mysqli_stmt_get_result($stmt)))
75 mysqli_stmt_close($stmt);
77 if (!$stmt = mysqli_stmt_init($link))
80 // stmt object status test
82 mysqli_stmt_get_result($stmt);
87 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
88 printf("[019] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
90 if (false !== ($tmp = mysqli_stmt_get_result($stmt)))
93 if (!mysqli_stmt_execute($stmt))
94 printf("[023] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
96 if (!is_object($tmp = mysqli_stmt_get_result($stmt)))
99 if (false !== ($tmp = mysqli_stmt_fetch($stmt)))
102 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label))) {
103 printf("[026] [%d] [%s]\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
108 if (false !== ($tmp = mysqli_stmt_fetch($stmt)))
111 mysqli_stmt_close($stmt);
114 if (!$stmt = mysqli_stmt_init($link))
117 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
118 printf("[031] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
120 if (!mysqli_stmt_attr_set($stmt, MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY))
121 printf("[032] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
123 if (!mysqli_stmt_execute($stmt))
124 printf("[033] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
126 $result = mysqli_stmt_get_result($stmt);
131 if (!$stmt = mysqli_stmt_init($link))
134 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
135 printf("[035] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
137 if (!mysqli_stmt_execute($stmt))
138 printf("[036] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
142 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label)))
145 if (!is_object($tmp = $result = mysqli_stmt_get_result($stmt)))
148 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
150 if (false !== ($tmp = mysqli_stmt_fetch($stmt)))
152 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
154 printf("[040] [%d] [%s]\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
164 if (false !== ($tmp = mysqli_stmt_get_result($stmt)))
167 mysqli_stmt_close($stmt);
170 mysqli_stmt_fetch($stmt);