Here's the form table and $variables;
Code: Select all
<form action='Register_Action.php' method='post' enctype="multipart/form-data" name='register'>
<table width='28%' border='0' align='center' cellpadding='0' cellspacing='0'>
<tr>
<td colspan='2'><div align='center'>
<p><font size='2' face='verdana'>WELCOME TO STAFFCAMS Registration FORM</font></p>
</div></td>
</tr>
<tr>
<td width='31%'> </td>
<td width='69%'> </td>
</tr>
<tr>
<td colspan='2'><hr></td>
</tr>
<tr>
<td height='26'><font size='2' face='verdana'>PF NO.</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='pfno'>
</font></td>
</tr>
<tr>
<td height='28'><font size='2' face='verdana'>LEDGER NO.</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='ledgerno'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>FIRST NAME</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='fname'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>OTHER NAMES</font><font size='2' face='verdana'></td>
<td><font size='2' face='verdana'>
<input type='text' name='oname'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>LAST NAME</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='lname'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>STATE OF ORIGIN</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='stateoforigin'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>LOCAL GOVERNMENT</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='soorigin'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>NATIONALITY</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='Nationality'>
</font></td>
</tr>
<tr>
<td height='26'><font size='2' face='verdana'>Email address</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='email'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>RESIDENTIAL ADDRESS</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='residentialadd' />
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>TELEPHONE NUMBER</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='residentialadd'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>DEPARTMENT</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='department' />
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>MARITAL STATUS</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='marital'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>SEX</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='sex'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>AMOUNT DEDUCTIBLE</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='amountd' />
</font></td>
</tr>
<tr>
<td> </td>
<td><font size='2' face='verdana'>
<input type='submit' name='Submit' value='Register'>
</font></td>
</tr>
<tr>
<td colspan='2'><hr></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
</form><div align='center'><font size='1' face='verdana'><a href='index.php'>Back to login page</a></font></div>
<td colspan='2'><div align='center'><font size='1' face='verdana'>TM</font></div></td>
Code: Select all
<?php
$link = mysql_connect("localhost", "root", "") or die("Could not connect");
$db = mysql_select_db("lasustaffcams", $link) or die("Could not select database");
$amountd=$_POST['amountd'];
$dpt=$_POST['department'];
$email=$_POST['email'];
$fname =$_POST['fname'];
$id=$POST['id'];
$ledgerno =$_POST['ledgerno'];
$lga =$_POST['lga'];
$lname=$_POST['lname'];
$Nationalty=$_POST['Nationalty'];
$oname=$_POST['oname'];
$pfno=$_POST['pfno'];
$residentialaddress=$_POST['pfno'];
$soorigin=$_POST['soorigin'];
$today= date("Ymd H:i:s");
$result = mysql_query("Insert into uaer_table(amountd,department,email,fname,ledgerno,lga,lname,nationalty,oname,pfno,residentialadd,soorigin) values('$amountd','$department','$email','$fname','$ledgerno','$lga','$nationalty','$oname',$pfno,$residentialadd,$soorigin)");
//$result_p_ticket= mysql_query("Insert into pawn_ticket(pawn_ticket_customer_number,pawn_ticket_ticket_number,pawn_ticket_ticket_check_digit,pawn_ticket_ticket_issue_date) values('$cust_no','$pawn_ticket_number','$check_digit_only','$today')");
if (!mysql_query($result))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con)
?>
<html>
<body>
</body>
</html>