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.
Please enable JavaScript to view the comments powered by Disqus. blog comments powered by