Finishing the Invoice Page - PHP

If you're running a business in which you're invoicing clients, you need some way to keep track of which invoices have gone out and which clients have paid. In this second article of a four-part series that covers the creation of a PHP invoicing system, we create the parts that deal with this kind of invoice management.

TABLE OF CONTENTS:

By: Leidago

Poor Best

Rating:

/ 31

September 13, 2006

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

The rest of the page looks like this:

<tr valign="top" class="tblheadings">
 <td width="9%">Invoice # </td>
 <td width="14%">Client Name </td>
 <td width="8%">Status</td>
 <td width="11%">Date Issued </td>
 <td width="11%">Total(excl VAT)</td>
 <td width="13%">Total(incl VAT)</td>
 <td width="20%"> Action </td>
 </tr>
<?
if($num_invoice > 0){
while($invoice = mysql_fetch_assoc($result_invoice)){
 ?>
 <tr valign="top" class="tblinfo">
 <td><?=$invoice['invno'];?></td>
 <td><?=$invoice['name'];?></td>
 <td><? if($td > $invoice['duedate']){
 echo "Overdue";
 $email="yes";
 }else{
 echo $invoice['status'];}
 ?></td>
 <td><?=$invoice['idate'];?></td>
 <? $query_invdetails = "SELECT * FROM clientinv WHERE
finv='".$invoice['invno']."'";
if(!$result_invdetails= mysql_query($query_invdetails)){
echo mysql_error();
}else{
$num_invdetails = mysql_num_rows($result_invdetails);
$invdetails=mysql_fetch_assoc($result_invdetails);}
?>
 <td>£<?=$invdetails['totxVAT'];?></td>
 <td>£<?=$invdetails['totwVAT'];?></td>
 <td><a href="invView.php?iid=<?=$invoice['invno']?>">View </a> |<a
href="delinvoice.php?iid=<?=$invoice['invno']?>">Delete</a> <a href="edInv.php?
iid=<?=$invoice['invno']?>">Update</a> <? if($td > $invoice['duedate']){
 echo "<img src=\"images/RedFlag.gif\" height = \"10\"/>";
 }
 ?>
 <? if(isset($email)){?>
 <a href="emailInv.php?iid=<?=$invoice['invno']?>">Email
Reminder</a>
 <? }?>
 <a href="pdf.php?cid=<?=$invoice['cid']?>"><img
src="images/pdf.gif" width="18" height="18" border="0"/></a></td>
 </tr>
 <? }
 }else{ ?>
 <tr>
 <td colspan="7">No invoices available at present.</td>
 </tr>
 <? }?>
 </table>

So, what is happening here? Basically, we are creating a table that will list all the invoices based on the results from the query. In other words, part of the table will be dynamically generated. The first section of the table shows the headings of the different columns. The columns that we want listed are:

Invoice number.
Client name.
Status – Shows if a invoice is paid or unpaid.
Date issued.
Total (excluding VAT).
Total (including VAT) .
Action - Actions that can be taken, which include viewing, updating or deleting a invoice.

The headings are created by the following HTML code:

Next: Generating a Table >>