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

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))