How can a beginner in PHP efficiently search for a specific ID across multiple tables in a database?

To efficiently search for a specific ID across multiple tables in a database, a beginner in PHP can use SQL queries with JOIN clauses to combine tables and search for the ID. By using JOINs, the beginner can retrieve data from multiple tables based on a common ID, making the search more efficient and effective. 

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

// Search for a specific ID across multiple tables
$id = 123;
$sql = "SELECT * FROM table1 
        JOIN table2 ON table1.id = table2.id 
        JOIN table3 ON table2.id = table3.id 
        WHERE table1.id = $id";

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

if ($result->num_rows > 0) {
    // Output data of each row
    while($row = $result->fetch_assoc()) {
        echo "ID: " . $row["id"]. " - Name: " . $row["name"]. "<br>";
    }
} else {
    echo "0 results";
}

$conn->close();
?>

Keywords

PHP SQL database query join

Related Questions