php8.5
Home/ Manual/ mysql_xdevapi / result/ Result::getAffectedItemsCount

Result::getAffectedItemsCount

PHP function Edit on GitHub ✎

Get affected row count

Description

mysql_xdevapi\Result::getAffectedItemsCount(): int

Get the number of affected rows by the previous operation.

Parameters Parameters

Return Values

The number (as an integer) of affected rows.

Examples

mysql_xdevapi\Result::getAffectedItemsCount() example

php
<?php
$session = mysql_xdevapi\getSession("mysqlx://user:password@localhost");

$session->sql("DROP DATABASE IF EXISTS addressbook")->execute();
$session->sql("CREATE DATABASE addressbook")->execute();

$schema = $session->getSchema("addressbook");
$create = $schema->createCollection("people");

$collection = $schema->getCollection("people");

$result = $collection->add('{"name": "Wilma", "age": 23, "job": "Teacher"}')->execute();

var_dump( $res->getAffectedItemsCount() );
?>

The above example will output:

output
int(1)

Source: reference/mysql_xdevapi/mysql_xdevapi/result/getaffecteditemscount.xml · from the official PHP manual (php/doc-en)