John Davidson

Message:

I know there are a lot of topics about this, but just couldn't find any that would actually help me solve the problem.
Ok so i am having a problem with counting rows and values in multidimensional array (imported via .csv)

I am trying to achieve something like...

Array ( [0] => Array ( [0] => 1 [1] => 6278,31 [2] => 4) 

        [1] => Array ( [0] => 2 [1] => 2,0 [2] => 2) 

        [2] => Array ( [0] => 3 [1] => 3,01 [2] => 3) 

         )

where [0] would be buyer id, 1 is total number of buys and [2] total cost.

My current code:

if(($s_open = fopen("sales.csv", "r")) !== FALSE) 

    {

        $s_count = count(file("sales.csv"));

        while(($sales = fgetcsv($s_open, 100, ";")) !== FALSE) 

        {

            ...

        }

        fclose($s_open);

    }

Thanks in advance.

---

My Answer:
> Array ( [id] => 1 [value] => 10 ) [1] => Array ( [id] => 1 [value] => 20 ) [2] => Array ( [id] => 2 [value] => 15 ) [3] => Array ( [id] => 2 [value] => 25 ) )_And i want to count the values for each id, so the output should be something like..._Array ( [1] => 30 [2] => 40 )__Here is a simple code snippet that should help you achieve this:_php

// Your multidimensional array
$array = array(
array('id' => 1, 'value' => 10),
array('id' => 1, 'value' => 20),
array('id' => 2, 'value' => 15),
array('id' => 2, 'value' => 25)
);

// Initialize an empty array to store the counts
$counts = array();

// Loop through the array and sum the values for each id
foreach ($array as $row) {
$id = $row['id'];
$value = $row['value'];

if (isset($counts[$id])) {
$counts[$id] += $value;
} else {
$counts[$id] = $value;
}
}

// Output the counts
print_r($counts);

?>


This code snippet should give you the desired output of counting the values for each id in the multidimensional array. Let me know if you need any further assistance!