Lines Matching refs:stmt
43 $stmt = mysqli_stmt_init($link);
44 if (false !== ($tmp = @mysqli_stmt_attr_set($stmt, 0, 0)))
47 $stmt->prepare("SELECT * FROM test");
55 if (false !== ($tmp = @mysqli_stmt_attr_set($stmt, $invalid_attr, 0))) {
64 if (false !== ($tmp = @mysqli_stmt_attr_set($stmt, $invalid_attr, 0))) {
68 $stmt->close();
76 $stmt = mysqli_stmt_init($link);
77 $stmt->prepare("SELECT label FROM test");
78 $stmt->execute();
79 $stmt->store_result();
80 $res = $stmt->result_metadata();
89 $stmt->close();
92 $stmt = mysqli_stmt_init($link);
93 $stmt->prepare("SELECT label FROM test");
94 $stmt->attr_set(MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH, 1);
95 $res = $stmt->attr_get(MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH);
98 $stmt->execute();
99 $stmt->store_result();
100 $res = $stmt->result_metadata();
109 $stmt->close();
112 $stmt = mysqli_stmt_init($link);
113 $stmt->prepare("SELECT label FROM test");
114 $stmt->attr_set(MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH, 0);
115 $res = $stmt->attr_get(MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH);
118 $stmt->execute();
119 $stmt->store_result();
120 $res = $stmt->result_metadata();
129 $stmt->close();
147 $stmt = mysqli_stmt_init($link);
148 $stmt->prepare("SELECT id, label FROM test");
150 if (false !== ($tmp = @$stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, $invalid_cursor_type)))
153 …if (false !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_FOR_UPDATE)…
156 …if (false !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_SCROLLABLE)…
159 … if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_NO_CURSOR)))
162 … if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY)))
165 $stmt->close();
167 $stmt = mysqli_stmt_init($link);
168 $stmt->prepare("SELECT id, label FROM test");
169 $stmt->execute();
171 $stmt->bind_result($id, $label);
173 while ($stmt->fetch())
175 $stmt->close();
179 $stmt = mysqli_stmt_init($link);
180 $stmt->prepare("SELECT id, label FROM test");
181 … if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_NO_CURSOR)))
183 $stmt->execute();
185 $stmt->bind_result($id, $label);
187 while ($stmt->fetch())
189 $stmt->close();
196 $stmt = mysqli_stmt_init($link);
197 $stmt->prepare("SELECT id, label FROM test");
198 … if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY)))
200 $stmt->execute();
202 $stmt->bind_result($id, $label);
204 while ($stmt->fetch())
206 $stmt->close();
222 $stmt = mysqli_stmt_init($link);
223 $stmt->prepare("SELECT id, label FROM test");
224 if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_PREFETCH_ROWS, 1)))
226 $stmt->execute();
228 $stmt->bind_result($id, $label);
230 while ($stmt->fetch())
232 $stmt->close();
237 $stmt = mysqli_stmt_init($link);
238 $stmt->prepare("SELECT label FROM test");
239 if (false !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_PREFETCH_ROWS, -1)))
241 $stmt->close();
243 $stmt = mysqli_stmt_init($link);
244 $stmt->prepare("SELECT label FROM test");
245 if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_PREFETCH_ROWS, PHP_INT_MAX)))
247 $stmt->close();
249 $stmt = mysqli_stmt_init($link);
250 $stmt->prepare("SELECT id, label FROM test");
251 if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_PREFETCH_ROWS, 2)))
253 $stmt->execute();
255 $stmt->bind_result($id, $label);
257 while ($stmt->fetch())
259 $stmt->close();
