xref: /PHP-8.2/ext/pdo/tests/pdo_019.phpt (revision 74859783)
1--TEST--
2PDO Common: fetch() and while()
3--EXTENSIONS--
4pdo
5--SKIPIF--
6<?php
7$dir = getenv('REDIR_TEST_DIR');
8if (false == $dir) die('skip no driver');
9require_once $dir . 'pdo_test.inc';
10PDOTest::skip();
11?>
12--FILE--
13<?php
14if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.__DIR__ . '/../../pdo/tests/');
15require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
16$db = PDOTest::factory();
17
18$db->exec('CREATE TABLE test(idx int NOT NULL PRIMARY KEY, txt VARCHAR(20))');
19$db->exec('INSERT INTO test VALUES(0, \'String0\')');
20$db->exec('INSERT INTO test VALUES(1, \'String1\')');
21$db->exec('INSERT INTO test VALUES(2, \'String2\')');
22$db->exec('INSERT INTO test VALUES(3, \'String3\')');
23
24
25var_dump($db->query('SELECT COUNT(*) FROM test')->fetchColumn());
26
27$stmt = $db->prepare('SELECT idx, txt FROM test ORDER by idx');
28
29$stmt->execute();
30$cont = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE);
31var_dump($cont);
32
33echo "===WHILE===\n";
34
35$stmt->bindColumn('idx', $idx);
36$stmt->bindColumn('txt', $txt);
37$stmt->execute();
38
39while($stmt->fetch(PDO::FETCH_BOUND)) {
40    var_dump(array($idx=>$txt));
41}
42
43?>
44--EXPECT--
45string(1) "4"
46array(4) {
47  [0]=>
48  string(7) "String0"
49  [1]=>
50  string(7) "String1"
51  [2]=>
52  string(7) "String2"
53  [3]=>
54  string(7) "String3"
55}
56===WHILE===
57array(1) {
58  [0]=>
59  string(7) "String0"
60}
61array(1) {
62  [1]=>
63  string(7) "String1"
64}
65array(1) {
66  [2]=>
67  string(7) "String2"
68}
69array(1) {
70  [3]=>
71  string(7) "String3"
72}
73