MySQL and PHP

5.26.2 Session::commit

Copyright 1997-2019 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.110 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();