Adding Variables from a while loop

DeadlySin3

Oy.. I hope this makes sense to someone.

What i'm doing is this; connecting to my database (mysql) and using a while loop to display all rows found. What I want to do is add the values of each row, and put the total value into a variable; maybe called $grandtotal.

Here's some code that i'm working with.

<?php

// SQL Statement We're sending to the Server
$taxQuery = 'SELECT * ';
$taxQuery .= 'FROM `taxinfo` ORDER BY id DESC LIMIT 0, 30';

$result = @mysql_query($taxQuery);


// Testing SQL Statements we're sending to the server
if (! $result ) {
echo "A Fatal Error Has Occurred" . mysql_error(); die();
}

//Now Displaying our Information
?>
<h4>Tax Records</h4>
<table width="100%" border="1" cellspacing="1" cellpadding="1">
  <tr>
    <td>Date</td>
    <td>Customer Name</td>
    <td>Labor</td>
    <td>Parts</td>
    <td>Parts Cost</td>
    <td>Parts Profit</td>
    <td>Total Profit</td>
    <td>Tax Collected</td>
    <td>Transaction ID</td>
  </tr>
<?php
while ( $r = mysql_fetch_array($result) ) {

//Setting up our row data as variables to make them easier to display

$id=$r['id'];
$date=$r['date'];
$customer=$r['customer'];
$labor=$r['labor'];
$parts=$r['parts'];
$partscost=$r['partscost'];
$partsprofit=$r['partsprofit'];
$totalprofit=$r['totalprofit'];
$taxcollected=$r['taxcollected'];

$displayInfo =
   "<tr>
    <td>$date</td>
    <td>$customer</td>
    <td>\$$labor</td>
    <td>\$$parts</td>
    <td>\$$partscost</td>
    <td>\$$partsprofit</td>
    <td>\$$totalprofit</td>
    <td>\$$taxcollected</td>
    <td>$id</td>
    </tr>";

echo "$displayInfo";


} // End While Loop

?>

</table>

Now, as i've implied, the code above works as expected.

But i'm unsure how I would add up the grand totals of $labor and put the total in a variable called $grandtotallabor. same for all the parts vars and profit & tax vars. They are being stored as integers in the database.

So if

labor| 100

labor| 125

Labor Total = 225

I would appreciate any help on this matter. It's just something i'm fooling around with and isn't really something I absolutely need, but this would be great to know for future references 🙂

Also, i'm running PHP 4.3.3 on Windows XP as a server module; on Apache 2.0.47. Though I doubt that makes any difference at all for this...

LordShryku

Try this...

$gTotal=0; // set a 0 vaar for grand total
while($r=mysql_fetch_array($result)) { 
    $id=$r['id']; 
    $date=$r['date']; 
    $customer=$r['customer']; 
    $labor=$r['labor']; 
    $parts=$r['parts']; 
    $partscost=$r['partscost']; 
    $partsprofit=$r['partsprofit']; 
    $totalprofit=$r['totalprofit']; 
    $taxcollected=$r['taxcollected']; 

// now for every result, add to the grand total
$gTotal += $labor;
}

osusano

i dont know if i answered your question but i add the total on your script

<?php 

// SQL Statement We're sending to the Server 
$taxQuery = 'SELECT * '; 
$taxQuery .= 'FROM `taxinfo` ORDER BY id DESC LIMIT 0, 30'; 

$result = @mysql_query($taxQuery); 


// Testing SQL Statements we're sending to the server 
if (! $result ) { 
echo "A Fatal Error Has Occurred" . mysql_error(); die(); 
} 

//Now Displaying our Information 
?> 
<h4>Tax Records</h4> 
<table width="100%" border="1" cellspacing="1" cellpadding="1"> 
  <tr> 
    <td>Date</td> 
    <td>Customer Name</td> 
    <td>Labor</td> 
    <td>Parts</td> 
    <td>Parts Cost</td> 
    <td>Parts Profit</td> 
    <td>Total Profit</td> 
    <td>Tax Collected</td> 
    <td>Transaction ID</td> 
  </tr> 
<?php 
while ( $r = mysql_fetch_array($result) ) { 

//Setting up our row data as variables to make them easier to display 

$id=$r['id']; 
$date=$r['date']; 
$customer=$r['customer']; 
$labor=$r['labor']; 
$parts=$r['parts']; 
$partscost=$r['partscost']; 
$partsprofit=$r['partsprofit']; 
$totalprofit=$r['totalprofit']; 
$taxcollected=$r['taxcollected']; 

//added as per request
$grandTotalLabor = $grandTotalLabor + $labor;
$grandTotalTax = $grandTotalTax + $taxcollected;
$grandTotalParts = $granTotalParts + $partsprofit;
$grandTotalProfit = $grandTotalProfit + $totalprofit;

$displayInfo = 
   "<tr> 
    <td>$date</td> 
    <td>$customer</td> 
    <td>\$$labor</td> 
    <td>\$$parts</td> 
    <td>\$$partscost</td> 
    <td>\$$partsprofit</td> 
    <td>\$$totalprofit</td> 
    <td>\$$taxcollected</td> 
    <td>$id</td> 
    </tr>"; 

echo "$displayInfo"; 


} // End While Loop 

?> 

</table>

DeadlySin3

Whoa..

Turns out that was easier than I imagined:

For some reason I was picturing some really ugly multidimensional arrays followed by a foreach loop or two.

Thanks a million!

DeadlySin3

I would like to make certain that every field in a form is being filled out.

I've tried quite a few different ways, some work and some do not; the most tedious way (which works) is as follows:

<?php
$customer = $_POST['customer'];
$labor = $_POST['labor'];
$parts = $_POST['parts'];
$partscost = $_POST['partscost'];
$partsprofit = $_POST['partsprofit'];
$totalprofit = $_POST['totalprofit'];
$taxcollected = $_POST['taxcollected'];

if(!$customer) { echo "You did not fill in the Customer field"; die(); }
if(!$labor) { echo "You did not fill in the Labor field"; die(); }
if(!$parts) { echo "You did not fill in the Parts field"; die(); }
if(!$partscost) { echo "You did not fill in the Parts Cost field"; die(); }
if(!$partsprofit) { echo "You did not fill in the Parts Profit field"; die(); }
if(!$totalprofit) { echo "You did not fill in the Total Profit field"; die(); }
if(!$taxcollected) { echo "You did not fill in the Tax Collected field"; die(); }
?>

Yes, tedious! Long, boring and.. oy.

Is there a better way to do this with just a few lines of code?

I've tried a few ways that are a lot like this one; but they don't work ( the empty form gets input into the database anyway)

<?php
$available = array ( 
            "Customer" => "$customer", 
            "Labor" => "$labor", 
            "Parts" => "$parts",
            "Parts Cost" => "$partscost", 
            "Parts Profit" => "$partsprofit", 
            "Total Profit" => "$totalprofit",
            "Tax Collected" => "$taxcollected" 
                    );

foreach ($available as $required) {
foreach ($required as $key=>$value) {
if ($value == "" ) { echo "You did not fill in the <b>$key</b> field"; die(); }
}
}
?>

I know it's late and thats probably why the code above makes no sense. lol.

Anyway, anyone know of a sure fire way ( that isn't long and tedious ) to make certain all variables contain a string or int?