Code: Select all
<?php
if($_POST)
{
$name = $_POST['fname'];
$same = $_POST['sname'];
$tel1 = $_POST['tel1'];
$email = $_POST['email'];
$valid_street1 = $_POST['street1'];
$postcode = $_POST['postcode'];
//FIRST NAME VALIDATION
if (eregi('^[A-Za-z]{3,20}$',$name))
{
$valid_fname=$fname;
}
else
{
$error_fname='Enter valid name.';
}
//SURNAME VALIDATION
if (eregi('^[A-Za-z]{3,20}$',$sname))
{
$valid_sname=$sname;
}
else
{
$error_sname='Enter valid name.';
}
// TELEPHONE VALIDATION
if (eregi('^((\(?0\d{4}\)?\s?\d{3}\s?\d{3})|(\(?0\d{3}\)?\s?\d{3}\s?\d{4})|(\(?0\d{2}\)?\s?\d{4}\s?\d{4}))(\s?\#(\d{4}|\d{3}))?$', $tel1))
{
$valid_tel1=$tel1;
}
else
{
$error_tel1='Enter valid telephone number.';
}
//E-MAIL VALIDATION
if (eregi('^([0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\w]*[0-9a-zA-Z]\.)+[a-zA-Z]{2,9})$',$email))
{
$valid_email=$email;
}
else
{
$error_email='Enter valid e-mail address. (For no e-mail enter nnn@nnn.nnn)';
}
//POSTCODE VALIDATION
if (eregi('^((([A-PR-UWYZ](\d([A-HJKSTUW]|\d)?|[A-HK-Y]\d([ABEHMNPRVWXY]|\d)?))\s*(\d[ABD-HJLNP-UW-Z]{2})?)|GIR\s*0AA)$',$postcode))
{
$valid_postcode=$postcode;
}
else
{
$error_postcode='Enter valid UK postcode.';
}
if((strlen($valid_fname)>0)&&(strlen($valid_sname)>0)
&&(strlen($valid_tel1)>0)&&(strlen($valid_email)>0)&&(strlen($valid_street1)>0)&&(strlen($valid_postcode)>0)
{
$link = mysql_connect('localhost', 'uname', 'pwd
');
mysql_select_db('computer', $link);
mysql_query("INSERT INTO clients (fname, sname, tel1, e-mail, street1, postcode)
VALUES ($valid_fname, $valid_sname, $valid_tel1, $valid_email, $valid_street1, $valid_postcode)");
header("Location: http://192.168.0.222:1991/dev/computer_repair_manage_clients/add_client_success.html");
}
else{
}
}
?>
<html>
<head>
<script type="text/javascript" src="9lessons.js"></script>
<link rel="stylesheet" type="text/css" href="http://192.168.0.222:1991/dev/computer_repair/global_style.css"/>
</head>
<body>
<div id="topNav">
<a href='http://192.168.0.222:1991/dev/computer_repair/'><strong>HOME </strong></a>
<a href='http://192.168.0.222:1991/dev/computer_repair/manage_repairs/'>Manage Repairs </a>
<a href='http://192.168.0.222:1991/dev/computer_repair/manage_clients/'>Manage Customers </a>
<a href='http://192.168.0.222:1991/dev/computer_repair/reports/'>Reports</a>
</div>
<div id="subNav">
<a href='http://192.168.0.222:1991/dev/computer_repair/manage_clients/'><strong>HOME</strong></a>
<a href='http://192.168.0.222:1991/dev/computer_repair/manage_repairs/add_client.php'>Add New Customer</a>
<a href='http://192.168.0.222:1991/dev/computer_repair/manage_repairs/update_client.php'>Update Customer Details</a>
<a href='http://192.168.0.222:1991/dev/computer_repair/manage_repairs/delete_client.php'>Delete a Customer</a>
</div>
<div id="content">
<form autocomplete="off" enctype="multipart/form-data" method="post" action="" name="form">
<h3>Add New Customer</h3>
<table border="0" bordercolor="#FFCC00" style="background-color:#FFFFFF" width="350" cellpadding="3" cellspacing="3">
<tr>
<td><label for="fname">First Name</label></td>
<td><input type="text" name="fname" id="fname" placeholder="First Name" length="30" value="<?php echo $error_fname;?>"></td>
</tr>
<tr>
<td><label for="sname">Surname</label></td>
<td><input type="text" name="sname" id="sname" placeholder="Surname" length="30" value="<?php echo $error_sname;?>"></td>
</tr>
<tr>
<td><label for="tel1">Telephone Number</label></td>
<td><input type="text" name="tel1" id="tel1" placeholder="Telephone Number" length="30" value="<?php echo $error_tel1;?>"></td>
</tr>
<tr>
<td><label for="e-mail">E-mail Address</label></td>
<td><input type="text" name="email" id="email" placeholder="E-Mail Address" length="50" value="<?php echo $error_email;?>"></td>
</tr>
<tr>
<td><label for="street1">Street 1</label></td>
<td><input type="text" name="street1" id="street1" placeholder="Street Address" length="30"></td>
</tr>
<tr>
<td><label for="postcode">Postcode</label></td>
<td><input type="text" name="postcode" id="postcode" placeholder="Postcode" length="30" value="<?php echo $error_postcode;?>"></td>
</tr>
</table>
<br>
<input type="submit" value="Submit" style=" background:#0060a1; color:#FFFFFF; font-size:14px; border:1px solid #0060a1"/>
</form>
</div>
</body>
</html>