<?php
include('../helpers/init.php');
if(isset($_POST['homeQuery']))
{    
    $name = $_POST['name'];
    $phone = $_POST['phone'];
    $email = $_POST['email']; 
    $equery = $_POST['enquiry'];   
    $date = date("d-m-y");
	$sql = "insert into homequery(date,name,phone,email,query) values('$date','$name','$phone','$email','$equery')";
		if(query($sql)){
			header('Location:../../index.html?&result=success');
		}else{
			header('Location:../../../index.html?&result=failer');
		}
}

//----------- Create Action Ends Here --------------



if(isset($_GET['action']) && $_GET['action']=="deleteHquery")
{
	$id=$_GET['id']; 
	$error = "";
    
    $delete_record = "delete from homequery where id=$id";
    
    if(query($delete_record)){
			header("Location:../pages/home-query.php?result=success");
			}else{
				$error = error();
			header("Location:../pages/home-query.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 --------------
?>