DocResult::getWarnings

(No version information available, might only be in Git)

DocResult::getWarningsGet warnings from last operation

Description

public mysql_xdevapi\DocResult::getWarnings ( void ) : Array

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 #1 mysql_xdevapi\DocResult::getWarnings() example

<?php
$session 
mysql_xdevapi\getSession("mysqlx://user:password@localhost");
$session->sql("DROP DATABASE IF EXISTS addressbook")->execute();
$session->sql("CREATE DATABASE addressbook")->execute();

$schema $session->getSchema("addressbook");
$create $schema->createCollection("people");

$create->add('{"name": "Alfred", "age": 18, "job": "Butler"}')->execute();
$create->add('{"name": "Reginald", "age": 42, "job": "Butler"}')->execute();

// ...

$collection $schema->getCollection("people");

// Yields a DocResult object
$result $collection
  
->find('job like :job and age > :age')
  ->
bind(['job' => 'Butler''age' => 16])
  ->
sort('age desc')
  ->
execute();

if (!
$result->getWarningsCount()) {
    echo 
"There was an error:\n";
    
print_r($result->getWarnings());
    exit;
}

var_dump($result->fetchOne());
?>

The above example will output something similar to:


There was an error:

Array
(
    [0] => mysql_xdevapi\Warning Object
        (
            [message] => Something bad and so on
            [level] => 2
            [code] => 1365
        )
    [1] => mysql_xdevapi\Warning Object
        (
            [message] => Something bad and so on
            [level] => 2
            [code] => 1365
        )
)