Can someone analyze the code and let me know where i am doing wrong
<?php
include('connection/mysql_connect.php');
include('includes/header.php');
if(isset($_POST['submit']))
{
//check for the Last Name
if(empty($_POST['lastName'])) {
$lastName=FALSE;
$message .= '<p>You forget to enter Last Name</p>';
}
else {
$lastName=addslashes($_POST['lastName']);
}
//check for the first Name
if(empty($_POST['firstName'])) {
$firstName=FALSE;
$message .= '<p>You forget to enter the First Name</p>';
}
else {
$firstName=addslashes($_POST['firstName']);
}
//check for the Nick Name
if(empty($_POST['nickName'])) {
$nickName=FALSE;
$message .= '<p>You forget to enter the Nick Name</p>';
}
else {
$nickName=addslashes($_POST['nickName']);
}
//check for username
if(empty($_POST['username'])) {
$username=FALSE;
$message .= '<p>You forget to enter your Username</p>';
}
else {
$username=$_POST['username'];
}
//check for password
if(empty($_POST['password1'])) {
$password=FALSE;
$message .= '<p>You forget to enter your Password</p>';
}
else {
if($_POST['password1'] == $_POST['password2'])
{
$password= $_POST['password1'];
}
else {
$password= FALSE;
$message .= '<p>Your Password did not match with the confirm pasword</p>';
}
}
$active=addslashes($_POST['active']);
//check for the Name Prefix
if(empty($_POST['namePrefix'])) {
$namePrefix=FALSE;
$message .= '<p>You forget to enter the Name Prefix</p>';
}
else {
$namePrefix=addslashes($_POST['namePrefix']);
}
//check for the Name Suffix
if(empty($_POST['nameSuffix'])) {
$nameSuffix=FALSE;
$message .= '<p>You forget to enter the Name Suffix</p>';
}
else {
$nameSuffix=addslashes($_POST['nameSuffix']);
}
//check for the riMember
if(empty($_POST['riMember'])) {
$riMember=FALSE;
$message .= '<p>You forget to enter the riMember</p>';
}
else {
$riMember=addslashes($_POST['riMember']);
}
//cheking the validity of date
if(checkdate($_POST['month'],$_POST['day'],$_POST['year']))
{
$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year'];
$ts = mktime(0,0,0,$month, $day, $year);
}else
{
$ts=FALSE;
$message .= "Invalid Date, please enter the date again";
}
//check for the Partner
if(empty($_POST['partner'])) {
$partner=FALSE;
$message .= '<p>You forget to enter the partner</p>';
}
else {
$partner=addslashes($_POST['partner']);
}
//check for the lastNamePartner
if(empty($_POST['lastNamePartner'])) {
$lastNamePartner=FALSE;
$message .= '<p>You forget to enter the partner last name</p>';
}
else {
$lastNamePartner=addslashes($_POST['lastNamePartner']);
}
//check for the firstNamePartner
if(empty($_POST['firstNamePartner'])) {
$firstNamePartner=FALSE;
$message .= '<p>You forget to enter the Partner First Name</p>';
}
else {
$firstNamePartner=addslashes($_POST['firstNamePartner']);
}
//check for the address
if(empty($_POST['addressDefault'])) {
$addressDefault=FALSE;
$message .= '<p>You forget to enter the address</p>';
}
else {
$addressDefault=addslashes($_POST['addressDefault']);
}
//check for the phone
if(empty($_POST['phoneDefault'])) {
$phoneDefault=FALSE;
$message .= '<p>You forget to enter the phone</p>';
}
else {
$phoneDefault=addslashes($_POST['phoneDefault']);
}
//check for the email
if(empty($_POST['emailDefault'])) {
$emailDefault=FALSE;
$message .= '<p>You forget to enter the Email</p>';
}
else {
$emailDefault=addslashes($_POST['emailDefault']);
}
//check for the classification
$classification=addslashes($_POST['classification']);
$company=addslashes($_POST['company']);
$position=addslashes($_POST['position']);
$PHF=addslashes($_POST['PHF']);
$PHS=addslashes($_POST['PHS']);
$Benefactor=addslashes($_POST['Benefactor']);
$Bequest=addslashes($_POST['Bequest']);
$MajorDonor=addslashes($_POST['MajorDonor']);
$title=addslashes($_POST['title']);
$query="insert into mmember VALUES (null, '$lastName' ,'$firstName','$nickName','$username', '$password', '$active', '$namePrefix', '$nameSuffix', '$riMember',$ts,$partner,'$lastNamePartner', '$firstNamePartner', '$addressDefault', '$phoneDefault', '$emailDefault', '$classification', '$company', '$position',$PHF,$PHS,$Benefactor,$Bequest,$MajorDonor,'$title')";
$result=mysql_query($query);
if($result)
{
echo '<p><font color="red">Member has been entered</font></p>';
} else
{
$message .= '<p>Member could not be entered due to system error</p>';
}
}
if (isset($message))
{
echo '<font color="red">' , $message, '</font>';
}
?>
<form method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
<p> </p>
<table width="80%" border="1" cellpadding="3" cellspacing="0" align="center">
<tr>
<td width="25%"><span class="style3">Last Name</span></td>
<td width="75%"><input name="lastName" type="text" id="lastName"></td>
</tr>
<tr>
<td><span class="style3">First Name </span></td>
<td><input name="firstName" type="text" id="firstName"></td>
</tr>
<tr>
<td><span class="style3">Nick Name </span></td>
<td><input name="nickName" type="text" id="nickName"></td>
</tr>
<tr>
<td><span class="style3">username</span></td>
<td><input name="username" type="text" id="username"></td>
</tr>
<tr>
<td><span class="style3">Enter Password</span></td>
<td><input name="password1" type="password" id="password1"></td>
</tr>
<tr>
<td><span class="style3">Confirm Password</span></td>
<td><input name="password2" type="password" id="password2"></td>
</tr>
<tr>
<td><span class="style3">Active</span></td>
<td><select name="active">
<option value="1" selected>Yes</option>
<option value="2">No</option>
</select></td>
</tr>
<tr>
<td><span class="style3">Name Prefix </span></td>
<td><input name="namePrefix" type="text" id="namePrefix"></td>
</tr>
<tr>
<td><span class="style3">Name Suffix </span></td>
<td><input name="nameSuffix" type="text" id="virtualSpeaker2"></td>
</tr>
<tr>
<td><span class="style3">ri Member </span></td>
<td><input name="riMember" type="text" id="riMember"></td>
</tr>
<tr>
<td><span class="style3">Join Date </span></td>
<td>Day
<input name="day" type="text" size="5" maxlength="2">
Month
<select name="month" size="1">
<option value="1" selected>January</option>
<option value="2">Feburary</option>
<option value="3">March</option>
<option value="4">April</option>
<option value="12">December</option>
</select>
Year
<select name="year">
<option value="1999" selected>1999</option>
<option value="2000">2000</option>
<option value="2001">2001</option>
<option value="2004">2004</option>
<option value="2005">2005</option>
</select></td>
</tr>
<tr>
<td class="style3">ri Join date </td>
<td> </td>
</tr>
<tr>
<td class="style3">Termination Date </td>
<td> </td>
</tr>
<tr>
<td class="style3">Partner</td>
<td><input name="partner" type="text" id="partner"></td>
</tr>
<tr>
<td class="style3">Partner Last Name</td>
<td><input name="lastNamePartner" type="text" id="lastNamePartner"></td>
</tr>
<tr>
<td class="style3">Partner First Name </td>
<td><input name="firstNamePartner" type="text" id="firstNamePartner"></td>
</tr>
<tr>
<td class="style3">Address Default </td>
<td><textarea name="addressDefault" id="addressDefault"></textarea></td>
</tr>
<tr>
<td class="style3">Phone Default </td>
<td><input name="phoneDefault" type="text" id="phoneDefault"></td>
</tr>
<tr>
<td class="style3">Email Default </td>
<td><input name="emailDefault" type="text" id="emailDefault"></td>
</tr>
<tr>
<td class="style3">Classification</td>
<td><input name="classification" type="text" id="classification"></td>
</tr>
<tr>
<td class="style3">Company</td>
<td><input name="company" type="text" id="company"></td>
</tr>
<tr>
<td class="style3">Position</td>
<td><input name="position" type="text" id="position"></td>
</tr>
<tr>
<td class="style3">PHF</td>
<td><input name="PHF" type="checkbox" id="PHF" value="1"></td>
</tr>
<tr>
<td class="style3">PHS</td>
<td><input name="PHS" type="checkbox" id="PHS" value="1"></td>
</tr>
<tr>
<td class="style3">Benefactor</td>
<td><input name="Benefactor" type="checkbox" id="Benefactor" value="1"></td>
</tr>
<tr>
<td class="style3">Bequest</td>
<td><input name="Bequest" type="checkbox" id="Bequest" value="1"></td>
</tr>
<tr>
<td class="style3">MajorDonor</td>
<td><input name="MajorDonor" type="checkbox" id="MajorDonor" value="1"></td>
</tr>
<tr>
<td class="style3">Title</td>
<td><input name="title" type="text" id="title"></td>
</tr>
<tr>
<td> </td>
<td><input name="submit" type="submit" id="submit" value="Insert Member"></td>
</tr>
</table>
</form>
<?php
include('includes/footer.php');
?>
