How can PHP beginners effectively structure their code for reading data from multiple tables in a database?

When reading data from multiple tables in a database, PHP beginners can effectively structure their code by using SQL JOIN queries to fetch data from related tables in a single query. This allows for efficient retrieval of data without the need for multiple queries and helps organize the code logic. Additionally, using proper error handling and sanitization techniques can improve the security and reliability of the code. 

<?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);
}

// SQL query to fetch data from multiple tables using JOIN
$sql = "SELECT users.username, orders.order_id, orders.total_amount 
        FROM users
        INNER JOIN orders ON users.user_id = orders.user_id";

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

if ($result->num_rows > 0) {
    // Output data of each row
    while($row = $result->fetch_assoc()) {
        echo "Username: " . $row["username"]. " - Order ID: " . $row["order_id"]. " - Total Amount: " . $row["total_amount"]. "<br>";
    }
} else {
    echo "0 results";
}

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

?>

Keywords

PHP database tables SQL data retrieval

Related Questions