Hi kesavahariprasad,
First create your MySql database with name emp and required table field and create a config.php file with configuration details and save it in same directory......and use the below code to insert your records.
require_once("config.php");
if(isset($_POST['submit'])){
{
$first_name=$_POST['first_name'];
$last_name=$_POST['last_name'];
$emp_code=$_POST['emp_code'];
$salary=$_POST['salary'];
$age=$_POST['age'];
$date_of_joining=$_POST['date_of_joining'];
$date_of_birth=$_POST['date_of_birth'];
$dept_id=$_POST['dept_id'];
$manager_id=$_POST['manager_id'];
mysql_query("INSERT INTO emp (first_name , last_name , emp_code , salary , age , date_of_joining , date_of_birth , dept_id , manager_id ) values('$first_name' , '$last_name' , '$emp_code' , '$salary' , '$age' , '$date_of_joining' ,'$date_of_birth' , '$dept_id' , '$manager_id')");
}
?>
<html>
<head>
<script language="javascript" type="text/javascript">
function validate()
{
var err="";
if(document.getElementById("first_name").value=="")
err = "* Your Message here!\n";
if(document.getElementById("last_name").value=="")
err = "* Your Message here!\n";
if(document.getElementById("emp_code").value=="")
err = "* Your Message here!\n";
if(document.getElementById("salary").value=="")
err = "* Your Message here!\n";
if(document.getElementById("age").value=="")
err = "* Your Message here!\n";
if(document.getElementById("date_of_joining").value=="")
err = "* Your Message here!\n";
if(document.getElementById("date_of_birth").value=="")
err = "* Your Message here!\n";
if(document.getElementById("dept_id").value=="")
err = "* Your Message here!\n";
if(document.getElementById("manager_id").value=="")
err = "* Your Message here!\n";
if(err=="")
return true;
else {
alert("Error: \n"+err);
return false;
}
}
</script>
</head>
<body>
<form name="addemp" method="post" action="" onsubmit="return validate()">
<center>
<h1>
EMPLOYEE FORM</h1>
<table>
<tr>
<td align="left" style="width: 150px">
First name
</td>
<td align="left">
<input type="text" name="first_name" id="first_name">
</td>
</tr>
<tr>
<td align="left">
Last name
</td>
<td align="left">
<input type="text" name="last_name" id="last_name">
</td>
</tr>
<tr>
<td align="left">
Employee code
</td>
<td align="left">
<input type="text" name="emp_code" id="emp_code">
</td>
</tr>
<tr>
<td align="left">
Salary
</td>
<td align="left">
<input type="text" name="salary" id="salary">
</td>
</tr>
<tr>
<td align="left">
Age
</td>
<td align="left">
<input type="text" name="age" id="age">
</td>
</tr>
<tr>
<td align="left">
Date of joining
</td>
<td align="left">
<input type="text" name="date_of_joining" id="date_of_joining">
</td>
</tr>
<tr>
<td align="left">
Date of birth
</td>
<td align="left">
<input type="text" name="date_of_birth" id="date_of_birth">
</td>
</tr>
<tr>
<td align="left">
Department id
</td>
<td align="left">
<input type="text" name="dept_id" id="dept_id">
</td>
</tr>
<tr>
<td align="left">
Manager id
</td>
<td align="left">
<input type="text" name="manager_id" id="manager_id">
</td>
</tr>
<tr>
<td align="left">
<label for="file">
Attach ur bioa data:</label>
</td>
<td align="left">
<input type="file" name="file" id="file" onclick="return file_onclick()" />
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="add" value="ADD" />
</td>
</tr>
</table>
</center>
</form>
</body>
</html>