PHP - Get total of values displayed in table

Question

I am using a pre defined php inventory manager. So in sales my data is getting stored this way:

[{"product_id":"8","total_number":"70","selling_price":"110"}]

enter image description here

To display these values in table I use the following code

$sub_total          =   0;
$invoice_entries    =   json_decode($row['invoice_entries']);
foreach ($invoice_entries as $row2):
    $sub_total  +=  ($row2->total_number * $row2->selling_price);                                       
endforeach;

$sub_total      =   $sub_total - ( $sub_total * ($row['discount_percentage'] / 100) );
$grand_total    =   $sub_total + ( $sub_total * ($row['vat_percentage'] / 100) );
echo $grand_total;

I get the desired output here which is the total value of the sale.

enter image description here

Now, I am trying to give a report feature which will show all the invoices with the client name, sale value. I want to calculate the total of all the invoices and show in a table row i.e. Total of $grand_total.

I am unable to understand how do I get that. Any java script could do it? I don't understand js well. So I have no clue if its possible with it or not.

Thanks in advance

@Strawberry : Good advice but not applicable right now as Client has already started to use it :) — user1299086
– user1299086, Commented May 15, 2015 at 6:11
create an variable simply name as $final_total, initial to 0 when reload page, $final_total += $grand_total on every row you get $grand_total value, then display it — Yu Yenkan
– Yu Yenkan, Commented May 15, 2015 at 6:38
@YuYenkan : Can you show how do I code it ? It will really be helpful — user1299086
– user1299086, Commented May 15, 2015 at 6:50

Yu Yenkan · Accepted Answer · 2015-05-15 06:55:57Z

3

since you storing data in database, you can use another query to sum up all the grand_total from all the record you want to retrieve.

select sum(grand_total) from yourTable where yourFilter

if grand_total is sum up from another query, you can use nested select statement to do it.

http://www.mysqltutorial.org/mysql-subquery/

this link have some example on nested select.

answered May 15, 2015 at 6:55

Yu Yenkan

7652 gold badges9 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

PHP - Get total of values displayed in table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related