PHP : Function Reference : ODBC Functions (Unified) : odbc_rollback PHP Examples Tutorials References

Examples ( Source code ) » odbc_rollback


<?php

$conn = odbc_connection("$DSN","USER","PASS");

//turns off autocommit

odbc_autocommit($conn,FALSE);

$query1 = "some SQL";

$query2 = "some more SQL";

$ErrorCount = 0;

//if odbc_exec fails it will increment the $ErrorCount

$result = odbc_exec($conn,$query1) or $ErrorCount++;

$result2 = odbc_exec($conn,$query2) or $ErrorCount++;

//checking for errors, commit if none, rollback else

if ($Errorcount == 0){

   odbc_commit($conn);

   echo "transaction successful";

}

else{

   odbc_rollback($conn);

   echo "there were errors processing the transaction.

   No changes were made to the database";

}

odbc_close($conn);

?>

odbc_rollback

Rollback a transaction (PHP 4, PHP 5)
bool odbc_rollback ( resource connection_id )

Change Language

odbc_rollback

Rollback a transaction (PHP 4, PHP 5) bool odbc_rollback ( resource connection_id )

Change Language

Rollback a transaction (PHP 4, PHP 5)
bool odbc_rollback ( resource connection_id )