Documentation Home
MySQL PHP API
Download this Manual
PDF (US Ltr) - 2.4Mb
PDF (A4) - 2.4Mb
HTML Download (TGZ) - 250.9Kb
HTML Download (Zip) - 258.4Kb


MySQL PHP API  /  ...  /  Result::getWarningsCount

5.23.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.

Examples

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