Array sum and count row in PHP [duplicate]

Question

I have a function getData that returns:

    array:4 [▼
  0 => array:1 [▼
    0 => "5689.01"
  ]
  1 => array:1 [▼
    0 => "5689.01"

  ]
  2 => array:1 [▼
    0 => "0.0"
  ]
  3 => array:1 [▼
    0 => "5665.11"
   ]
]

I need to COUNT number of rows (this time 4, as above) with values that are returned every time when I trigger a call and return total SUM of all results as listed.

 $rows = $this->get('app')->getData();

 if($rows) {
        foreach ($rows as $row) {
            $sumOfAll = 0;
            $total = count($rows);
            $sumOfAll += array_sum(array($row[0] * $total));

            dump($sumOfAll);die;
    }
}

I always get a wrong sum, in this case it was 22756.04.

$sumOfAll = array_sum(array_column($rows, 6))*count($rows); — splash58
– splash58, Commented Jan 25, 2019 at 10:36
It the same as your last question (stackoverflow.com/questions/54361937/…) please avoid this - if the last not relevant remove it — dWinder
– dWinder, Commented Jan 25, 2019 at 10:40

Andreas · Accepted Answer · 2019-01-25 10:38:02Z

4

Use array_sum and array_column to get the values and sum them.
Then use count() to get the count.

$sum = array_sum(array_column($arr, 0));
$count = count($arr);

echo "count is ". $count . " And sum is " . $sum;

https://3v4l.org/HFbgc

answered Jan 25, 2019 at 10:38

Andreas

24k7 gold badges34 silver badges75 bronze badges

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

Comments

Igor Ilic · Accepted Answer · 2019-01-25 10:35:27Z

0

To fix your sum value, you need to move $sumOfAll variable out side of your foreach

Change your code from this:

foreach ($rows as $row) {
    $sumOfAll = 0;
    $total = count($rows);
    $sumOfAll += array_sum(array($row[6] * $total));

    dump($sumOfAll);die;
}

to this:

$sumOfAll = 0;
foreach ($rows as $row) {
    $total = count($rows);
    $sumOfAll += array_sum(array($row[6] * $total));
}
dump($sumOfAll);die;

answered Jan 25, 2019 at 10:35

Igor Ilic

1,3681 gold badge11 silver badges22 bronze badges

Collectives™ on Stack Overflow

Array sum and count row in PHP [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related