MYSQLI_RELEASE_SAVEPOINT(3) 1 MYSQLI_RELEASE_SAVEPOINT(3)mysqli::release_savepoint - Removes the named savepoint from the set of savepoints of the current transaction
Object oriented style (method):
SYNOPSIS
public bool mysqli::release_savepoint (string $name)
DESCRIPTION
Procedural style:
bool mysqli_release_savepoint (mysqli $link, string $name)
Warning
This function is currently not documented; only its argument list is available.
PARAMETERS
o $
link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)
o $name
-
RETURN VALUES
Returns TRUE on success or FALSE on failure.
SEE ALSO mysqli_rollback(3).
PHP Documentation Group MYSQLI_RELEASE_SAVEPOINT(3)
Check Out this Related Man Page
MYSQLI_COMMIT(3) 1 MYSQLI_COMMIT(3)mysqli::commit - Commits the current transaction
Object oriented style
SYNOPSIS
bool mysqli::commit ([int $flags], [string $name])
DESCRIPTION
Procedural style
bool mysqli_commit (mysqli $link, [int $flags], [string $name])
Commits the current transaction for the database connection.
PARAMETERS
o $
link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)
o $flags
- A bitmask of MYSQLI_TRANS_COR_* constants.
o $name
- If provided then COMMIT/*name*/ is executed.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
CHANGELOG
+--------+-------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+-------------------------------------+
| 5.5.0 | |
| | |
| | Added $flags and $name parameters. |
| | |
+--------+-------------------------------------+
EXAMPLES
Example #1
mysqli::commit example
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$mysqli->query("CREATE TABLE Language LIKE CountryLanguage");
/* 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 */
if (!$mysqli->commit()) {
print("Transaction commit failed
");
exit();
}
/* drop table */
$mysqli->query("DROP TABLE Language");
/* close connection */
$mysqli->close();
?>
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "test");
/* check connection */
if (!$link) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
/* set autocommit to off */
mysqli_autocommit($link, FALSE);
mysqli_query($link, "CREATE TABLE Language LIKE CountryLanguage");
/* 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 */
if (!mysqli_commit($link)) {
print("Transaction commit failed
");
exit();
}
/* close connection */
mysqli_close($link);
?>
SEE ALSO mysqli_autocommit(3), mysqli_begin_transaction(3), mysqli_rollback(3), mysqli_savepoint(3).
PHP Documentation Group MYSQLI_COMMIT(3)