Lines Matching refs:stmt
23 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? ORDER BY id ASC LIMIT 2');
25 if (!$stmt->bindValue(1, $in))
27 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
29 $stmt->execute();
32 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
34 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
36 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
38 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
40 while ($stmt->fetch(PDO::FETCH_BOUND))
47 if (!$stmt->bindValue(1, 0))
49 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
51 $stmt->execute();
54 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
56 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
58 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
60 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
62 while ($stmt->fetch(PDO::FETCH_BOUND))
71 if (!$stmt->bindValue(1, $in_ref))
73 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
75 $stmt->execute();
78 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
80 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
82 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
84 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
86 while ($stmt->fetch(PDO::FETCH_BOUND))
94 …$stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? AND id <= ? ORDER BY id ASC LIMIT 2'…
96 if (!$stmt->bindValue(1, $in))
98 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
100 if (!$stmt->bindValue(2, 2))
102 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
104 $stmt->execute();
107 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
109 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
111 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
113 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
115 while ($stmt->fetch(PDO::FETCH_BOUND))
123 …$stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? AND id <= ? ORDER BY id ASC LIMIT 2'…
125 if (!$stmt->bindValue(1, $in))
127 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
130 if (!$stmt->bindValue(2, $in))
132 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
134 $stmt->execute();
137 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
139 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
141 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
143 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
145 while ($stmt->fetch(PDO::FETCH_BOUND))
163 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? ORDER BY id ASC LIMIT 2');
165 if (!$stmt->bindValue(1, $in))
167 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
169 $stmt->execute();
172 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
174 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
176 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
178 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
180 while ($stmt->fetch(PDO::FETCH_BOUND))
187 if (!$stmt->bindValue(1, 0))
189 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
191 $stmt->execute();
194 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
196 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
198 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
200 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
202 while ($stmt->fetch(PDO::FETCH_BOUND))
211 if (!$stmt->bindValue(1, $in_ref))
213 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
215 $stmt->execute();
218 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
220 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
222 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
224 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
226 while ($stmt->fetch(PDO::FETCH_BOUND))
234 …$stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? AND id <= ? ORDER BY id ASC LIMIT 2'…
236 if (!$stmt->bindValue(1, $in))
238 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
240 if (!$stmt->bindValue(2, 2))
242 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
244 $stmt->execute();
247 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
249 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
251 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
253 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
255 while ($stmt->fetch(PDO::FETCH_BOUND))
263 …$stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? AND id <= ? ORDER BY id ASC LIMIT 2'…
265 if (!$stmt->bindValue(1, $in))
267 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
270 if (!$stmt->bindValue(2, $in))
272 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
274 $stmt->execute();
277 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
279 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
281 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
283 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
285 while ($stmt->fetch(PDO::FETCH_BOUND))
