php calculate values from a loop

Question

I can't get my head around this.
I have a csv-file containing companynames and a certain value.

I run a script that get's the companyname and value from the csv.
A company can contain multiple values. Here's what it looks like

[company1][123]
[company1][65456]
[company1][435]
[company1][234235]
[company2][65464]
[company2][53543]

What I want to do is get every value from every separate company and calculate the sum of all values from that specific company.

So I tried this:

foreach($data as $companies){
    $company = $companies['name'];
    $value = $companies['value'];
    if ($company == 'company1'){
        echo $value;
    }
}

$data is the array with values from the csv

For testing purposes I have manually written a companies name in the if statement but this should be dynamically loaded from the $data-array.

After this it should calculate the sum of all values.

How can I accomplish this?

you need all companies sum or sum of each company??

Vishnu Bhadoriya
– Vishnu Bhadoriya

2017-06-30 07:20:58 +00:00
Commented Jun 30, 2017 at 7:20 — Vishnu Bhadoriya
– Vishnu Bhadoriya, Commented Jun 30, 2017 at 7:20
No the sum of the values belong to that company

Interactive
– Interactive

2017-06-30 07:24:31 +00:00
Commented Jun 30, 2017 at 7:24 — Interactive
– Interactive, Commented Jun 30, 2017 at 7:24

Sebastian Brosch · Accepted Answer · 2017-06-30 07:30:11Z

3

You can use the following solution:

$arr_sum = [];

foreach ($data as $companies) {
    $company = $companies['name'];
    $value = $companies['value'];

   if (!isset($arr_sum[$company])) {
       $arr_sum[$company] = 0;
   }

   $arr_sum[$company] += $value;
}

demo: http://ideone.com/KXGCOd

edited Jun 30, 2017 at 7:30

answered Jun 30, 2017 at 7:25

Sebastian Brosch

43.8k15 gold badges78 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Interactive Over a year ago

Dude... Like a charm. Thank you!

Iron · Accepted Answer · 2017-06-30 08:00:12Z

if I understand well your issue, this should work.

$data = [
['name' => 'company1', 'value' => 123],
['name' => 'company1', 'value' => 65456],
['name' => 'company1', 'value' => 435],
['name' => 'company1', 'value' => 234235],
['name' => 'company2', 'value' => 65464],
['name' => 'company2', 'value' => 53543]
];
$result = 0;
foreach($data as $companies)
{
    $company = $companies['name'];
    $value = $companies['value'];
    if ($company == 'company1')
    {
        $result += $value;
    }
} 
echo $result;

HOWEVER! PHP is not very powerful when it comes to calculations, especially when embedded in a loop. If your companies has couple of different values each and you have couple of companies too, then fine. But if your file contains thousands of companies with many values, then your script will be very limited (think to increase/deactivate server time out). I would suggest to use python for your specific case, it would be much faster, easier and more important: it will scale :)

Collectives™ on Stack Overflow

php calculate values from a loop

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related