pdo_sqlite_lastinsertid.phpt 680 B

1234567891011121314151617181920212223242526272829303132
  1. --TEST--
  2. PDO_sqlite: Testing lastInsertId()
  3. --SKIPIF--
  4. <?php if (!extension_loaded('pdo_sqlite')) print 'skip not loaded'; ?>
  5. --FILE--
  6. <?php
  7. $db = new pdo('sqlite::memory:');
  8. $db->query('CREATE TABLE IF NOT EXISTS foo (id INT AUTO INCREMENT, name TEXT)');
  9. $db->query('INSERT INTO foo VALUES (NULL, "PHP")');
  10. $db->query('INSERT INTO foo VALUES (NULL, "PHP6")');
  11. var_dump($db->query('SELECT * FROM foo'));
  12. var_dump($db->errorInfo());
  13. var_dump($db->lastInsertId());
  14. $db->query('DROP TABLE foo');
  15. ?>
  16. --EXPECTF--
  17. object(PDOStatement)#2 (1) {
  18. ["queryString"]=>
  19. string(17) "SELECT * FROM foo"
  20. }
  21. array(3) {
  22. [0]=>
  23. string(5) "00000"
  24. [1]=>
  25. NULL
  26. [2]=>
  27. NULL
  28. }
  29. string(1) "2"