BaseResult::getWarningsCount
PHP function
Edit on GitHub ✎
Fetch warning count from last operation
Description
mysql_xdevapi\BaseResult::getWarningsCount(): int
Returns the number of warnings raised by the last operation. Specifically, these warnings are raised by the MySQL server.
Parameters Parameters
Return Values
The number of warnings from the last operation.
Examples
mysql_xdevapi\RowResult::getWarningsCount() example
php
<?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:
output
2