maxdb_rollback
(PECL)
maxdb_rollback
(no version information, might be only in CVS)
maxdb->rollback -- Rolls back current transaction
Description
bool
maxdb_rollback ( resource link )
class
maxdb {
bool
rollback ( void )
}
Rollbacks the current transaction for the database specified by the
link
parameter.
Return values
Geeft TRUE terug bij succes, FALSE indien er een fout is opgetreden.
Example
Voorbeeld 1. Object oriented style
<?php $maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */ if (maxdb_connect_errno()) { printf("Connect failed: %s\n", maxdb_connect_error()); exit(); }
/* disable autocommit */ $maxdb->autocommit(FALSE);
$maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city"); $maxdb->query("INSERT INTO temp.mycity SELECT * FROM hotel.city");
/* commit insert */ $maxdb->commit();
/* delete all rows */ $maxdb->query("DELETE FROM temp.mycity");
if ($result = $maxdb->query("SELECT COUNT(*) FROM temp.mycity")) { $row = $result->fetch_row(); printf("%d rows in table mycity.\n", $row[0]); /* Free result */ $result->close(); }
/* Rollback */ $maxdb->rollback();
if ($result = $maxdb->query("SELECT COUNT(*) FROM temp.mycity")) { $row = $result->fetch_row(); printf("%d rows in table mycity (after rollback).\n", $row[0]); /* Free result */ $result->close(); }
/* Drop table myCity */ $maxdb->query("DROP TABLE temp.mycity");
$maxdb->close(); ?>
|
|
Voorbeeld 2. Procedural style
<?php $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */ if (maxdb_connect_errno()) { printf("Connect failed: %s\n", maxdb_connect_error()); exit(); }
/* disable autocommit */ maxdb_autocommit($link, FALSE);
maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city"); maxdb_query($link, "INSERT INTO temp.mycity SELECT * FROM hotel.city");
/* commit insert */ maxdb_commit($link);
/* delete all rows */ maxdb_query($link, "DELETE FROM temp.mycity");
if ($result = maxdb_query($link, "SELECT COUNT(*) FROM temp.mycity")) { $row = maxdb_fetch_row($result); printf("%d rows in table mycity.\n", $row[0]); /* Free result */ maxdb_free_result($result); }
/* Rollback */ maxdb_rollback($link);
if ($result = maxdb_query($link, "SELECT COUNT(*) FROM temp.mycity")) { $row = maxdb_fetch_row($result); printf("%d rows in table mycity (after rollback).\n", $row[0]); /* Free result */ maxdb_free_result($result); }
/* Drop table myCity */ maxdb_query($link, "DROP TABLE temp.mycity");
maxdb_close($link); ?>
|
|
The above examples would produce the following output:
0 rows in table mycity.
25 rows in table mycity (after rollback). |