Commit/Roll Back Transaction in PHP/mySQL
| From: | Thomas Edison Jr. | Date: | Wed, 10 Jul 2002 05:07:12 +0000 |
| Subject: | Commit/Roll Back Transaction in PHP/mySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-106664@lists.php.net to get a copy of this message | ||
Glory!
Im creating a .php file that will be uploading &
putting in data from a .csv file into mySQL Tables on
the server. However, my problem is that if there is
any kind of a problem during the transaction, i.e,
system shut down, electricity problem, or any reason
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.
Thanks,
T. Edison Jr.
__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com