how to sum array values from "for" loop

Question

Here is my code :

<tr align="right">
    <td style="white-space: nowrap" align="left"><?= $dt_left_header ?></td>
    <td></td>
    <?php
    //trx data
    for($p=0; $p < count($arr_prd_grp); $p++){
        $prd_id = $arr_prd_grp[$p] ;
        //print_r($arr_prd_grp[$p]);
        if($left_header[$j][1] == 1){
            echo '<td></td>';
        }else{
            echo'
                <td>'.number_format($arr_amt[$coa_id][$prd_id], 2,',','.').'</td>
                ';
        }
    }
    //TOTAL
    if($left_header[$j][1] == 1){
        echo '<td></td>';
    }else{
        echo'
              <td>'.number_format($amt_tot += $arr_amt[$coa_id][$prd_id], 2,',','.').'</td>
            ';
    }

    ?>
</tr>

In this case, I want to calculate total of $arr_amt[$coa_id][$prd_id] . My code already calculate it but the result is not equal with my expectation. Can someone tell me how to make it right? Thanks

please add what you are getting and what you are expecting... — Yash Parekh
– Yash Parekh, Commented Jan 5, 2018 at 10:28
@YashParekh expected : -2.272.987.032, what I've got : -241.839.381.541. — payket
– payket, Commented Jan 5, 2018 at 10:33
Maybe if you showed us a relevant example of the data in $arr_amt some of this code would make more sense — RiggsFolly
– RiggsFolly, Commented Jan 5, 2018 at 10:36
@splash58 I've already did, but I got this : -244,112,368,573, my expectation is : -2.272.987.032 — payket
– payket, Commented Jan 5, 2018 at 10:36

Simos Fasouliotis · Accepted Answer · 2018-01-05 10:38:54Z

1

Move the sum calculation to the first loop, then show the result in the appropriate place. To made it easier i've made an extra variable $totalAmount;

Also my guess is that you are having another outer loop (maybe for each table row). Your current code did not default the totalAmount to 0, so it was adding all the ammounts of each rows, thats why you resulted in such a big number. We add a default value 0 for each row to help that.

<tr align="right">
    <td style="white-space: nowrap" align="left"><?= $dt_left_header ?></td>
    <td></td>
    <?php
    //trx data
    $totalAmount = 0; // default it
    for($p=0; $p < count($arr_prd_grp); $p++){
        $prd_id = $arr_prd_grp[$p] ;
        //print_r($arr_prd_grp[$p]);
        if($left_header[$j][1] == 1){
            echo '<td></td>';
        }else{
            echo'
                <td>'.number_format($arr_amt[$coa_id][$prd_id], 2,',','.').'</td>
                ';
                $totalAmount+=$arr_amt[$coa_id][$prd_id];
        }
    }
    //TOTAL
    if($left_header[$j][1] == 1){
        echo '<td></td>';
    }else{
        echo'
              <td>'.number_format($totalAmount, 2,',','.').'</td>
            ';
    }

    ?>
</tr>

answered Jan 5, 2018 at 10:38

Simos Fasouliotis

1,3902 gold badges18 silver badges37 bronze badges

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

1 Comment

payket Over a year ago

thanks for ur help, my problem solved. The first row already correct, but the next row it return a big number. I'll try to catch it up, once again thanks Simos :))

Collectives™ on Stack Overflow

how to sum array values from "for" loop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related