diff options
Diffstat (limited to 'ext/mysqli/tests/014.phpt')
| -rw-r--r-- | ext/mysqli/tests/014.phpt | 97 |
1 files changed, 97 insertions, 0 deletions
diff --git a/ext/mysqli/tests/014.phpt b/ext/mysqli/tests/014.phpt new file mode 100644 index 0000000..da6a005 --- /dev/null +++ b/ext/mysqli/tests/014.phpt @@ -0,0 +1,97 @@ +--TEST-- +mysqli autocommit/commit/rollback +--SKIPIF-- +<?php + require_once('skipif.inc'); + require_once('skipifconnectfailure.inc'); + require_once("connect.inc"); + + $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); + if (!$link) + die(sprintf("Cannot connect, [%d] %s", mysqli_connect_errno(), mysqli_connect_error())); + + if (!have_innodb($link)) + die(sprintf("Needs InnoDB support, [%d] %s", $link->errno, $link->error)); +?> +--FILE-- +<?php + require_once("connect.inc"); + $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); + + if (!mysqli_autocommit($link, TRUE)) + printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!mysqli_query($link, "DROP TABLE IF EXISTS test")) + printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!mysqli_query($link, "CREATE TABLE test(a int, b varchar(10)) engine=InnoDB")) + printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!mysqli_query($link, "INSERT INTO test VALUES (1, 'foobar')")) + printf("[004] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!mysqli_autocommit($link, FALSE)) + printf("[005] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!mysqli_query($link, "DELETE FROM test")) + printf("[006] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')")) + printf("[007] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!mysqli_rollback($link)) + printf("[008] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!$result = mysqli_query($link, "SELECT * FROM test")) + printf("[009] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + printf("Num_of_rows=%d\n", mysqli_num_rows($result)); + if (!$row = mysqli_fetch_row($result)) + printf("[010] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + mysqli_free_result($result); + + var_dump($row); + + if (!mysqli_query($link, "DELETE FROM test")) + printf("[011] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')")) + printf("[012] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!mysqli_commit($link)) + printf("[012] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!$result = mysqli_query($link, "SELECT * FROM test")) + printf("[013] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!$row = mysqli_fetch_row($result)) + printf("[014] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + mysqli_free_result($result); + + var_dump($row); + + mysqli_query($link, "DROP TABLE IF EXISTS test"); + mysqli_close($link); + print "done!"; +?> +--CLEAN-- +<?php + require_once("clean_table.inc"); +?> +--EXPECTF-- +Num_of_rows=1 +array(2) { + [0]=> + %unicode|string%(1) "1" + [1]=> + %unicode|string%(6) "foobar" +} +array(2) { + [0]=> + %unicode|string%(1) "2" + [1]=> + %unicode|string%(4) "egon" +} +done!
\ No newline at end of file |