mysqli_commit
(PHP 5)
mysqli_commit
(no version information, might be only in CVS)
mysqli->commit -- Commits the current transaction
Description
Procedural style:
bool
mysqli_commit ( object link)
Object oriented style (method)
class
mysqli {
bool
commit ( void )
}
Commits the current transaction for the database connection specified by the
link parameter.
Return values
Restituisce TRUE in caso di successo, FALSE in caso di fallimento.
Examples
Esempio 1. Object oriented style
<?php $mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); }
$mysqli->query("CREATE TABLE Language LIKE CountryLanguage Type=InnoDB");
/* set autocommit to off */ $mysqli->autocommit(FALSE);
/* Insert some values */ $mysqli->query("INSERT INTO Language VALUES ('DEU', 'Bavarian', 'F', 11.2)"); $mysqli->query("INSERT INTO Language VALUES ('DEU', 'Swabian', 'F', 9.4)");
/* commit transaction */ $mysqli->commit();
/* drop table */ $mysqli->query("DROP TABLE Language");
/* close connection */ $mysqli->close(); ?>
|
|
Esempio 2. Procedural style
<?php $link = mysqli_connect("localhost", "my_user", "my_password", "test");
/* check connection */ if (!$link) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); }
/* set autocommit to off */ mysqli_autocommit($link, FALSE);
mysqli_query($link, "CREATE TABLE Language LIKE CountryLanguage Type=InnoDB");
/* Insert some values */ mysqli_query($link, "INSERT INTO Language VALUES ('DEU', 'Bavarian', 'F', 11.2)"); mysqli_query($link, "INSERT INTO Language VALUES ('DEU', 'Swabian', 'F', 9.4)");
/* commit transaction */ mysqli_commit($link);
/* close connection */ mysqli_close($link); ?>
|
|