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

Examples ( Source code ) » odbc_commit


<?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_commit

Commit an ODBC transaction (PHP 4, PHP 5)
bool odbc_commit ( resource connection_id )

Code Examples / Notes » odbc_commit

Change Language

odbc_commit

Commit an ODBC transaction (PHP 4, PHP 5) bool odbc_commit ( resource connection_id )

Code Examples / Notes » odbc_commit

Change Language

Commit an ODBC transaction (PHP 4, PHP 5)
bool odbc_commit ( resource connection_id )