Updating client information - PHP

What's an invoicing system that can't manage the data for the clients you're invoicing? This article, the third of four parts, shows how to make managing your clients easy. This part of the system allows you to view a full list of client names, and add, update or remove clients from your database.

TABLE OF CONTENTS:

By: Leidago

Poor Best

Rating:

/ 15

September 20, 2006

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

To update client information we need to create a form that will display all of the client's current information:

<form action="edClient.php" method="post" name="updateclient">
            <input name="cid" type="hidden" value="<?=$_GET
['cid'];?>" />
            <input name="dates" type="hidden" value="<?=$clients
['date_added'];?>" />
            <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="13%">Client Name </td>
          <td width="87%"><input name="cname" type="text"
id="cname" size="60" value="<?=$clients['name'];?>"/></td>
        </tr>
        <tr>
          <td>Address</td>
          <td>
                           <?php
$oFCKeditor = new FCKeditor('address') ;
$oFCKeditor->BasePath = 'FCKeditor/';
$oFCKeditor->Value = $clients['address'];
$oFCKeditor->Create() ;
?>
                          </td>
        </tr>
        <tr>
          <td>Contact Name </td>
          <td><input name="contact" type="text" id="contact"
size="60" value="<?=$clients['contact_name'];?>"/></td>
        </tr>
                        <tr>
          <td>Telephone Number </td>
          <td><input name="phone" type="text" id="phone"
size="60" value="<?=$clients['phone_no'];?>"/></td>
        </tr>
                        <tr>
          <td>Email Address </td>
          <td><input name="email" type="text" id="email"
size="60" value="<?=$clients['email'];?>"/></td>
        </tr>
        <tr>
          <td> </td>
          <td><input type="submit" name="submit" value="Update
Client" /></td>
        </tr>

</table>

As you can see from the code, the form itself is contained within a table and has several form elements in which the retrieved query results are placed. The code below shows how the records were retrieved:

<?
ob_start();
include "config.php";
include "FCKeditor/fckeditor.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);
}

if(isset($_POST['submit'])){

$query_ins = "UPDATE client SET name='".trim(addslashes($_POST
['cname']))."',address='".trim(addslashes($_POST
['address']))."',";
$query_ins .= "date_added = '".trim(addslashes($_POST
['dates']))."',email = '".trim(addslashes($_POST['email']))."',";
$query_ins .= "contact_name = '".trim(addslashes($_POST
['contact_name']))."',phone_no = '".trim(addslashes($_POST
['phone_no']))."' WHERE id = '".$_POST['cid']."'";
if(mysql_query($query_ins)){
header("location:allclients.php");
}else{
echo mysql_error();
}

}
?>

The code has two parts. First it retrieves client information based on the client id that is sent from the allclients page:

Then it updates the record when the form is submitted:

Once the update has been completed, the user is sent back to the allclients page. Below is a screen shot of the allclients page: