PDF (US Ltr)
- 2.4Mb
PDF (A4)
- 2.3Mb
HTML Download (TGZ)
- 242.9Kb
HTML Download (Zip)
- 250.5Kb
Copyright 1997-2021 the PHP Documentation Group.
Session::rollbackTo
Rollback transaction to savepoint
Description
public void mysql_xdevapi\Session::rollbackTo(string name);
Rollback the transaction back to the savepoint.
Parameters
-
name
Name of the savepoint to rollback to; case-insensitive.
Return Values
An SqlStatementResult object.
Examples
Example 5.125 mysql_xdevapi\Session::rollbackTo
example
<?php
$session = mysql_xdevapi\getSession("mysqlx://user:password@localhost");
$collection = $session->getSchema("addressbook")->getCollection("names");
$session->startTransaction();
$collection->add( '{"test1":1, "test2":2}' )->execute();
$savepoint1 = $session->setSavepoint();
$collection->add( '{"test3":3, "test4":4}' )->execute();
$savepoint2 = $session->setSavepoint();
$session->rollbackTo($savepoint1);
?>