pdo_008.phpt 905 B

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. --TEST--
  2. PDO Common: PDO::FETCH_UNIQUE conflict
  3. --EXTENSIONS--
  4. pdo
  5. --SKIPIF--
  6. <?php
  7. $dir = getenv('REDIR_TEST_DIR');
  8. if (false == $dir) die('skip no driver');
  9. require_once $dir . 'pdo_test.inc';
  10. PDOTest::skip();
  11. ?>
  12. --FILE--
  13. <?php
  14. if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.__DIR__ . '/../../pdo/tests/');
  15. require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
  16. $db = PDOTest::factory();
  17. $db->exec('CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))');
  18. $db->exec("INSERT INTO test VALUES('A', 'A')");
  19. $db->exec("INSERT INTO test VALUES('B', 'A')");
  20. $db->exec("INSERT INTO test VALUES('C', 'C')");
  21. $stmt = $db->prepare('SELECT val, id from test');
  22. $stmt->execute();
  23. var_dump($stmt->fetchAll(PDO::FETCH_NUM|PDO::FETCH_UNIQUE));
  24. ?>
  25. --EXPECT--
  26. array(2) {
  27. ["A"]=>
  28. array(1) {
  29. [0]=>
  30. string(1) "B"
  31. }
  32. ["C"]=>
  33. array(1) {
  34. [0]=>
  35. string(1) "C"
  36. }
  37. }