What are some best practices for grouping and summing data in PHP when working with database entries?

When working with database entries in PHP, it is common to need to group and sum data based on certain criteria. One way to achieve this is by using SQL queries with the GROUP BY clause and aggregate functions like SUM(). By grouping data based on specific columns and then summing up the values in another column, you can easily calculate totals or perform other aggregate operations on your database entries. 

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

// Query to group and sum data
$query = "SELECT column1, SUM(column2) AS total FROM mytable GROUP BY column1";

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

// Fetch and display the results
while ($row = $stmt->fetch()) {
    echo $row['column1'] . ': ' . $row['total'] . '<br>';
}

Keywords

SQL GROUP BY SUM PHP arrays database queries

Related Questions