<?php 
error_reporting(0);
include("config.php");

$appointed=$_POST['appointed'];
$appointment_date=$_POST['appointment_date'];
$appointment_time=$_POST['appointment_time'];
$applicant_name=$_POST['applicant_name'];
$address_permanant=$_POST['address_permanant'];

$town=$_POST['town'];
$taluka=$_POST['taluka'];
$district=$_POST['district'];
$local_address=$_POST['local_address'];
$reference_by=$_POST['reference_by'];
$gender=$_POST['gender'];
$mstatus=$_POST['mstatus'];
$birth_day=$_POST['birth_day'];
$birth_month=$_POST['birth_month'];
$birth_year=$_POST['birth_year'];
$age=$_POST['age'];
$education=$_POST['education'];
$height=$_POST['height'];
$prevexp=$_POST['prevexp'];
$typ_exp=$_POST['typ_exp'];
$exp_where=$_POST['exp_where'];
$orther_ability=$_POST['orther_ability'];
$driving_lic=$_POST['driving_lic'];
$gun_lic=$_POST['gun_lic'];
$own_gun=$_POST['own_gun'];
$shift_pre=$_POST['shift_pre'];
$salary_expe=$_POST['salary_expe'];
$mobile=$_POST['mobile'];
$alt_mobile=$_POST['alt_mobile'];
$aadharcardno=$_POST['aadharcardno'];
$jobid=$_POST['jobid'];
//echo $jobid; exit;
$email=$_POST['email'];
$date =date("Y/m/d");

$town_local=$_POST['town_local'];
$taluka_local=$_POST['taluka_local'];
$district_local=$_POST['district_local'];
$state_local=$_POST['state_local'];
$pincode_local=$_POST['pincode_local'];

$flag = $_REQUEST[flag];
$id= $_POST[id];
$tdate = date("Y/m/d");		
		
		$sql = "INSERT INTO applications (appliaction_date, appjob_id, appointed, appoint_date, appointment_time,applicant_name,address_permanant,town,taluka,distrtict,
		address_local,town_local,taluka_local,district_local,state_local,pincode_local,
		 refrence,gender,mstatus,birth_day,birth_month,birth_year,age,education,height,prev_exp,typ_exp,exp_where,other_ability,driving_lic,gun_lic,salary_expe,shift_pre,own_gun,
		 mobile,alt_mobile,email,adharcardno)
			VALUES('$date','$jobid','$appointed','$appointment_date','$appointment_time','$applicant_name','$address_permanant','$town','$taluka','$district','$local_address',
			'$reference_by','$gender','$mstatus','$birth_day','$birth_month','$birth_year','$age','$education','$height','$prevexp','$typ_exp','$exp_where','$orther_ability','$driving_lic','$gun_lic','$salary_expe','$shift_pre','$own_gun',
			'$mobile','$alt_mobile','$email','$aadharcardno')";
			
			
             $conn->query($sql);

			  /*$id = mysqli_insert_id($conn); 
		if($_FILES["resume_path"]["name"]!="") 
		{
				 
			 $fileload = $_FILES["resume_path"]["name"];
			  $file_ext = explode(".",$fileload);
			 $myattach="resume_".$id.".".$file_ext[1];
			 $destpath="admin/".$uploadpath.$myattach;
			$file1 = move_uploaded_file($_FILES["resume_path"]["tmp_name"],$destpath); 
			$updatecategory=sprintf("UPDATE applications SET resume_path ='%s' WHERE id ='%d'", $myattach, $id); 
			$conn->query($updatecategory);
		}	*/	
			 
			 header("Location:success.php");
		exit;

?>