1--TEST-- 2PDO Common: PDO::FETCH_ASSOC 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(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); 19$db->exec("INSERT INTO test VALUES(1, 'A')"); 20$db->exec("INSERT INTO test VALUES(2, 'B')"); 21$db->exec("INSERT INTO test VALUES(3, 'C')"); 22 23$stmt = $db->prepare('SELECT * from test'); 24$stmt->execute(); 25 26var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 27?> 28--EXPECT-- 29array(3) { 30 [0]=> 31 array(2) { 32 ["id"]=> 33 string(1) "1" 34 ["val"]=> 35 string(1) "A" 36 } 37 [1]=> 38 array(2) { 39 ["id"]=> 40 string(1) "2" 41 ["val"]=> 42 string(1) "B" 43 } 44 [2]=> 45 array(2) { 46 ["id"]=> 47 string(1) "3" 48 ["val"]=> 49 string(1) "C" 50 } 51} 52
