PHP Foreach loop from database to calculate sum

Question

I am wondering for all of you more experienced coders how I would take a value coming from my database, which is stored as a double

(Variables regulartime and overtime)

And then calculate the sum of each of the two columns..

foreach ($result as $row) {
    echo '<tr><td>' . $row['username'] . '</td>
        <td>' . $row['date'] . '</td>
        <td>' . $row['jobnumber'] . '</td>
        <td>' . $row['customer'] . '</td>
        <td>' . $row['worksite'] . '</td>
        <td>' . $row['duties'] . '</td>
        <td>' . $row['regulartime'] . '</td>
        <td>' . $row['overtime'] . '</td></tr>';


}

Thank you so much for your help.

Tyler

EDIT I want to add a final row at the bottom of the two to display the sums

`$sum = $row['foo'] + $row['bar']`? it's just simple addition... — Marc B, May 07 '15 at 14:40
I would do it in the SQL not in PHP. "SELECT `username`, `date`, `jobnumber`, `customer`, `worksite`, `duties`, regulartime`, `overtime`, (`overtime` + `regulartime`) as `totaltime` from table;" — eagle12, May 07 '15 at 14:40
@MarcB I want to add a final row at the bottom of the two to display the sums — Tyler H, May 07 '15 at 14:42
@eagle12 post your answer so I can vote for it :) It's probably the fastest way — scraaappy, May 07 '15 at 14:54

score 2 · Answer 1 · answered May 07 '15 at 14:43

function calculateSum(array $data, $field)
{
    return array_reduce(
        $data,
        function ($result, $elem) use ($field) {
            return $result + $elem[$field];
        }, 0
    );
}

calculateSum($result, 'regulartime');
calculateSum($result, 'overtime');

score 2 · Accepted Answer · 2015-05-07T14:55:22.687

As you want to display a table containing each row, then a final row containing the sum, you only have to use your existing foreach loop to increment the totals :

$totalRegularTime = 0;
$totalOverTime = 0;

foreach ($result as $row) {
    echo '<tr><td>' . $row['username'] . '</td>
        <td>' . $row['date'] . '</td>
        <td>' . $row['jobnumber'] . '</td>
        <td>' . $row['customer'] . '</td>
        <td>' . $row['worksite'] . '</td>
        <td>' . $row['duties'] . '</td>
        <td>' . $row['regulartime'] . '</td>
        <td>' . $row['overtime'] . '</td></tr>';

    $totalRegularTime += $row['regulartime'];
    $totalOverTime += $row['overtime'];
}

echo '<tr><td colspan="6">TOTAL</td>
    <td>' . $totalRegularTime . '</td>
    <td>' . $totalOverTime . '</td></tr>';

However if you didn't need to display all the rows in a table first, the best solution would have been to get the sums using SQL.
Eternal1's answer is a good alternative if you can't use SQL (if your data doesn't come from database for example). And it's pretty clean.

score 1 · Answer 3 · answered May 07 '15 at 17:19

1

I would do it in the SQL not in PHP.

SELECT username, date, jobnumber, customer, worksite, duties, regulartime, overtime, (overtime + regulartime) as totaltime FROM table;

answered May 07 '15 at 17:19

eagle12

1,658
11
14

PHP Foreach loop from database to calculate sum

3 Answers3

Linked