Annotation of embedaddon/php/ext/mysqli/tests/014.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: mysqli autocommit/commit/rollback
! 3: --SKIPIF--
! 4: <?php
! 5: require_once('skipif.inc');
! 6: require_once('skipifconnectfailure.inc');
! 7: require_once("connect.inc");
! 8:
! 9: $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
! 10: if (!$link)
! 11: die(sprintf("Cannot connect, [%d] %s", mysqli_connect_errno(), mysqli_connect_error()));
! 12:
! 13: if (!have_innodb($link))
! 14: die(sprintf("Needs InnoDB support, [%d] %s", $link->errno, $link->error));
! 15: ?>
! 16: --FILE--
! 17: <?php
! 18: require_once("connect.inc");
! 19: $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
! 20:
! 21: if (!mysqli_autocommit($link, TRUE))
! 22: printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 23:
! 24: if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
! 25: printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 26:
! 27: if (!mysqli_query($link, "CREATE TABLE test(a int, b varchar(10)) engine=InnoDB"))
! 28: printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 29:
! 30: if (!mysqli_query($link, "INSERT INTO test VALUES (1, 'foobar')"))
! 31: printf("[004] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 32:
! 33: if (!mysqli_autocommit($link, FALSE))
! 34: printf("[005] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 35:
! 36: if (!mysqli_query($link, "DELETE FROM test"))
! 37: printf("[006] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 38:
! 39: if (!mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')"))
! 40: printf("[007] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 41:
! 42: if (!mysqli_rollback($link))
! 43: printf("[008] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 44:
! 45: if (!$result = mysqli_query($link, "SELECT * FROM test"))
! 46: printf("[009] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 47:
! 48: printf("Num_of_rows=%d\n", mysqli_num_rows($result));
! 49: if (!$row = mysqli_fetch_row($result))
! 50: printf("[010] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 51:
! 52: mysqli_free_result($result);
! 53:
! 54: var_dump($row);
! 55:
! 56: if (!mysqli_query($link, "DELETE FROM test"))
! 57: printf("[011] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 58:
! 59: if (!mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')"))
! 60: printf("[012] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 61:
! 62: if (!mysqli_commit($link))
! 63: printf("[012] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 64:
! 65: if (!$result = mysqli_query($link, "SELECT * FROM test"))
! 66: printf("[013] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 67:
! 68: if (!$row = mysqli_fetch_row($result))
! 69: printf("[014] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 70:
! 71: mysqli_free_result($result);
! 72:
! 73: var_dump($row);
! 74:
! 75: mysqli_query($link, "DROP TABLE IF EXISTS test");
! 76: mysqli_close($link);
! 77: print "done!";
! 78: ?>
! 79: --CLEAN--
! 80: <?php
! 81: require_once("clean_table.inc");
! 82: ?>
! 83: --EXPECTF--
! 84: Num_of_rows=1
! 85: array(2) {
! 86: [0]=>
! 87: %unicode|string%(1) "1"
! 88: [1]=>
! 89: %unicode|string%(6) "foobar"
! 90: }
! 91: array(2) {
! 92: [0]=>
! 93: %unicode|string%(1) "2"
! 94: [1]=>
! 95: %unicode|string%(4) "egon"
! 96: }
! 97: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>