<?php
include('../helpers/init.php');
if(isset($_POST['refApply']))
{    
    $name = $_POST['name'];
    $phone = $_POST['phone'];
    $email = $_POST['email'];    
    $location = $_POST['location']; 
    $budget = $_POST['budget']; 
    $relation = $_POST['relation']; 
    $equery = $_POST['enquiry'];   
    $date = date("d-m-y");
	$sql = "insert into refertbl(date,name,phone,email,location,budget,relation,query) values('$date','$name','$phone','$email','$location','$budget','$relation','$equery')";
		if(query($sql)){
			header('Location:../../refer-earn.html?&result=success');
		}else{
			header('Location:../../../refer-earn.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 --------------
?>