maxdb_commit
(PECL)
maxdb_commit
(no version information, might be only in CVS)
maxdb->commit -- Commits the current transaction
Description
Procedural style:
bool
maxdb_commit ( resource link )
Object oriented style (method)
class
maxdb {
bool
commit ( void )
}
Commits the current transaction for the database connection 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(); }
/* set autocommit to off */ $maxdb->autocommit(FALSE);
maxdb_report (MAXDB_REPORT_OFF); $maxdb->query("DROP TABLE mycustomer"); maxdb_report (MAXDB_REPORT_ERROR);
$maxdb->query("CREATE TABLE mycustomer LIKE hotel.customer");
/* Insert some values */ $maxdb->query("INSERT INTO mycustomer VALUES (3000,'Mrs','Jenny','Porter','10580','1340 N.Ash Street, #3')"); $maxdb->query("INSERT INTO mycustomer VALUES (3100,'Mr','Peter','Brown','48226','1001 34th Str., APT.3')");
/* commit transaction */ $maxdb->commit();
/* close connection */ $maxdb->close(); ?>
|
|
Voorbeeld 2. Procedural style
<?php $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */ if (!$link) { printf("Connect failed: %s\n", maxdb_connect_error()); exit(); }
/* set autocommit to off */ maxdb_autocommit($link, FALSE);
maxdb_report (MAXDB_REPORT_OFF); maxdb_query($link,"DROP TABLE mycustomer"); maxdb_report (MAXDB_REPORT_ERROR);
maxdb_query($link, "CREATE TABLE mycustomer LIKE hotel.customer");
/* Insert some values */ maxdb_query($link, "INSERT INTO mycustomer VALUES (3000,'Mrs','Jenny','Porter','10580','1340 N.Ash Street, #3')"); maxdb_query($link, "INSERT INTO mycustomer VALUES (3100,'Mr','Peter','Brown','48226','1001 34th Str., APT.3')");
/* commit transaction */ maxdb_commit($link);
/* close connection */ maxdb_close($link); ?>
|
|
The above examples produces no output.