<?php
require_once 'connect.php';
if (isset( $_POST['approved'] ))
{
$serial_id=$_POST['serial_id'];
$query = $conn->query("UPDATE registration set status='Approved' where serial_id='$serial_id'") or die(mysqli_error());

mysqli_query($conn,$query);

$que = $conn->query("select * from registration where serial_id='$serial_id'") or die(mysqli_error());
$fetch = $que->fetch_array();
$name = $fetch['name'];
$emailid = $fetch['emailid'];
$address = $fetch['address'];
$phone = $fetch['contact_no'];
$status = $fetch['status'];
$ip = getenv("REMOTE_ADDR") ;
$to = 'indianamateursportsfederation@gmail.com, '.$emailid.'';
$subject=$fetch['status'];
$reply="Thanks for Your Tour Enquiry, We will be in touch you soon";
$headers = 'From:'. $emailid . "\r\n" .
'Reply-To: ' . "\r\n" .
'X-Mailer: PHP/' . phpversion();
mail($to, $subject, "Hello $name your registration is $status There is a Confirmation Mail !\n\n User Name: $name\n\n Email Address: $emailid\n\n Address: $address \n\n Contact Number: $phone \n\n IP: $ip\n\n",$headers);

 //print "<meta http-equiv=\"refresh\"content=\"1; URL=https://incredibletaj.in/thanks.php\">";



echo "<script>alert(\"Status Update Successfully & Mail send to customer\")</script>";
echo "<script> window.location=\"reserve.php\"</script>";
}
if (isset( $_POST['discard'] ))
{
$serial_id=$_POST['serial_id'];
$query = $conn->query("UPDATE registration set status='Discard' where serial_id='$serial_id'") or die(mysqli_error());

mysqli_query($conn,$query);


$que = $conn->query("select * from registration where serial_id='$serial_id'") or die(mysqli_error());
$fetch = $que->fetch_array();
$name = $fetch['name'];
$emailid = $fetch['emailid'];
$address = $fetch['address'];
$contact_no = $fetch['contact_no'];
$status = $fetch['status'];
$ip = getenv("REMOTE_ADDR") ;
$to = 'indianamateursportsfederation@gmail.com, '.$emailid.'';
$subject=$fetch['status'];
$reply="Thanks for Your Registration, We will be in touch you soon";
$headers = 'From:'. $emailid . "\r\n" .
'Reply-To: ' . "\r\n" .
'X-Mailer: PHP/' . phpversion();
mail($to, $subject, "Hello $name your registration is $status There is a Confirmation Mail !\n\n User Name: $name\n\n Email Address: $emailid\n\n Address: $address \n\n Contact Number: $phone \n\n IP: $ip\n\n",$headers);



echo "<script>alert(\"Successfully Update Status\")</script>";
echo "<script> window.location=\"reserve.php\"</script>";
}


	
?>