因此,代码的结果是:
Hotel: 20
Hotel: 210
Food: 29.04
Fuel: 186
Food: 55
Array (
[0] => Array ( [Category] => Hotel [Price] => 10 [Quantity] => 2 )
[1] => Array ( [Category] => Hotel [Price] => 70 [Quantity] => 3 )
[2] => Array ( [Category] => Food [Price] => 1.21 [Quantity] => 24 )
[3] => Array ( [Category] => Fuel [Price] => 31 [Quantity] => 6 )
[4] => Array ( [Category] => Food [Price] => 5.5 [Quantity] => 10 )
)
如您所见,我将数量和价格相乘,现在我希望添加相同类型的类别,如下所示:
Hotel: 230
Food: 84.04
Fuel: 186
但我一直有字符串+int(或类似的东西)的问题.所以,请告诉我我做错了什么.代码如下:
<!DOCTYPE html>
<html>
<body>
<center>
<h1>DISPLAY DATA PRESENT IN CSV</h1>
<h3>CSV File</h3>
<?php
echo "<html><body><center><table>\n\n";
// $fileName = $_POST['csvfile'];
// $fileName = "./test.csv";
// $summary = array();
$i = 0;
// $index = null;
// $file = fopen($fileName, "r");
$array = $fields = array();
$handle = @fopen("test.csv", "r");
if($handle){
while(($row = fgetcsv($handle, 4096)) !== False){
if(empty($fields)){
$fields = $row;
continue;
}
foreach($row as $k=>$value){
$array[$i][$fields[$k]] = $value;
}
$i++;
}
if(!feof($handle)){
echo "Error: unexpected fgets() fail\n";
}
fclose($handle);
}
foreach($array as $key => $value){
for($a = 0; $a < 1; $a++){
if($value['Category'] == $value['Category']){
echo $value['Category'] . ": " . ($value['Quantity'] * $value['Price']) . "<br>";
}
else{
echo $value['Category'] . ": " . ($value['Quantity'] * $value['Price']) . "<br>";
}
}
}
echo "<br>";
print_r($array);
$sumArray = array();
foreach($array as $k=>$subArray){
foreach($subArray as $key=>$value){
$sumArray['Category'] += $value;
}
}
print($sumArray);
echo "\n</table></center></body></html>";
?>
</center>
</body>
</html>