Skip to content

Instantly share code, notes, and snippets.

@strarsis
Forked from nciske/wpdb-transactions
Created March 14, 2018 20:56
Show Gist options
  • Save strarsis/e8db0f4270fb7a38975e4825d9e9c7c7 to your computer and use it in GitHub Desktop.
Save strarsis/e8db0f4270fb7a38975e4825d9e9c7c7 to your computer and use it in GitHub Desktop.
MySQL database transaction, using the WordPress database object $wpdb. Requires the InnoDB table format.
<?php
global $wpdb;
// Start Transaction
$wpdb->query( "START TRANSACTION" );
// Do some expensive/related queries here
//$wpdb->query("DELETE FROM table WHERE form_id = '1' ");
//$wpdb->query("DELETE FROM data WHERE form_id = '1' ");
// set $error variable value in error handling after $wpdb modifications
if ($error) {
// Error occured, don't save any changes
$wpdb->query( "ROLLBACK" );
} else {
// All ok, save the changes
$wpdb->query( "COMMIT" );
}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment