How can the JOIN function in SQL be effectively used in PHP to access data from multiple tables?

When using the JOIN function in SQL to access data from multiple tables in PHP, you can execute the SQL query using PHP's PDO (PHP Data Objects) or mysqli extension. You can fetch the results of the query using fetch() or fetchAll() functions to access the data from multiple tables. 

<?php

// Establish a connection to the database
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// Prepare the SQL query with JOIN statement
$query = $pdo->prepare('SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.table1_id');

// Execute the query
$query->execute();

// Fetch the results
$results = $query->fetchAll(PDO::FETCH_ASSOC);

// Loop through the results and access the data
foreach ($results as $result) {
    echo $result['column_name'];
}

?>

Keywords

PHP SQL JOIN data access multiple tables

Related Questions