<?php
include('../helpers/init.php');
if(isset($_POST['bePartner']))
{    
    $name = $_POST['name'];
    $dob = $_POST['dob'];
    $phone = $_POST['phone'];
    $email = $_POST['email'];    
    $marital = $_POST['marital'];
    $gender = $_POST['gender'];
    $adress = $_POST['adress'];
    $employer = $_POST['employer'];
    $designation = $_POST['designation'];
    $qualification = $_POST['qualification'];
    $experience = $_POST['experience'];
    $keyskill = $_POST['keyskill']; 
    $description = $_POST['description'];   
    $date = date("d-m-y");
    
	$sql = "insert into partner(date,name,dob,phone,email,marital,gender,address,employer,designation,qualification,experience,keyskill,description) values('$date','$name','$dob','$phone','$email','$marital','$gender','$adress','$employer','$designation','$qualification','$experience','$keyskill','$description')";
		if(query($sql)){
			header('Location:../../become-partner.html?&result=success');
		}else{
			header('Location:../../../become-partner.html?&result=failer');
		}
}

//----------- Create Action Ends Here --------------



if(isset($_GET['action']) && $_GET['action']=="delRefer")
{
	$id=$_GET['id']; 
	$error = "";
    
    $delete_record = "delete from refertbl where id=$id";
    
    if(query($delete_record)){
			header("Location:../pages/referearn.php?result=success");
			}else{
				$error = error();
			header("Location:../pages/referearn.php?result=failer".$error);
			}

}

//----------- Homepage Query Delete Ends Here --------------
if(isset($_POST['contactQuery']))
{    
    $name = $_POST['name'];
    $phone = $_POST['phone'];
    $email = $_POST['email']; 
    $equery = $_POST['enquiry'];   
    $date = date("d-m-y");
	$sql = "insert into enquiry(date,name,phone,email,query) values('$date','$name','$phone','$email','$equery')";
		if(query($sql)){
			header('Location:../../contact-us.html?&result=success');
		}else{
			header('Location:../../contact-us.html?&result=failure');
		}
}

//----------- Create Action Ends Here --------------



if(isset($_GET['action']) && $_GET['action']=="deleteCquery")
{
	$id=$_GET['id'];  
	$error = "";
    
    $delete_record = "delete from enquiry where id=$id";
    
    if(query($delete_record)){
			header("Location:../pages/contact-query.php?result=success");
			}else{
				$error = error();
			header("Location:../pages/contact-query.php?result=failer".$error);
			}

}

//----------- Contact Query Delete Ends Here --------------
?>