Adding a new client - PHP

To add a new client, I created a form that takes the following information:

• Client name
  
• Address
  
• Email
  
• Phone number
  
• Contact Name

Below is a screen shot of what the form looks like.

Here's the HTML for the form:

<table width="100%" border="0" cellspacing="1" class="block">
             <tr>
             <td>
             <table width="100%" height="19" border="0">
            <tr class="heading">
              <td><a href="Main.php" class="link">[MENU]</a></td>
              <td>USER:</td>
              <td><a href="logout.php"
class="link">LOGOUT</a></td>
            </tr>
          </table>             

             </td>
             </tr>
        <tr>
          <td height="34" colspan="2">
            <form  name="newc" action="NewClient.php"
method="post">
<table width="100%" border="0">
  <tr>
    <td>&nbsp;</td>
    <td><? if(isset($msg)){ echo $msg;}?></td>
  </tr>
  <tr>
    <td width="122"><span class="style1"> Company Name
</span></td>
    <td width="426"><input name="name" type="text" id="name"
size="90"></td>
  </tr>
  <tr>
  <td>Address</td>
  <td><?php
$sBasePath = 'FCKeditor/' ;
$oFCKeditor = new FCKeditor('address') ;
$oFCKeditor->BasePath         = $sBasePath ;
//$oFCKeditor->Value             = 'This is some <strong>sample
text</strong>. You are using <a
href="http://www.fckeditor.net/">FCKeditor</a>.' ;
$oFCKeditor->Create() ;
?></td>
  </tr>
  <tr>
    <td>Email</td>
    <td><input name="email" type="text" size="90"></td>
  </tr>
  <tr>
    <td>Phone</td>
    <td><input name="phone" type="text" size="90"></td>
  </tr>
  <tr>
    <td>Contact name </td>
    <td><input name="contact_name" type="text" id="contact_name"
size="90"></td>
  </tr>
  <tr>
    <td colspan="2"><div align="center" class="style1">
      <input name="submit" type="submit" id="submit"
value="Submit New Client">
    </div></td>
  </tr>
</table>
</form>
</td>
</tr>

</table>

Once the form is submitted, the following code handles the form data:

<? include "FCKeditor/fckeditor.php";
include "config.php";
if(isset($_POST['submit'])){
$query_ins = "INSERT INTO client SET name='".trim(addslashes
($_POST['name']))."',address='".trim(addslashes($_POST
['address']))."',";
$query_ins .= "date_added = '".$td."',email = '".trim(addslashes
($_POST['email']))."',";
$query_ins .= "contact_name = '".trim(addslashes($_POST
['contact_name']))."',phone_no = '".trim(addslashes($_POST
['phone']))."'";
if(mysql_query($query_ins)){
header("location:allclients.php");
}else{
echo mysql_error();
}
}
?>

All that the code above does is match the form data to the table fields and send it to the database, after which the user is sent back to the allclients page.

Conclusion

Client management is the third in the series on creating a invoicing system. The system makes managing your clients easy by allowing you to view a full list of client names and also allowing you to update or remove clients from your database.