diff options
Diffstat (limited to 'ext/mysqli/tests/015.phpt')
| -rw-r--r-- | ext/mysqli/tests/015.phpt | 49 |
1 files changed, 35 insertions, 14 deletions
diff --git a/ext/mysqli/tests/015.phpt b/ext/mysqli/tests/015.phpt index f68e9aa72a..ac50fc8c6d 100644 --- a/ext/mysqli/tests/015.phpt +++ b/ext/mysqli/tests/015.phpt @@ -20,39 +20,60 @@ mysqli autocommit/commit/rollback with innodb include "connect.inc"; $link = mysqli_connect($host, $user, $passwd, $db, $port, $socket); + if (!$link) + printf("[001] Cannot connect, [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error()); - mysqli_select_db($link, $db); + if (!mysqli_select_db($link, $db)) + printf("[002] Cannot select DB '%s', [%d] %s\n", $db, + mysqli_errno($link), mysqli_error($link)); - mysqli_autocommit($link, TRUE); + if (!mysqli_autocommit($link, TRUE)) + printf("[003] Cannot turn on autocommit mode, [%d] %s\n", + mysqli_errno($link), mysqli_error($link)); - mysqli_query($link,"DROP TABLE IF EXISTS ac_01"); + if (!mysqli_query($link,"DROP TABLE IF EXISTS test") || + !mysqli_query($link,"CREATE TABLE test(a int, b varchar(10)) Engine=InnoDB") || + !mysqli_query($link, "INSERT INTO test VALUES (1, 'foobar')")) + printf("[004] Cannot create test data, [%d] %s\n", + mysqli_errno($link), mysqli_error($link)); - mysqli_query($link,"CREATE TABLE ac_01(a int, b varchar(10)) Engine=InnoDB"); + if (!mysqli_autocommit($link, FALSE)) + printf("[005] Cannot turn off autocommit mode, [%d] %s\n", + mysqli_errno($link), mysqli_error($link)); - mysqli_query($link, "INSERT INTO ac_01 VALUES (1, 'foobar')"); - mysqli_autocommit($link, FALSE); + if (!mysqli_query($link, "DELETE FROM test") || + !mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')")) + printf("[006] Cannot modify test data, [%d] %s\n", + mysqli_errno($link), mysqli_error($link)); - mysqli_query($link, "DELETE FROM ac_01"); - mysqli_query($link, "INSERT INTO ac_01 VALUES (2, 'egon')"); + if (!mysqli_rollback($link)) + printf("[007] Cannot call rollback, [%d] %s\n", + mysqli_errno($link), mysqli_error($link)); - mysqli_rollback($link); - - $result = mysqli_query($link, "SELECT SQL_NO_CACHE * FROM ac_01"); + $result = mysqli_query($link, "SELECT SQL_NO_CACHE * FROM test"); + if (!$result) + printf("[008] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); $row = mysqli_fetch_row($result); mysqli_free_result($result); var_dump($row); - mysqli_query($link, "DELETE FROM ac_01"); - mysqli_query($link, "INSERT INTO ac_01 VALUES (2, 'egon')"); + if (!mysqli_query($link, "DELETE FROM test") || + !mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')")) + printf("[009] Cannot modify test data, [%d] %s\n", + mysqli_errno($link), mysqli_error($link)); + mysqli_commit($link); - $result = mysqli_query($link, "SELECT * FROM ac_01"); + $result = mysqli_query($link, "SELECT * FROM test"); + if (!$result) + printf("[010] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); $row = mysqli_fetch_row($result); mysqli_free_result($result); var_dump($row); + mysqli_query($link, "DROP TABLE IF EXISTS test"); mysqli_close($link); print "done!"; ?> |