1234567891011121314151617181920212223242526272829303132 |
- --TEST--
- PDO_sqlite: Testing lastInsertId()
- --SKIPIF--
- <?php if (!extension_loaded('pdo_sqlite')) print 'skip not loaded'; ?>
- --FILE--
- <?php
- $db = new pdo('sqlite::memory:');
- $db->query('CREATE TABLE IF NOT EXISTS foo (id INT AUTO INCREMENT, name TEXT)');
- $db->query('INSERT INTO foo VALUES (NULL, "PHP")');
- $db->query('INSERT INTO foo VALUES (NULL, "PHP6")');
- var_dump($db->query('SELECT * FROM foo'));
- var_dump($db->errorInfo());
- var_dump($db->lastInsertId());
- $db->query('DROP TABLE foo');
- ?>
- --EXPECTF--
- object(PDOStatement)#2 (1) {
- ["queryString"]=>
- string(17) "SELECT * FROM foo"
- }
- array(3) {
- [0]=>
- string(5) "00000"
- [1]=>
- NULL
- [2]=>
- NULL
- }
- string(1) "2"
|