--TEST-- mysqli autocommit/commit/rollback --SKIPIF-- <?php require_once('skipif.inc'); include "connect.inc"; $link = mysqli_connect($host, $user, $passwd); $result = mysqli_query($link, "SHOW VARIABLES LIKE 'have_innodb'"); $row = mysqli_fetch_row($result); mysqli_free_result($result); mysqli_close($link); if ($row[1] == "DISABLED" || $row[1] == "NO") { printf ("skip innodb support is not installed or enabled."); exit; } ?> --FILE-- <?php include "connect.inc"; $link = mysqli_connect($host, $user, $passwd); mysqli_select_db($link, "test"); mysqli_autocommit($link, TRUE); mysqli_query($link,"DROP TABLE IF EXISTS ac_01"); mysqli_query($link,"CREATE TABLE ac_01(a int, b varchar(10)) type=InnoDB"); mysqli_query($link, "INSERT INTO ac_01 VALUES (1, 'foobar')"); mysqli_autocommit($link, FALSE); mysqli_query($link, "DELETE FROM ac_01"); mysqli_query($link, "INSERT INTO ac_01 VALUES (2, 'egon')"); mysqli_rollback($link); $result = mysqli_query($link, "SELECT * FROM ac_01"); printf("Num_of_rows=%d\n", mysqli_num_rows($result)); $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')"); mysqli_commit($link); $result = mysqli_query($link, "SELECT * FROM ac_01"); $row = mysqli_fetch_row($result); mysqli_free_result($result); var_dump($row); mysqli_close($link); ?> --EXPECT-- Num_of_rows=1 array(2) { [0]=> string(1) "1" [1]=> string(6) "foobar" } array(2) { [0]=> string(1) "2" [1]=> string(4) "egon" }