Return to mysqli_insert_id_variation.phpt CVS log

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

Annotation of embedaddon/php/ext/mysqli/tests/mysqli_insert_id_variation.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: Checking last_insert_id after different operations
                      3: --SKIPIF--
                      4: <?php
                      5: require_once('skipif.inc');
                      6: require_once('skipifconnectfailure.inc');
                      7: ?>
                      8: --FILE--
                      9: <?php
                     10: require_once("connect.inc");
                     11: 
                     12: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
                     13:     printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
                     14:                         $host, $user, $db, $port, $socket);
                     15: 
                     16: $link->query("DROP TABLE IF EXISTS test_insert_id_var");
                     17: $link->query("CREATE TABLE test_insert_id_var (id INT auto_increment, PRIMARY KEY (id))");
                     18: $link->query("INSERT INTO test_insert_id_var VALUES (null)");
                     19: $i = $link->insert_id;
                     20: 
                     21: if (!$i) {
                     22:     printf("[001] Got no valid insert id: %s", var_export($i, true));
                     23:     die();
                     24: }
                     25: 
                     26: 
                     27: $link->options(MYSQLI_OPT_LOCAL_INFILE, false);
                     28: if ($i != $link->insert_id || $i != mysqli_insert_id($link)) {
                     29:     printf("[002] mysqli_option changes insert_id: %s", var_export($link->insert_id, true));
                     30:     die();
                     31: }
                     32: 
                     33: /*
                     34: $link->dump_debug_info();
                     35: if ($i != $link->insert_id || $i != mysqli_insert_id($link)) {
                     36:     printf("[003] mysqli_debug_info changes insert_id: %s", var_export($link->insert_id, true));
                     37:     die();
                     38: }
                     39: */
                     40: 
                     41: $link->stat();
                     42: if ($i != $link->insert_id || $i != mysqli_insert_id($link)) {
                     43:     printf("[004] mysqli_stat changes insert_id: %s", var_export($link->insert_id, true));
                     44:     die();
                     45: }
                     46: 
                     47: /*$link->kill($link->thread_id);
                     48: if ($i != $link->insert_id || $i != mysqli_insert_id($link)) {
                     49:     printf("[005] mysqli_kill changes insert_id: %s", var_export($link->insert_id, true));
                     50:     die();
                     51: }*/
                     52: 
                     53: $link->ping();
                     54: if ($i != $link->insert_id || $i != mysqli_insert_id($link)) {
                     55:     printf("[006] mysqli_ping changes insert_id: %s", var_export($link->insert_id, true));
                     56:     die();
                     57: }
                     58: 
                     59: /*
                     60: mysqlnd resets the IDE to 0
                     61: libmysql doesn't
                     62: 
                     63: $link->change_user ($user, $passwd, $db);
                     64: if (0 != $link->insert_id || 0 != mysqli_insert_id($link)) {
                     65:     printf("[007] mysqli_change_user changes insert_id: %s", var_export($link->insert_id, true));
                     66:     die();
                     67: }
                     68: */
                     69: 
                     70: $stmt = $link->prepare("SELECT 1");
                     71: if ($i != $link->insert_id || $i != mysqli_insert_id($link)) {
                     72:     printf("[008a] mysqli_prepare changes insert_id: %s", var_export($link->insert_id, true));
                     73:     die();
                     74: }
                     75: echo mysqli_error($link);
                     76: if (0 != $stmt->insert_id || 0 != mysqli_stmt_insert_id($stmt)) {
                     77:     printf("[008b] mysqli_stmt doesn't initialise insert_id: %s", var_export($stmt->insert_id, true));
                     78:     die();
                     79: }
                     80: 
                     81: unset($stmt);
                     82: if ($i != $link->insert_id || $i != mysqli_insert_id($link)) {
                     83:     printf("[009] stmt free changes insert_id: %s", var_export($link->insert_id, true));
                     84:     die();
                     85: }
                     86: 
                     87: $link->query("DROP TABLE IF EXISTS test_insert_id_var");
                     88: 
                     89: echo "DONE";
                     90: ?>
                     91: --CLEAN--
                     92: <?php
                     93: require_once("connect.inc");
                     94: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
                     95:    printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
                     96: 
                     97: if (!mysqli_query($link, "DROP TABLE IF EXISTS test_insert_id_var"))
                     98:        printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
                     99: 
                    100: mysqli_close($link);
                    101: ?>
                    102: --EXPECTF--
                    103: DONE