How can multiple database queries be efficiently handled on a single page in PHP?

When handling multiple database queries on a single page in PHP, it is important to efficiently manage database connections and queries to avoid performance issues. One way to achieve this is by using a single database connection throughout the page and executing multiple queries sequentially. Additionally, consider optimizing queries and minimizing unnecessary database calls to improve performance. 

<?php
// Establish a database connection
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

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

// Execute multiple queries sequentially
$query1 = "SELECT * FROM table1";
$result1 = $conn->query($query1);

$query2 = "SELECT * FROM table2";
$result2 = $conn->query($query2);

// Process results
if ($result1->num_rows > 0) {
    while($row = $result1->fetch_assoc()) {
        // Process data from table1
    }
}

if ($result2->num_rows > 0) {
    while($row = $result2->fetch_assoc()) {
        // Process data from table2
    }
}

// Close the database connection
$conn->close();
?>

Keywords

PHP database queries efficiency optimization performance

Related Questions