What are best practices for retrieving and displaying data from multiple tables in PHP using SQL queries?

When retrieving and displaying data from multiple tables in PHP using SQL queries, it is best practice to use JOIN statements to combine the data from different tables based on a common key. This allows you to fetch related data in a single query and display it together in your application. 

<?php
// Establish a connection to the database
$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);
}

// SQL query to retrieve data from multiple tables using JOIN
$sql = "SELECT table1.column1, table2.column2
        FROM table1
        INNER JOIN table2 ON table1.common_key = table2.common_key";

$result = $conn->query($sql);

// Display the retrieved data
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "Column1: " . $row["column1"]. " - Column2: " . $row["column2"]. "<br>";
    }
} else {
    echo "0 results";
}

$conn->close();
?>

Keywords

PHP SQL queries data retrieval multiple tables data display

Related Questions