How can PHP be used to group and concatenate data directly from a MySQL database query result?

To group and concatenate data directly from a MySQL database query result in PHP, you can use an associative array to store and concatenate the values based on a specific key. You can iterate over the query result and group the data based on a common key, then concatenate the values accordingly. 

// Assuming $queryResult is the result of a MySQL query
$data = array();

// Iterate over the query result
while ($row = mysqli_fetch_assoc($queryResult)) {
    $key = $row['key']; // Replace 'key' with your actual key
    $value = $row['value']; // Replace 'value' with your actual value

    // Group and concatenate data based on the key
    if (isset($data[$key])) {
        $data[$key] .= ', ' . $value;
    } else {
        $data[$key] = $value;
    }
}

// Output the grouped and concatenated data
foreach ($data as $key => $value) {
    echo $key . ': ' . $value . '<br>';
}

Keywords

PHP MySQL database query grouping concatenation

Related Questions