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