mysqli
PHP Manual

mysqli::$warning_count

mysqli_warning_count

Returns the number of warnings generated by the most recently executed query

Description

Object-oriented style

int$mysqli->warning_count;

Procedural style

int mysqli_warning_count(mysqli $mysql)

Returns the number of warnings generated by the most recently executed query.

Note: For retrieving warning messages the following SQL command can be used: SHOW WARNINGS [limit row_count].

Parameters

mysql

Procedural style only: A mysqli object returned by mysqli_connect or mysqli_init

Return Values

Number of warnings or zero if there are no warnings.

Examples

Example #1 $mysqli->warning_count example

Object-oriented style

<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

$mysqli->query("SELECT 42/0");

if ($mysqli->warning_count > 0) {
    $result = $mysqli->query("SHOW WARNINGS");
    $row = $result->fetch_row();
    printf("%s (%d): %s\n", $row[0], $row[1], $row[2]);
}

Procedural style

<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$link = mysqli_connect("localhost", "my_user", "my_password", "world");

mysqli_query($link, "SELECT 42/0");

if (mysqli_warning_count($link) > 0) {
    $result = mysqli_query($link, "SHOW WARNINGS");
    $row = mysqli_fetch_row($result);
    printf("%s (%d): %s\n", $row[0], $row[1], $row[2]);
}

The above examples will output:

Warning (1365): Division by 0

See Also

  • mysqli_errno
  • mysqli_error
  • mysqli_sqlstate