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

Lines Matching refs:stmt
24         $stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? ORDER BY id ASC LIMIT 2');
26         if (!$stmt->bindValue(1, $in))
28                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
30         $stmt->execute();
33         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
35                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
37         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
39                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
41         while ($stmt->fetch(PDO::FETCH_BOUND))
48         if (!$stmt->bindValue(1, 0))
50                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
52         $stmt->execute();
55         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
57                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
59         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
61                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
63         while ($stmt->fetch(PDO::FETCH_BOUND))
72         if (!$stmt->bindValue(1, $in_ref))
74                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
76         $stmt->execute();
79         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
81                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
83         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
85                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
87         while ($stmt->fetch(PDO::FETCH_BOUND))
95 …$stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? AND id <= ? ORDER BY id ASC LIMIT 2'…
97         if (!$stmt->bindValue(1, $in))
99                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
101         if (!$stmt->bindValue(2, 2))
103                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
105         $stmt->execute();
108         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
110                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
112         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
114                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
116         while ($stmt->fetch(PDO::FETCH_BOUND))
124 …$stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? AND id <= ? ORDER BY id ASC LIMIT 2'…
126         if (!$stmt->bindValue(1, $in))
128                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
131         if (!$stmt->bindValue(2, $in))
133                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
135         $stmt->execute();
138         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
140                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
142         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
144                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
146         while ($stmt->fetch(PDO::FETCH_BOUND))
164         $stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? ORDER BY id ASC LIMIT 2');
166         if (!$stmt->bindValue(1, $in))
168                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
170         $stmt->execute();
173         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
175                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
177         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
179                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
181         while ($stmt->fetch(PDO::FETCH_BOUND))
188         if (!$stmt->bindValue(1, 0))
190                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
192         $stmt->execute();
195         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
197                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
199         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
201                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
203         while ($stmt->fetch(PDO::FETCH_BOUND))
212         if (!$stmt->bindValue(1, $in_ref))
214                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
216         $stmt->execute();
219         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
221                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
223         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
225                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
227         while ($stmt->fetch(PDO::FETCH_BOUND))
235 …$stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? AND id <= ? ORDER BY id ASC LIMIT 2'…
237         if (!$stmt->bindValue(1, $in))
239                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
241         if (!$stmt->bindValue(2, 2))
243                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
245         $stmt->execute();
248         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
250                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
252         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
254                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
256         while ($stmt->fetch(PDO::FETCH_BOUND))
264 …$stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? AND id <= ? ORDER BY id ASC LIMIT 2'…
266         if (!$stmt->bindValue(1, $in))
268                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
271         if (!$stmt->bindValue(2, $in))
273                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
275         $stmt->execute();
278         if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
280                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
282         if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
284                 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
286         while ($stmt->fetch(PDO::FETCH_BOUND))