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. ??? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Betty_S Posted January 14, 2007 Author Share Posted January 14, 2007 thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.