Using MySQL Inno DB transaction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Lately i'm building a library automation application with php 5 and MySQL 4..1.

For the transaction module, i'm using Inno DB engine to store the
transaction data, cos i want to use MySQL transaction method which can
be commit or rollback.

But when i tried to rollback the transaction in the other script, the
data still exist in the database.

script1.php :
<?php
$mysqli = new mysqli(...);

$mysqli->autocommit(false);
// do the transaction
// and process it in script2.php
?>


script2.php
<?php
$mysqli->rollback();
?>

What's wrong?? does anybody could help me?? Thanks

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux