pdo_mysql_stmt_bindvalue.phpt - OpenGrok cross reference for /PHP-8.2/ext/pdo_mysql/tests/pdo_mysql_stmt

Lines Matching refs:stmt
25         $stmt = $db->prepare("SELECT id, label FROM {$table} WHERE id > ? ORDER BY id ASC LIMIT 2");
27         if (!$stmt->bindValue(1, $in))
29                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
31         $stmt->execute();
34         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
36                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
38         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
40                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
42         while ($stmt->fetch(PDO::FETCH_BOUND))
49         if (!$stmt->bindValue(1, 0))
51                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
53         $stmt->execute();
56         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
58                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
60         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
62                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
64         while ($stmt->fetch(PDO::FETCH_BOUND))
73         if (!$stmt->bindValue(1, $in_ref))
75                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
77         $stmt->execute();
80         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
82                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
84         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
86                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
88         while ($stmt->fetch(PDO::FETCH_BOUND))
96 …$stmt = $db->prepare("SELECT id, label FROM {$table} WHERE id > ? AND id <= ? ORDER BY id ASC LIMI…
98         if (!$stmt->bindValue(1, $in))
100                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
102         if (!$stmt->bindValue(2, 2))
104                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
106         $stmt->execute();
109         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
111                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
113         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
115                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
117         while ($stmt->fetch(PDO::FETCH_BOUND))
125 …$stmt = $db->prepare("SELECT id, label FROM {$table} WHERE id > ? AND id <= ? ORDER BY id ASC LIMI…
127         if (!$stmt->bindValue(1, $in))
129                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
132         if (!$stmt->bindValue(2, $in))
134                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
136         $stmt->execute();
139         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
141                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
143         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
145                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
147         while ($stmt->fetch(PDO::FETCH_BOUND))
165         $stmt = $db->prepare("SELECT id, label FROM {$table} WHERE id > ? ORDER BY id ASC LIMIT 2");
167         if (!$stmt->bindValue(1, $in))
169                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
171         $stmt->execute();
174         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
176                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
178         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
180                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
182         while ($stmt->fetch(PDO::FETCH_BOUND))
189         if (!$stmt->bindValue(1, 0))
191                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
193         $stmt->execute();
196         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
198                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
200         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
202                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
204         while ($stmt->fetch(PDO::FETCH_BOUND))
213         if (!$stmt->bindValue(1, $in_ref))
215                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
217         $stmt->execute();
220         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
222                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
224         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
226                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
228         while ($stmt->fetch(PDO::FETCH_BOUND))
236 …$stmt = $db->prepare("SELECT id, label FROM {$table} WHERE id > ? AND id <= ? ORDER BY id ASC LIMI…
238         if (!$stmt->bindValue(1, $in))
240                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
242         if (!$stmt->bindValue(2, 2))
244                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
246         $stmt->execute();
249         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
251                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
253         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
255                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
257         while ($stmt->fetch(PDO::FETCH_BOUND))
265 …$stmt = $db->prepare("SELECT id, label FROM {$table} WHERE id > ? AND id <= ? ORDER BY id ASC LIMI…
267         if (!$stmt->bindValue(1, $in))
269                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
272         if (!$stmt->bindValue(2, $in))
274                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
276         $stmt->execute();
279         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
281                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
283         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
285                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
287         while ($stmt->fetch(PDO::FETCH_BOUND))