How to display a "foreign key" value in an array in php?

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

<?php
// Assuming you have a database connection established

// Query the database to retrieve the user data including the foreign key
$stmt = $pdo->query("SELECT * FROM users");
$users = $stmt->fetchAll(PDO::FETCH_ASSOC);

// Loop through the users array
foreach ($users as $user) {
    // Retrieve the foreign key value for each user
    $countryId = $user['country_id'];

    // Query the database to retrieve the country data for the foreign key
    $stmt = $pdo->prepare("SELECT * FROM countries WHERE id = :id");
    $stmt->bindParam(':id', $countryId);
    $stmt->execute();
    $country = $stmt->fetch(PDO::FETCH_ASSOC);

    // Display the foreign key value from the fetched country data
    echo "User ID: ".$user['id']." | Country: ".$country['name']."<br>";
}

?>