How can GROUP_CONCAT be utilized effectively in PHP to concatenate and display data from different tables?

When dealing with data from different tables in a database, GROUP_CONCAT can be used effectively in PHP to concatenate and display related data in a single query result. By using GROUP_CONCAT along with JOINs or subqueries, you can retrieve data from multiple tables and concatenate it into a single column for display. 

<?php
// Connect to the database
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// Query to retrieve data from different tables and concatenate it using GROUP_CONCAT
$query = "SELECT t1.id, t1.name, GROUP_CONCAT(t2.description SEPARATOR ', ') AS descriptions
          FROM table1 t1
          JOIN table2 t2 ON t1.id = t2.t1_id
          GROUP BY t1.id";

// Execute the query
$stmt = $pdo->query($query);

// Display the concatenated data
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    echo "ID: " . $row['id'] . "<br>";
    echo "Name: " . $row['name'] . "<br>";
    echo "Descriptions: " . $row['descriptions'] . "<br>";
    echo "<br>";
}
?>

Keywords

GROUP_CONCAT PHP concatenate tables data

Related Questions