MySQLのトランザクションが…… => @suin

mysql_transaction_sample.php

<?php

$con1 = mysql_connect("127.0.0.1", "root", null, true); mysql_select_db("test_db", $con1);
$con2 = mysql_connect("127.0.0.1", "root", null, true); mysql_select_db("test_db", $con2);

mysql_query("CREATE TABLE test (id int)engine=InnoDB", $con1);

mysql_query("BEGIN", $con1);
mysql_query("INSERT INTO test VALUES(1)", $con1);
mysql_query("INSERT INTO test VALUES(2)", $con2);
mysql_query("ROLLBACK", $con1);

$result = mysql_query("SELECT * FROM test", $con1);
while ($row = mysql_fetch_assoc($result)) {
  var_dump($row);
}

mysql_query("DROP TABLE test", $con1);

mysql_close($con1);
mysql_close($con2);