span style="color: #0000BB"><?phptry { DB :: $dbh -> beginTransaction(); DB :: $dbh -> exec("INSERT INTO %table1% SET `value` = ?;", $value); DB :: $dbh -> exec("UPDATE %table2% SET `value` = `value` + 1 WHERE `id` = ?;", $id); DB :: $dbh -> commit();} catch (Exception $e) { DB :: $dbh -> rollback();} |