php mysql开启事务必须和提交回滚_PHP和mySQL：实现事务的简单代码 – 提交和回滚...

您需要使用

mysqli extension才能使用此功能.

$link = mysqli_connect("localhost", "my_user", "my_password", "world");

/* check connection */

if (mysqli_connect_errno()) {

printf("Connect failed: %s\n", mysqli_connect_error());

exit();

}

/* disable autocommit */

mysqli_autocommit($link, FALSE);

mysqli_query($link, "CREATE TABLE myCity LIKE City");

mysqli_query($link, "ALTER TABLE myCity Type=InnoDB");

mysqli_query($link, "INSERT INTO myCity SELECT * FROM City LIMIT 50");

/* commit insert */

mysqli_commit($link);

/* delete all rows */

mysqli_query($link, "DELETE FROM myCity");

if ($result = mysqli_query($link, "SELECT COUNT(*) FROM myCity")) {

$row = mysqli_fetch_row($result);

printf("%