-
Notifications
You must be signed in to change notification settings - Fork 2
/
EmployeInsert.php
39 lines (35 loc) · 1.39 KB
/
EmployeInsert.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php
$CompnayName=$_POST['txtName'];
$ContactPerson=$_POST['txtPerson'];
$Address=$_POST['txtAddress'];
$City=$_POST['txtCity'];
$Email=$_POST['txtEmail'];
$Mobile=$_POST['txtMobile'];
$Area=$_POST['txtAreaWork'];
$Status="Pending";
$UserName=$_POST['txtUserName'];
$Password=$_POST['txtPassword'];
$UserType="Employer";
$Question=$_POST['cmbQue'];
$Answer=$_POST['txtAnswer'];
// Establish Connection with MYSQL
$con = mysql_connect ("localhost","root");
// Select Database
mysql_select_db("job", $con);
// Specify the query to Insert Record
$sql = "insert into Employer_Reg(CompanyName,ContactPerson,Address,City,Email,Mobile,Area_Work,Status,UserName,Password,Question,Answer) values('".$CompnayName."','".$ContactPerson."','".$Address."','".$City."','".$Email."',".$Mobile.",'".$Area."','".$Status."','".$UserName."','".$Password."','".$Question."','".$Answer."')";
// execute query
mysql_query ($sql,$con);
// Close The Connection
mysql_close ($con);
echo '<script type="text/javascript">alert("Registration Completed Succesfully");window.location=\'index.php\';</script>';
?>
</body>
</html>