[Resolved] Invoice System

talkster5

Hi there
What i am trying to do is build an invoice system for my clients to see how much they owe each month and so they can print it out for any reasons they may need. So far i have it to print the rows in the database into my table but now i am trying to add up the ammounts for each item and put it into a total box.

For example:

http://www.deadlyhosting.com/temp/client/invoice.php

The top table with the total is just a html script as an example and then the one below on the left is my actual php script which retrieves the invoice from the database. Now what i want to do is just total up those ammounts and put them into a total as shown in the html form. If you need to see any kind of code of what i have done so far just let me know and i will post it so you can see it.

pete_bisby

If you're looping through the records, why don't you have a variable that totals up as you go through the records:

for ($i=0; $i < mysql_num_rows($invoice); $i++) { // where $invoice is your individual items of your invoice
  $invItem = mysql_fetch_array($invoice);
  ...
  ...
  $totalAmount += $invItem["itemAmount"];
}

Once your loop has finished, then you can print the $totalAmount.

talkster5

This is my code to display each item.

<?php
mysql_select_db($database_Site_Database, $Site_Database);
$sql    = "SELECT * FROM client_invoices ORDER BY id ASC LIMIT 0,15"; 
$result = mysql_query($sql) or die(mysql_error()); 
if(mysql_num_rows($result) > 0) { 
echo "<table width='525' border='0'>\n";
echo "  <tr bgcolor='#0099FF'>\n";
echo "    <td width='21'><b><font color='#FFFFFF'>\n";
echo "    <div align='center' class='style2'><strong>ID</strong></div>\n";
echo "    </font></b></td>\n"; 
echo "    <td width='101'><b><font color='#FFFFFF'>\n";
echo "    <div align='center' class='style2'><strong>Date</strong></div>\n";
echo "    </font></b></td>\n";
echo "    <td width='272'><b><font color='#FFFFFF'>\n";
echo "    <div align='center' class='style2'><strong>Description</strong></div>\n"; 
echo "    </font></b></td>\n";
echo "    <td width='113'><b><font color='#FFFFFF'>\n"; 
echo "    <div align='center' class='style2'><strong>Ammount</strong></div>\n";
echo "    </font></b></td>\n";
echo "  </tr>\n"; 
while ($row = mysql_fetch_array($result)) 
    { 
	echo "  <tr bgcolor='#CCCCCC'>\n";
	echo "   <td><div align='center'>$row[id]</div></td>\n";
	echo "   <td><div align='center'>$row[date]</div></td>\n";
	echo "   <td><div align='center'>$row[description]</div></td>\n";
	echo "   <td><div align='center'>$row[ammount]</div></td>\n";
	echo "  </tr>\n"; 
    } 
echo "</table>\n";
}
?>

pete_bisby

while ($row = mysql_fetch_array($result))  

    {  

    echo "  <tr bgcolor='#CCCCCC'>\n"; 
    echo "   <td><div align='center'>$row[id]</div></td>\n"; 
    echo "   <td><div align='center'>$row[date]</div></td>\n"; 
    echo "   <td><div align='center'>$row[description]</div></td>\n"; 
    echo "   <td><div align='center'>$row[ammount]</div></td>\n"; 
    echo "  </tr>\n";
    $totalAmount += $row[ammount];  

    }  

echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td bgcolor='#CCCCCC' align=center>$totalAmount</td></tr>";
echo "</table>\n";

This is assuming that the value stored within your table is a numeric, and not a formatted string.

If it is a formatted string, you'll have to strip the first character and then perform the sum:

  $totalAmount += (float)substr($row[ammount],1);

talkster5

Thanks, that looks like the kind of thing i needed. I will go and try it in a minute and get back to you.

talkster5

Works great, thanks.