Re: Commit/Roll Back Transaction in PHP/mySQL

On 9 Jul 2002 at 22:07, Thomas Edison Jr. wrote: > why the transaction is interrupted, i would like the > transaction to roll back.. that is, all the records > entered before the interruption SHOULD NOT remain in > the database, they should get deleted or something, so > that the transaction can begin Fresh from next time. > > How can i make such a function that will see this > happens, in my PHP/mySQL. Well be sure that your MySQL supports transactions. InnoDB or something. In perl it's just a case of eval {sql here} if($@ ) {rollback}else commit, the $@ is empty unless the eval created an error. Now, let me see how PHP does this, Google, where are you? http://www.google.com/search?sourceid=navclient&q=mysql+php+rollback Might want to be sure your MySQL supports transactions and is configure appropriately or you can drive yourself nuts. http://www.mysql.com/doc/I/n/InnoDB_transaction_model.html And then some ideas about how to do it with PHP: http://www.php.net/manual/en/ref.mysql.php (wow, right from php.net) http://hotwired.lycos.com/webmonkey/02/11/index4a_page3.html?tw=backend I've never used mysql for anything but a data store so I have no examples myself. Peter