5.24.5 Result::getWarningsCount

Copyright 1997-2019 the PHP Documentation Group.

• Result::getWarningsCount

  Get warning count from last operation

Description

public integer mysql_xdevapi\Result::getWarningsCount();

Retrieve the number of warnings from the last Result operation.

Parameters

This function has no parameters.

Return Values

The number of warnings generated by the last operation, or FALSE if the result set is empty or there are no warnings.

Examples

Example 5.90 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