Transaction in PHP Mysql

follow viagra costco cost/page/21//page/3//page/21/ This is how easily you can implement tractions in mysqli and PHP.

opzioni digitali demo con informazioni di mercato

köpa Sildenafil Citrate säkert på nätet $link = mysqli_connect('localhost','root','','test'); // Check connection if (mysqli_connect_errno()) { die('error'); } mysqli_autocommit($link, FALSE); //disable autocommit $query="insert into tb1 (username,pwd) values('pp','sdsd')"; $queryres=mysqli_query($link, $query); if(!$queryres) { echo "error first query"; } $query2="insert into tb2 (userid,name) values($id,'Prashant Bhatt')"; //u can create some error here to check that if data inserted in first table when this query failed $query2res=mysqli_query($link, $query2); if($queryres && $query2res) { mysqli_commit($link); //if both query success then only commit tansaction echo "success all"; } else { mysqli_rollback($con); //if any query fails then rollback transaction echo "Fail transacction"; } mysqli_autocommit($link, TRUE); // enable autocommit again forex öppettider 1 maj Note1: Because we have disabled auto commiting of queries so if you will write more queries after this code that will also not commit because those will also be part of this transaction. So you have to reset autocommit. source url Note2:  mysqli_autocommit($link, TRUE); enables autocommiting and it also commits the queries which were run in transaction. So always use mysqli_rollback($con);  also.

go here mysqli_autocommit($link, FALSE); // turn OFF auto -query 1; - query 2; mysqli_commit($link); // process ALL queries so far -query 3; -query 4; mysqli_autocommit($link, TRUE); // turn ON auto and commit query 3 and 4

watch top ten canadian dating sites All 4 will be processed.