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
– Marc B, Commented May 7, 2015 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
– eagle12, Commented May 7, 2015 at 14:40
@MarcB I want to add a final row at the bottom of the two to display the sums — Tyler H
– Tyler H, Commented May 7, 2015 at 14:42

score 2 · Accepted Answer · 2015-05-07 14:55:22Z

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.

Eternal1 · Accepted Answer · 2015-05-07 14:43:02Z

2

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');

answered May 7, 2015 at 14:43

Eternal1

5,6253 gold badges34 silver badges48 bronze badges

Comments

eagle12 · Accepted Answer · 2015-05-07 17:19:01Z

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 7, 2015 at 17:19

eagle12

1,67811 silver badges14 bronze badges

Collectives™ on Stack Overflow

PHP Foreach loop from database to calculate sum

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related