pdo_023.phpt 2.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113
  1. --TEST--
  2. PDO Common: extending PDO
  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. class PDOStatementX extends PDOStatement
  17. {
  18. public $test1 = 1;
  19. protected function __construct()
  20. {
  21. $this->test2 = 2;
  22. $this->test2 = 22;
  23. echo __METHOD__ . "()\n";
  24. }
  25. function __destruct()
  26. {
  27. echo __METHOD__ . "()\n";
  28. }
  29. }
  30. class PDODatabaseX extends PDO
  31. {
  32. public $test1 = 1;
  33. function __destruct()
  34. {
  35. echo __METHOD__ . "()\n";
  36. }
  37. function test()
  38. {
  39. $this->test2 = 2;
  40. var_dump($this->test1);
  41. var_dump($this->test2);
  42. $this->test2 = 22;
  43. }
  44. function query($sql, ...$rest): PDOStatement|false
  45. {
  46. echo __METHOD__ . "()\n";
  47. $stmt = parent::prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('PDOStatementx')));
  48. $stmt->execute();
  49. return $stmt;
  50. }
  51. }
  52. $db = PDOTest::factory('PDODatabaseX');
  53. $db->test();
  54. var_dump($db);
  55. $db->query('CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10))');
  56. $db->query('INSERT INTO test VALUES(0, \'A\')');
  57. $db->query('INSERT INTO test VALUES(1, \'B\')');
  58. $stmt = $db->query('SELECT val, id FROM test');
  59. var_dump($stmt);
  60. var_dump($stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE));
  61. $stmt = NULL;
  62. $db = NULL;
  63. ?>
  64. --EXPECTF--
  65. int(1)
  66. int(2)
  67. object(PDODatabaseX)#%d (2) {
  68. ["test1"]=>
  69. int(1)
  70. ["test2"]=>
  71. int(22)
  72. }
  73. PDODatabaseX::query()
  74. PDOStatementX::__construct()
  75. PDOStatementX::__destruct()
  76. PDODatabaseX::query()
  77. PDOStatementX::__construct()
  78. PDOStatementX::__destruct()
  79. PDODatabaseX::query()
  80. PDOStatementX::__construct()
  81. PDOStatementX::__destruct()
  82. PDODatabaseX::query()
  83. PDOStatementX::__construct()
  84. object(PDOStatementX)#%d (3) {
  85. ["queryString"]=>
  86. string(24) "SELECT val, id FROM test"
  87. ["test1"]=>
  88. int(1)
  89. ["test2"]=>
  90. int(22)
  91. }
  92. array(2) {
  93. ["A"]=>
  94. string(1) "0"
  95. ["B"]=>
  96. string(1) "1"
  97. }
  98. PDOStatementX::__destruct()
  99. PDODatabaseX::__destruct()