PHP在比较时获取数组值的总和 - PHP Getting SUM of Array Values While Comparing

PHP Getting SUM of Array Values While Comparing

本文关键字：数组获取比较 PHP | 更新日期: 2024-05-14

我有一个Information States And Totals数组。我想看看如何获得每个州的所有总计的总和。

我知道我必须使用循环，但我不确定该怎么办？

这就是我到目前为止所拥有的。它是从数据库中生成数组的。

$WorkFind = mysql_query(
  "SELECT Customers.State, WorkOrders.Total 
   FROM WorkOrders 
   INNER JOIN Customers 
   ON WorkOrders.CID=Customers.ID 
   WHERE WorkOrders.Type <> 'Warranty' 
   AND (WorkOrders.Status <> 'Closed' 
   OR WorkOrders.Status <> 'Cancelled') 
   AND WorkOrders.TransferID='0' 
   ORDER BY Customers.State ASC");
while ($Work = mysql_fetch_array($WorkFind)) { 
}

while循环已经形成了数组，但我不确定该放入什么。

我使用的是PHP 5.3和MYSQL 5.2

试试这个：

$WorkFind = mysql_query("SELECT Customers.State AS State, WorkOrders.Total AS Total -- ...");
$total = array();
while ($Work = mysql_fetch_array($WorkFind)) {
  $state = $Work['State'];
  if (!isset($total[$state])) {
    $total[$state] = 0;
  }
  $total[$state] += $Work['Total'];
}
// format as simple table
echo '<table><tr><th>State</th><th>Total</th></tr>';
foreach ($total as $state_name => $state_total) {
  echo '<tr><td>' . $state_name . '</td><td>' . $state_total . '</td></tr>';
}
echo '</table>';