pdo_mysql_last_insert_id.phpt - OpenGrok cross reference for /php-src/ext/pdo_mysql/tests/pdo_mysql_last_insert

Lines Matching refs:db
13     $db = MySQLPDOTest::factory();
16         if ('0' !== ($tmp = $db->lastInsertId()))
20         if ('0' !== ($tmp = $db->lastInsertId('sequence_name')))
24         if ('0' !== ($tmp = $db->lastInsertId()))
27 …$db->exec(sprintf('CREATE TABLE test_pdo_mysql_last_insert_id(id INT, col1 CHAR(10)) ENGINE=%s', P…
28         if ('0' !== ($tmp = $db->lastInsertId()))
31         $stmt = $db->query('SELECT id FROM test_pdo_mysql_last_insert_id LIMIT 1');
32         if ('0' !== ($tmp = $db->lastInsertId()))
36         $db->exec("INSERT INTO test_pdo_mysql_last_insert_id(id, col1) VALUES (100, 'a')");
37         if ('0' !== ($tmp = $db->lastInsertId()))
40 …   $db->exec('ALTER TABLE test_pdo_mysql_last_insert_id MODIFY id INT AUTO_INCREMENT PRIMARY KEY');
41         if ('0' !== ($tmp = $db->lastInsertId()))
45         @$db->exec("INSERT INTO test_pdo_mysql_last_insert_id(id, col1) VALUES (100, 'a')");
46         if ('0' !== ($tmp = $db->lastInsertId()))
49         $db->exec("INSERT INTO test_pdo_mysql_last_insert_id(id, col1) VALUES (101, 'b')");
50         if ('101' !== ($tmp = $db->lastInsertId()))
53         $db->exec('ALTER TABLE test_pdo_mysql_last_insert_id MODIFY col1 CHAR(10) UNIQUE');
55         $db->exec("REPLACE INTO test_pdo_mysql_last_insert_id(col1) VALUES ('b')");
56         $next_id = (int)$db->lastInsertId();
61         $stmt = $db->query('SELECT LAST_INSERT_ID() AS _last_id');
69         $db->exec("INSERT INTO test_pdo_mysql_last_insert_id(col1) VALUES ('c'), ('d'), ('e')");
70         $next_id = (int)$db->lastInsertId();
75         $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
78             $db->exec('LOCK TABLE test_pdo_mysql_last_insert_id WRITE');
81             if (MySQLPDOTest::getServerVersion($db) >= 50000) {
82                 $stmt = $db->query('SELECT @@auto_increment_increment AS inc');
89             $stmt = $db->query('SELECT LAST_INSERT_ID() AS _last_id');
93             $db->exec("INSERT INTO test_pdo_mysql_last_insert_id(col1) VALUES ('z')");
94             $next_id = (int)$db->lastInsertId();
100 … printf("[014] %s, [%s} %s\n", $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
102         $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
103         @$db->exec('UNLOCK TABLE test_pdo_mysql_last_insert_id');
107             $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
115 $db = MySQLPDOTest::factory();
116 $db->exec('DROP TABLE IF EXISTS test_pdo_mysql_last_insert_id');