MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
Session::rollbackTo
Rollback transaction to savepoint
public void mysql_xdevapi\Session::rollbackTo(string name);
Rollback the transaction back to the savepoint.
name
Name of the savepoint to rollback to; case-insensitive.
An SqlStatementResult object.
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); ?>