MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
BaseResult::getWarningsCount
Fetch warning count from last operation
abstract public int mysql_xdevapi\BaseResult::getWarningsCount();Returns the number of warnings raised by the last operation. Specifically, these warnings are raised by the MySQL server.
This function has no parameters.
The number of warnings from the last operation.
Example 5.9 mysql_xdevapi\RowResult::getWarningsCount
example
<?php
$session = mysql_xdevapi\getSession("mysqlx://user:password@localhost");
$session->sql("DROP DATABASE IF EXISTS foo")->execute();
$session->sql("CREATE DATABASE foo")->execute();
$session->sql("CREATE TABLE foo.test_table(x int)")->execute();
$schema = $session->getSchema("foo");
$table = $schema->getTable("test_table");
$table->insert(['x'])->values([1])->values([2])->execute();
$res = $table->select(['x/0 as bad_x'])->execute();
echo $res->getWarningsCount();
?>
The above example will output something similar to:
2