MySQL and PHP

5.22.5 Result::getWarningsCount

Copyright 1997-2019 the PHP Documentation Group.

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