Client Management for a PHP Invoicing System - Building a table
(Page 2 of 5 )
The next step is to build an HTML table that will display the following headers:
- Client Name
- Number of Invoices
- Action
Here's the HTML to build the table:
</tr>
<tr class="tblheadings">
<td><strong>Client Name</strong> </td>
<td><strong>Number of Invoices</strong></td>
<td><strong>Action</strong></td>
</tr>
Next we built the dynamic side of the table according to the results from the query:
<?
if($num_clients > 0){
while($clients = mysql_fetch_assoc
($result_clients)){
?>
<tr class="tblinfo">
<td><?=$clients['name'];?> </td>
<td><? $query_invoices = "SELECT *
FROM invoices WHERE cid = '".$clients['id']."' ";
$qi=mysql_query($query_invoices);
$numqi=mysql_num_rows($qi);
if($numqi > 0){
echo $numqi;
}else{
echo "0";
}?> </td>
<td><a href="cdetails.php?cid=<?=$clients['id']?>">View
Details </a> |<a href="delclient.php?cid=<?=$clients['id']?
>">Delete</a> <a href="edClient.php?cid=<?=$clients['id']?
>">Edit</a></td>
</tr>
<? }
}else{?>
<tr>
<td colspan="2"><p>There are currently no
client details available.</p></td>
</tr>
<? }?>
The reason why we always list the contents of a particular table is because it gives us the means to delete and update the information. If you look at the Action column of the table you will see several actions that can be taken regarding a particular record. You can either delete, view or update a record. Let's deal with all three actions and see how it's done.
Next: Deleting clients and viewing their details >>
More PHP Articles
More By Leidago
/ 14 
