Using MySQL Inno DB transaction
| From: | Arie Nugraha | Date: | Tue, 12 Jul 2005 09:37:56 +0000 |
| Subject: | Using MySQL Inno DB transaction | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-39928@lists.php.net to get a copy of this message | ||
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