mysqliの場合のトランザクション
$mysqli->begin_transaction();
$query = "DELETE FROM ...";
$result = $mysqli->query($query);
$query = "INSERT INTO ...";
$result = $mysqli->query($query);
if (!$result) {
$mysqli->rollback();
exit;
}
$mysqli->commit();
More than 5 years have passed since last update.
mysqliの場合のトランザクション
$mysqli->begin_transaction();
$query = "DELETE FROM ...";
$result = $mysqli->query($query);
$query = "INSERT INTO ...";
$result = $mysqli->query($query);
if (!$result) {
$mysqli->rollback();
exit;
}
$mysqli->commit();
Register as a new user and use Qiita more conveniently