How can PHP be used to group and display data in a grid/table format similar to Excel's Pivot function?

To group and display data in a grid/table format similar to Excel's Pivot function using PHP, you can use multidimensional arrays to organize the data by different categories or criteria. You can then loop through the arrays to generate the rows and columns of the table, displaying the grouped data in the desired format. 

<?php
// Sample data array
$data = array(
    array("Category" => "A", "Value" => 10),
    array("Category" => "B", "Value" => 20),
    array("Category" => "A", "Value" => 15),
    array("Category" => "B", "Value" => 25)
);

// Group data by category
$groupedData = array();
foreach ($data as $row) {
    $category = $row["Category"];
    if (!isset($groupedData[$category])) {
        $groupedData[$category] = array();
    }
    $groupedData[$category][] = $row["Value"];
}

// Display data in table format
echo "<table border='1'>";
echo "<tr><th>Category</th><th>Sum</th></tr>";
foreach ($groupedData as $category => $values) {
    echo "<tr><td>$category</td><td>" . array_sum($values) . "</td></tr>";
}
echo "</table>";
?>

Keywords

PHP data grouping grid display table format Excel Pivot.

Related Questions