php8.5
Home/ Manual/ mysql_xdevapi / rowresult/ RowResult::getWarnings

RowResult::getWarnings

PHP function Edit on GitHub ✎

Get warnings from last operation

Description

mysql_xdevapi\RowResult::getWarnings(): array

Retrieve warnings from the last RowResult operation.

Parameters Parameters

Return Values

An array of Warning objects from the last operation. Each object defines an error 'message', error 'level', and error 'code'. An empty array is returned if no errors are present.

Examples

mysql_xdevapi\RowResult::getWarnings() example

php
<?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:

output
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
        )
)

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