How can the GROUP_CONCAT function be utilized in PHP to concatenate values from multiple rows into a single string?

To utilize the GROUP_CONCAT function in PHP to concatenate values from multiple rows into a single string, you can use SQL queries with GROUP_CONCAT in combination with PHP's PDO (PHP Data Objects) to fetch and process the results. This allows you to retrieve multiple rows of data and concatenate specific column values into a single string based on a grouping condition. 

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

// Prepare and execute a SQL query using GROUP_CONCAT to concatenate values
$query = "SELECT group_id, GROUP_CONCAT(value SEPARATOR ', ') as concatenated_values FROM your_table GROUP BY group_id";
$stmt = $pdo->prepare($query);
$stmt->execute();

// Fetch and process the concatenated values
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    echo "Group ID: " . $row['group_id'] . " - Concatenated Values: " . $row['concatenated_values'] . "<br>";
}

Keywords

GROUP_CONCAT PHP concatenate multiple rows single string

Related Questions