<?php require_once "connect.inc"; if (!($mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket))) { printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", $host, $user, $db, $port, $socket); } if (!is_bool($tmp = $mysqli->autocommit(true))) { printf("[002] Expecting boolean/any, got %s/%s\n", gettype($tmp), $tmp); } if (!$mysqli->query('SET AUTOCOMMIT = 0')) { printf("[003] [%d] %s\n", $mysqli->errno, $mysqli->error); } if (!($res = $mysqli->query('SELECT @@autocommit as auto_commit'))) { printf("[004] [%d] %s\n", $mysqli->errno, $mysqli->error); } $tmp = $res->fetch_assoc(); $res->free_result(); if ($tmp['auto_commit']) { printf("[005] Cannot turn off autocommit\n"); } if (true !== ($tmp = $mysqli->autocommit(true))) { printf("[006] Expecting true, got %s/%s\n", gettype($tmp), $tmp); } if (!($res = $mysqli->query('SELECT @@autocommit as auto_commit'))) { printf("[007] [%d] %s\n", $mysqli->errno, $mysqli->error); } $tmp = $res->fetch_assoc(); $res->free_result(); if (!$tmp['auto_commit']) { printf("[008] Cannot turn on autocommit\n"); }
<?php require_once "connect.inc"; $tmp = NULL; $link = NULL; $mysqli = new mysqli(); if (!is_null($tmp = @$mysqli->commit())) { printf("[013] Expecting NULL got %s/%s\n", gettype($tmp), $tmp); } if (!($mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket))) { printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", $host, $user, $db, $port, $socket); } if (true !== ($tmp = $mysqli->commit())) { printf("[002] Expecting boolean/true got %s/%s\n", gettype($tmp), $tmp); } if (true !== ($tmp = $mysqli->autocommit(false))) { printf("[003] Cannot turn off autocommit, expecting true, got %s/%s\n", gettype($tmp), $tmp); } if (!$mysqli->query('DROP TABLE IF EXISTS test')) { printf("[004] [%d] %s\n", $mysqli->errno, $mysqli->error); } if (!$mysqli->query('CREATE TABLE test(id INT) ENGINE = InnoDB')) { printf("[005] Cannot create test table, [%d] %s\n", $mysqli->errno, $mysqli->error); } if (!$mysqli->query('INSERT INTO test(id) VALUES (1)')) { printf("[006] [%d] %s\n", $mysqli->errno, $mysqli->error); } $tmp = $mysqli->commit(); if ($tmp !== true) { printf("[007] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp); }
<?php require_once "connect.inc"; $mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket); var_dump($mysqli->autocommit(false)); $result = $mysqli->query("SELECT @@autocommit"); var_dump($result->fetch_row()); var_dump($mysqli->autocommit(true)); $result = $mysqli->query("SELECT @@autocommit"); var_dump($result->fetch_row());