MySQL database transaction, using the WordPress database object $wpdb. When you render a page in WordPress (front end or admin area), the $wpdb database object has already been initialised and opened up a connection to the database. Therefore we can recycle this database connection for our own needs. The $wpdb object saves the database handle as…

wpdb-transactions

<?php
global $wpdb;
 
// @ prefix used to suppress errors, but you should do your own
// error checking by checking return values from each mysql_query()
 
// Start Transaction
@mysql_query("BEGIN", $wpdb->dbh);
 
// Do some expensive/related queries here
$wpdb->query("DELETE FROM table WHERE form_id = '1' ");
$wpdb->query("DELETE FROM data WHERE form_id = '1' ");
 
if ($error) {
    // Error occured, don't save any changes
    @mysql_query("ROLLBACK", $wpdb->dbh);
} else {
   // All ok, save the changes
   @mysql_query("COMMIT", $wpdb->dbh);
}
 
?>