How can PHP developers use GROUP BY and SUM functions in SQL queries to aggregate data efficiently?

To aggregate data efficiently using GROUP BY and SUM functions in SQL queries, PHP developers can use these functions to group rows that have the same values in specified columns and then calculate the sum of a specific column within each group. This allows developers to retrieve summarized data and perform calculations on grouped data easily. 

<?php
// Establish a connection to the database
$connection = new PDO("mysql:host=localhost;dbname=mydatabase", "username", "password");

// Prepare the SQL query with GROUP BY and SUM functions
$query = "SELECT column1, SUM(column2) AS total FROM mytable GROUP BY column1";

// Execute the query and fetch the results
$result = $connection->query($query);
$data = $result->fetchAll(PDO::FETCH_ASSOC);

// Output the aggregated data
foreach ($data as $row) {
    echo $row['column1'] . ": " . $row['total'] . "<br>";
}
?>

Keywords

PHP GROUP BY SUM SQL queries data aggregation

Related Questions