mysqli_real_query()

The mysqli_real_query() function executes a single SQL query on the server. Unlike the mysqli_query() function, it does not immediately return a result set.

EXAMPLE

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

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

if (mysqli_connect_errno()) {
    echo "Connection failed: " . mysqli_connect_error();
    exit();
}

// Execute a raw query directly to the server (first time)
// NOTE: The mysqli_real_query() function immediately sends the command to the database without 
// any additional processing or preparation of results in PHP. Therefore, it is ideal for fast inserts (INSERT).
mysqli_real_query($connection, "INSERT INTO mysqli_table (fruit, vegetable) VALUES ('Plums', 'Garlic')");

// Execute a raw query directly to the server (second time)
mysqli_real_query($connection, "INSERT INTO mysqli_table (fruit, vegetable) VALUES ('Blackberries', 'Potatoes')");

echo "Records were successfully inserted into the database via a raw query.";

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: We use this function when we want to determine ourselves how to manage the results. To read data after using this function, we must call mysqli_store_result() or mysqli_use_result(). This is very useful when working with extremely large databases, where we do not want to load all data into PHP memory at once.

It executes a query without automatically storing the results.
Better control over memory consumption during large queries.
It is used in combination with the store_result() or use_result() functions.