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