xref: /php-src/ext/pdo/tests/pdo_004.phpt (revision f4a5db3e)
1--TEST--
2PDO Common: PDO::FETCH_OBJ
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 test004(id int NOT NULL PRIMARY KEY, val VARCHAR(10))');
19$db->exec("INSERT INTO test004 VALUES(1, 'A')");
20$db->exec("INSERT INTO test004 VALUES(2, 'B')");
21$db->exec("INSERT INTO test004 VALUES(3, 'C')");
22
23$stmt = $db->prepare('SELECT * from test004');
24$stmt->execute();
25
26var_dump($stmt->fetchAll(PDO::FETCH_OBJ));
27?>
28--CLEAN--
29<?php
30require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
31$db = PDOTest::factory();
32PDOTest::dropTableIfExists($db, "test004");
33?>
34--EXPECTF--
35array(3) {
36  [0]=>
37  object(stdClass)#%d (2) {
38    ["id"]=>
39    string(1) "1"
40    ["val"]=>
41    string(1) "A"
42  }
43  [1]=>
44  object(stdClass)#%d (2) {
45    ["id"]=>
46    string(1) "2"
47    ["val"]=>
48    string(1) "B"
49  }
50  [2]=>
51  object(stdClass)#%d (2) {
52    ["id"]=>
53    string(1) "3"
54    ["val"]=>
55    string(1) "C"
56  }
57}
58