Client Management for a PHP Invoicing System - Deleting clients and viewing their details

(Page 3 of 5 )

Delete Client

Simply deletes a client from the database:

<?
include "config.php";
if(isset($_GET['cid'])){

$query = "DELETE FROM client WHERE id = '".$_GET['cid']."'";
if(mysql_query($query))
{
header("location:allclients.php");

}else{
echo mysql_error();
}

}
?>

View Client Details

Shows the client information, this is done by sending a client id to the cdetails.php page:

<?
include "FCKeditor/fckeditor.php";
include "config.php";
if(isset($_GET['cid'])){
$query_clients = "SELECT * FROM client WHERE id = '".$_GET
['cid']."'";
$result_clients = mysql_query($query_clients);
$num_clients = mysql_num_rows($result_clients);
$clients = mysql_fetch_assoc($result_clients);
}
?>

Once the script receives the client id, it searches for that client and shows it in an HTML table:

<table width="100%" border="0" cellspacing="1" class="block">
        <tr>
          <td colspan="2"><table width="100%" height="19"
border="0">
            <tr class="heading">
              <td width="22%"><a href="Main.php" class="link">
[MENU]</a></td>
              <td width="17%"> <a href="allclients.php">CLIENT
LISTINGS</a> </td>
              <td width="24%">USER:<?=$user;?></td>
              <td width="37%"><a href="logout.php"
class="link">LOGOUT</a></td>
            </tr>
          </table></td>
        </tr>
        <tr>
          <td width="46%"><?=$clients['name'];?> </td>
          <td width="54%">Date Added:<?=$clients['date_added'];?> </td>
        </tr>
        <tr>
          <td><?php
$oFCKeditor = new FCKeditor('address') ;
$oFCKeditor->BasePath = 'FCKeditor/';
$oFCKeditor->Value = $clients['address'];
$oFCKeditor->Create() ;
?></td>
          <td><a href="edClient.php?cid=<?=$clients['id']?
>">Update Details </a></td>
        </tr>
      </table>

There is also a link to update the client information if you so wish.

Next: Updating client information >>
 

More PHP Articles
More By Leidago

Comments On: Client Management for a PHP Invoicing System

· A couple of things:- shorttags will not work on all servers. It's always better to...    · What tags are you referring to? And also where exactly is escaping not...    · With shorttags I mean <? instead of the full tags <?php (hope that comes through the...    · Thanks will keep this in mind.   >>> Post your comment now!