A Comprehensive Guide on mysqli_warning_count Function in PHP

When working with MySQL databases in PHP, the mysqli extension provides various functions for database operations. One such function is mysqli_warning_count, which was deprecated in PHP 8.0 and removed in PHP 8.1. It previously returned the number of warnings generated by the previous MySQL query.

This guide covers the function's features and demonstrates how to use it effectively in your PHP projects.

What is mysqli_warning_count Function?

The mysqli_warning_count function was a built-in PHP function that returned the number of warnings generated during the execution of the previous MySQL query. It was deprecated in PHP 8.0 and removed in PHP 8.1. Unlike errors, which typically halt script execution, warnings indicate non-fatal issues such as data truncation or duplicate key insertions that allow the query to complete successfully.

The function takes one argument: the MySQL connection object returned by mysqli_connect or new mysqli().

Here is the syntax of the mysqli_warning_count function:

mysqli_warning_count($connection);

Features of mysqli_warning_count Function

The mysqli_warning_count function provided a variety of features that made it a useful tool for retrieving warning information generated during query execution in MySQL databases in PHP. Some of the key features of the function include:

1. Retrieving Warning Count

The main feature of the mysqli_warning_count function was to retrieve the number of warnings generated during the execution of the previous MySQL query. This information can be useful for diagnosing potential issues with the MySQL server during query execution.

2. Connection Object Requirement

The function required a valid MySQL connection object. You could pass an existing connection to retrieve the warning count from the most recent query executed on that connection.

3. Counts Warnings, Not Errors

mysqli_warning_count only reflected warnings — non-fatal conditions raised by the last statement. Errors (which abort the statement) are reported separately through mysqli_error() / mysqli_errno(). A query can therefore succeed and still produce one or more warnings.

How to Use mysqli_warning_count Function

Here are some steps to use the mysqli_warning_count function in your PHP projects:

1. Connecting to MySQL Server

Before you can use the mysqli_warning_count function, you need to establish a connection to the MySQL server using the mysqli_connect function. Here is an example code snippet:

<?php

$host = 'localhost';
$user = 'username';
$password = 'password';
$database = 'mydatabase';

$connection = mysqli_connect($host, $user, $password, $database);

if (!$connection) {
    die('Connection failed: ' . mysqli_connect_error());
}

2. Retrieving Warning Count

Once you have established a connection to the MySQL server and executed a MySQL query, you can use the mysqli_warning_count function to retrieve the number of warnings generated during the execution of the previous MySQL query. Here is an example code snippet:

<?php

// Execute a query that generates a warning (e.g., duplicate key insertion)
// Assumes a table 'users' exists with a unique key on 'id'
mysqli_query($connection, "INSERT IGNORE INTO users (id, name) VALUES (1, 'Alice'), (1, 'Bob')");

// Get the number of warnings
$warning_count = mysqli_warning_count($connection);
echo "Warning count: " . $warning_count;

// Retrieve the actual warning messages
$warnings = mysqli_get_warnings($connection);
if ($warnings) {
    while ($warning = $warnings->next_warning()) {
        echo "Level: " . $warning->Level . ", Message: " . $warning->Message . "\n";
    }
}

This code retrieves the number of warnings generated during the execution of the previous MySQL query using the mysqli_warning_count function, and demonstrates how to fetch the detailed warning messages using mysqli_get_warnings().

A typical run of the snippet above prints something like:

Warning count: 1
Level: Note, Message: Duplicate entry '1' for key 'PRIMARY'

The Modern Replacement (PHP 8.1+)

Because mysqli_warning_count no longer exists in PHP 8.1 and later, use the connection property $mysqli->warning_count to read the count, and mysqli_get_warnings() (still available) to read the details:

<?php

$mysqli = new mysqli('localhost', 'username', 'password', 'mydatabase');

$mysqli->query("INSERT IGNORE INTO users (id, name) VALUES (1, 'Alice'), (1, 'Bob')");

// Property replacing the removed mysqli_warning_count() function
echo "Warning count: " . $mysqli->warning_count . "\n";

if ($warnings = $mysqli->get_warnings()) {
    do {
        echo "Code {$warnings->errno}: {$warnings->message}\n";
    } while ($warnings->next());
}

For new code, enabling exception-based reporting is recommended so that errors throw mysqli_sql_exception and never pass silently:

<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

Conclusion

In conclusion, mysqli_warning_count previously provided a straightforward way to check for MySQL warnings after query execution. However, since it was removed in PHP 8.1, modern PHP development typically relies on exception-based error handling (mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT)) for robust error management. If you are maintaining legacy codebases, you can still use mysqli_get_warnings() to inspect specific warning details from the MySQL server.

Practice