Betty_S Posted January 13, 2007 Share Posted January 13, 2007 mysql transaction in php, how?Hi everyone,I want to perform a series action on the DB (insert, update, delete).I know that I can put the in a transaction so I can be sure that either al actions succeed or all failed.How can I do that in php? Thanks. ??? Link to comment https://forums.phpfreaks.com/topic/34033-mysql-transaction-in-php-how/ Share on other sites More sharing options...
c4onastick Posted January 13, 2007 Share Posted January 13, 2007 This is a big topic. The basic mysql functions are listed and described here:http://www.php.net/manual/en/ref.mysql.phpAlthough, judging from your question, you may want to consider using PEAR:DB or PEAR:MDB2...PEAR:DB: http://pear.php.net/package/DBPEAR:MDB2: http://pear.php.net/package/MDB2As they include data processing functions that make sure that bad things (SQL injection attacks, etc.) don't end up compromising your server, as well as a more accessible error handler. With the vanilla mysql functions, you have to worry about that yourself. Link to comment https://forums.phpfreaks.com/topic/34033-mysql-transaction-in-php-how/#findComment-159987 Share on other sites More sharing options...
Betty_S Posted January 14, 2007 Author Share Posted January 14, 2007 thanks Link to comment https://forums.phpfreaks.com/topic/34033-mysql-transaction-in-php-how/#findComment-160177 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.