Easy Tutorial
❮ Pdostatement Bindcolumn Home ❯

PHP mysqli_multi_query() Function

PHP MySQLi Reference Manual

Example

Executing multiple queries on the database:

<?php
$con = mysqli_connect("localhost", "my_user", "my_password", "my_db");
// Check connection
if (mysqli_connect_errno($con))
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$sql = "SELECT Lastname FROM Persons ORDER BY LastName;";
$sql .= "SELECT Country FROM Customers";

// Execute multiple SQL statements
if (mysqli_multi_query($con, $sql))
{
    do
    {
        // Store the first result set
        if ($result = mysqli_store_result($con))
        {
            while ($row = mysqli_fetch_row($result))
            {
                printf("%s\n", $row[0]);
            }
            mysqli_free_result($result);
        }
    }
    while (mysqli_next_result($con));
}

mysqli_close($con);
?>

Definition and Usage

The mysqli_multi_query() function executes one or more queries against the database. Multiple queries are separated by semicolons.


Syntax

Parameter Description
connection Required. Specifies the MySQL connection to use.
query Required. Specifies one or more queries, separated by semicolons.

Technical Details

Return Value: Returns FALSE if the first query fails.
PHP Version: 5+
--- ---
❮ Pdostatement Bindcolumn Home ❯