Return to last_insert_id.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / pdo_mysql / tests

Annotation of embedaddon/php/ext/pdo_mysql/tests/last_insert_id.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: PDO MySQL auto_increment / last insert id
                      3: --SKIPIF--
                      4: <?php
                      5: if (!extension_loaded('pdo') || !extension_loaded('pdo_mysql')) die('skip not loaded');
                      6: require dirname(__FILE__) . '/config.inc';
                      7: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
                      8: PDOTest::skip();
                      9: ?>
                     10: --FILE--
                     11: <?php
                     12: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
                     13: $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
                     14: 
                     15: print_r($db->query("CREATE TABLE test (id int auto_increment primary key, num int)"));
                     16: 
                     17: print_r($db->query("INSERT INTO test (id, num) VALUES (23, 42)"));
                     18: 
                     19: print_r($db->query("INSERT INTO test (num) VALUES (451)"));
                     20: 
                     21: print_r($db->lastInsertId());
                     22: --EXPECT--
                     23: PDOStatement Object
                     24: (
                     25:     [queryString] => CREATE TABLE test (id int auto_increment primary key, num int)
                     26: )
                     27: PDOStatement Object
                     28: (
                     29:     [queryString] => INSERT INTO test (id, num) VALUES (23, 42)
                     30: )
                     31: PDOStatement Object
                     32: (
                     33:     [queryString] => INSERT INTO test (num) VALUES (451)
                     34: )
                     35: 24