MySQL and PHP

5.27.2 Session::commit

Copyright 1997-2021 the PHP Documentation Group.

Description

public Object mysql_xdevapi\Session::commit();

Commit the transaction.

Parameters

This function has no parameters.

Return Values

An SqlStatementResult object.

Examples

Example 5.112 mysql_xdevapi\Session::commit example

<?php
$session    = mysql_xdevapi\getSession("mysqlx://user:password@localhost");
$collection = $session->getSchema("addressbook")->getCollection("friends");

$session->startTransaction();

$collection->add('{"John":42, "Sam":33}')->execute();
$savepoint = $session->setSavepoint();

$session->commit();
$session->close();