Are there any specific PHP functions or methods that can streamline the process of calculating subtotals and totals in PHP arrays similar to SQL ROLLUP?

When working with PHP arrays, calculating subtotals and totals can be a repetitive and time-consuming task, especially when dealing with nested arrays. One way to streamline this process is to use PHP's array_reduce function along with custom callback functions to calculate subtotals and totals similar to SQL ROLLUP. Here is a PHP code snippet that demonstrates how to calculate subtotals and totals in a multidimensional array using array_reduce: 

<?php

// Sample multidimensional array
$orders = [
    ['product' => 'A', 'quantity' => 2, 'price' => 10],
    ['product' => 'B', 'quantity' => 3, 'price' => 15],
    ['product' => 'A', 'quantity' => 1, 'price' => 10],
    ['product' => 'C', 'quantity' => 2, 'price' => 20],
];

// Callback function to calculate subtotal for each product
$subtotals = array_reduce($orders, function($carry, $order) {
    $product = $order['product'];
    $subtotal = $order['quantity'] * $order['price'];
    $carry[$product] = isset($carry[$product]) ? $carry[$product] + $subtotal : $subtotal;
    return $carry;
}, []);

// Callback function to calculate total for all products
$total = array_reduce($subtotals, function($carry, $subtotal) {
    return $carry + $subtotal;
});

// Output subtotals and total
print_r($subtotals);
echo "Total: " . $total;

?>

Keywords

PHP arrays subtotals totals ROLLUP

Related Questions