Solved

How to total added loops

Posted on 2013-05-14
7
162 Views
Last Modified: 2013-05-14
I have a small sum that loops for each individual item. Is there a way to total the subtotals though?

<?php 
$theqty = $row_Recordset1['qtyy'];
$theprice = $row_Recordset1['qprice'];
$thetotal = $theqty * $theprice;
echo $thetotal; 
?>

Open in new window

0
Comment
Question by:jonofat
  • 4
  • 3
7 Comments
 
LVL 109

Expert Comment

by:Ray Paseur
ID: 39164300
There is no loop shown in the code sample, so there would not be any subtotals.
0
 

Author Comment

by:jonofat
ID: 39164310
Sorry..

 <?php $i=0; do { ?>
          <tr>
            <td class="bottomborder"> <input name="record[<?php echo $i ?>][qtyy]" value="<?php echo $row_Recordset1['qtyy']; ?>" size="1" />
              x <?php echo $row_Recordset1['pdescription']; ?>
              <input name="record[<?php echo $i ?>][productidd]" type="hidden" id="record[<?php echo $i ?>][productidd]" value="<?php echo $row_Recordset1['productidd']; ?>" /></td>
            <td class="bottomleft">R <?php echo $row_Recordset1['qprice']; ?> x <?php echo $row_Recordset1['qtyy']; ?>= <span class="bottomborder">
              R<?php $theqty = $row_Recordset1['qtyy'];
$theprice = $row_Recordset1['qprice'];
$thetotal = $theqty * $theprice;
echo $thetotal; ?>
              ex. vat
              <input name="totalprice" type="hidden" id="totalprice" value="<?php echo $thetotal; ?>" />
              </span></td>
          </tr>
          <?php $i++; } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

Open in new window

0
 
LVL 109

Expert Comment

by:Ray Paseur
ID: 39164344
How would the subtotals be grouped (what column name)?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:jonofat
ID: 39164363
Well, it wouldn't be a column name I would use, wouldn't it be $thetotal ?

$thetotal = $theqty * $theprice;

which gives a subtotal for each line. But I need to add the subtotal of each line together. So if there are 3 individual products that look like this:

2 x $4 = $8
1 x $3 = $3
3 x $4 = $12

I somehow need it to add those up to give me $23.

I don't know if it would be some kind of foreach loop with $thetotal or what?
0
 

Author Comment

by:jonofat
ID: 39164386
I took a wild guess with this but it didn't get me anywhere.

$sum = 0;
foreach($thetotal as $value) $sum = $sum + $value;
echo $sum;
0
 
LVL 109

Accepted Solution

by:
Ray Paseur earned 500 total points
ID: 39164436
OK, I think I get it better now.  This may not be exact (I can't test it), but it should be pretty close.
<?php 

// INITIALIZE A VARIABLE
$sum_total = 0;
 
$i=0; 

do { ?>
          <tr>
            <td class="bottomborder"> <input name="record[<?php echo $i ?>][qtyy]" value="<?php echo $row_Recordset1['qtyy']; ?>" size="1" />
              x <?php echo $row_Recordset1['pdescription']; ?>
              <input name="record[<?php echo $i ?>][productidd]" type="hidden" id="record[<?php echo $i ?>][productidd]" value="<?php echo $row_Recordset1['productidd']; ?>" /></td>
            <td class="bottomleft">R <?php echo $row_Recordset1['qprice']; ?> x <?php echo $row_Recordset1['qtyy']; ?>= <span class="bottomborder">
              R<?php $theqty = $row_Recordset1['qtyy'];
$theprice = $row_Recordset1['qprice'];
$thetotal = $theqty * $theprice;
echo $thetotal; 

// ADD TO THE VARIABLE
$sum_total = $sum_total + $thetotal;

?>
              ex. vat
              <input name="totalprice" type="hidden" id="totalprice" value="<?php echo $thetotal; ?>" />
              </span></td>
          </tr>
<?php 

$i++; 
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); 

// AT END OF LOOP, SHOW THE VARIABLE
var_dump($sum_total);

?>

Open in new window

0
 

Author Comment

by:jonofat
ID: 39164456
Tested it. Works perfectly. Genius! :)
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Google Maps API and PHP 25 50
php mysql check email already in database. (second check) 7 68
Split wordpress loop 35 56
Add a loading gif while php runs server side 15 37
I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
This article discusses four methods for overlaying images in a container on a web page
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question