How can one ensure that all SQL queries have been completed before displaying a message in PHP?

To ensure that all SQL queries have been completed before displaying a message in PHP, you can use PHP's mysqli_multi_query function to execute multiple queries in a single call. This way, all queries will be executed sequentially, and you can check if they have been completed before displaying a message. 

// Connect to the database
$mysqli = new mysqli("localhost", "username", "password", "database");

// Check connection
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

// Execute multiple SQL queries
$sql = "INSERT INTO table1 (column1) VALUES ('value1');";
$sql .= "UPDATE table2 SET column2 = 'value2';";

if ($mysqli->multi_query($sql)) {
    // Check if all queries have been completed
    do {
        // Store and display results if needed
        if ($result = $mysqli->store_result()) {
            while ($row = $result->fetch_assoc()) {
                // Process results
            }
            $result->free();
        }
    } while ($mysqli->next_result());

    // Display message after all queries have been completed
    echo "All SQL queries have been completed.";
} else {
    echo "Error executing SQL queries: " . $mysqli->error;
}

// Close the connection
$mysqli->close();

Keywords

mysqli PDO asynchronous promises callbacks

Related Questions