5.5.1 BaseResult::getWarnings

Copyright 1997-2019 the PHP Documentation Group.

• BaseResult::getWarnings

  Fetch warnings from last operation

Description

abstract public array mysql_xdevapi\BaseResult::getWarnings();

Fetches warnings generated by MySQL server's last operation.

Parameters

This function has no parameters.

Return Values

An array of warnings raised by the last operation, or FALSE if no warnings are present.

Examples

Example 5.8 mysql_xdevapi\RowResult::getWarnings example

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

$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();
$warnings = $res->getWarnings();

print_r($warnings);
?>

The above example will output something similar to:

Array
(
    [0] => mysql_xdevapi\Warning Object
        (
            [message] => Division by 0
            [level] => 2
            [code] => 1365
        )
    [1] => mysql_xdevapi\Warning Object
        (
            [message] => Division by 0
            [level] => 2
            [code] => 1365
        )
)