PHP MySQLi mysqli_info() - Query Information

mysqli_info()

The mysqli_info() function returns a text string containing information about the last executed query. It works with operations that affect multiple rows at once or alter the table structure.

EXAMPLE

<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "mysqli_database";

$connection = mysqli_connect($server, $username, $password, $database);

// 1. Create a copy of the table and perform a bulk data transfer
mysqli_query($connection, "CREATE TABLE test_table LIKE mysqli_table");
mysqli_query($connection, "INSERT INTO test_table SELECT * FROM mysqli_table");

// Display information about the last operation (INSERT INTO SELECT)
// NOTE: The mysqli_info() function returns a precise textual status 
// regarding bulk operations. For INSERT ... SELECT, it will explicitly state 
// how many rows were read, how many were successfully inserted, and if any 
// duplicates occurred.
echo "Transfer status: " . mysqli_info($connection) . "<br>";

// 2. Example of updating data (replacing the name to 'Fruit')
mysqli_query($connection, "UPDATE test_table SET fruit = 'Fruit' WHERE table_id > 0");
echo "Update status: " . mysqli_info($connection);

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: Instead of just guessing what happened, this function tells you the number of matched rows (Rows matched), changed rows (Changed), and any warnings. Look at the example for a bulk insert:

INSERT INTO ... SELECT (tells us the number of inserted rows).

UPDATE (tells us how many rows were actually changed).

ALTER TABLE (information about table alteration).

LOAD DATA INFILE (file import statistics).