<?php 
error_reporting(0);
ini_set('display_errors', 1);

include("admin/config.php");

$postname = $_POST['postname'];
$postname2 = $_POST['postname2'];
$postname3 = $_POST['postname3'];
$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'];
$other_ability = $_POST['other_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'];
$email = $_POST['email'];
$date = date("Y/m/d");

$flag = $_REQUEST['flag'];
$id = $_POST['id'];

$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'];

$otheredu = $_POST['otheredu'];

$company_name1 = $_POST['company_name1'];
$typ_exp1 = $_POST['typ_exp1'];
$post1 = $_POST['post1'];
$duration1 = $_POST['duration1'];
$duration_type1 = $_POST['duration_type1'];

$company_name2 = $_POST['company_name2'];
$typ_exp2 = $_POST['typ_exp2'];
$post2 = $_POST['post2'];
$duration2 = $_POST['duration2'];
$duration_type2 = $_POST['duration_type2'];

$company_name3 = $_POST['company_name3'];
$typ_exp3 = $_POST['typ_exp3'];
$post3 = $_POST['post3'];
$duration3 = $_POST['duration3'];
$duration_type3 = $_POST['duration_type3'];

$ability_info = $_POST['ability_info'];

$sql = "INSERT INTO applications (
    appliaction_date, appjob_id, postname2, postname3, 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, otheredu, height, prev_exp,
    company_name1, typ_exp1, post1, duration1,
    company_name2, typ_exp2, post2, duration2,
    company_name3, typ_exp3, post3, duration3,
    other_ability, ability_info, driving_lic, gun_lic, salary_expe, shift_pre, own_gun,
    mobile, alt_mobile, email, adharcardno
) VALUES (
    '$date', '$postname', '$postname2', '$postname3', '$appointment_date', '$appointment_time', '$applicant_name', '$address_permanant',
    '$town', '$taluka', '$district', '$local_address', '$town_local', '$taluka_local', '$district_local', '$state_local', '$pincode_local',
    '$reference_by', '$gender', '$mstatus', '$birth_day', '$birth_month', '$birth_year', '$age', '$education', '$otheredu', '$height', '$prevexp',
    '$company_name1', '$typ_exp1', '$post1', '$duration1', 
    '$company_name2', '$typ_exp2', '$post2', '$duration2', 
    '$company_name3', '$typ_exp3', '$post3', '$duration3', 
    '$other_ability', '$ability_info', '$driving_lic', '$gun_lic', '$salary_expe', '$shift_pre', '$own_gun',
    '$mobile', '$alt_mobile', '$email', '$aadharcardno'
)";

if ($conn->query($sql) === TRUE) {
    header("Location: success.php");
    exit;
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}
?>