<?php
require_once 'connect.php';
if (isset( $_POST['apply'] ))
{
$serial_id=$_POST['serial_id'];
$uresult=$_POST['uresult'];
$apply = $_POST['apply'];
$query = $conn->query("UPDATE registration set result='$uresult' where result='Not Decided' AND 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'];
$result = $fetch['result'];
$contact_no = $fetch['contact_no'];
$status = $fetch['status'];
$ip = getenv("REMOTE_ADDR") ;
$to = 'indianamateursportsfederation@gmail.com, '.$emailid.'';
$subject=$fetch['status'];
$reply="Your Certificate is uploaded";
$headers = 'From:'. $emailid . "\r\n" .
'Reply-To: ' . "\r\n" .
'X-Mailer: PHP/' . phpversion();
mail($to, $subject, "Hello $name your Certificate is online. Goto www.iasfindia.com/search-result.php and enter your serial id. !User Name: $name\n\n Email Address: $emailid\n\n Result: $result \n\n Phone: $contact_no \n\n IP: $ip\n\n",$headers);



echo "<script>alert(\"Successfully Update Status\")</script>";
echo "<script> window.location=\"update-result.php\"</script>";

}
if (isset( $_POST['not'] ))
{
$serial_id=$_POST['serial_id'];
$uresult1=$_POST['uresult1'];
$not = $_POST['not'];
$query = $conn->query("UPDATE registration set result='$uresult1' where (result='Gold' OR result = 'Silver' OR result = 'Bronze' OR result = 'Participate' OR result = 'Official' OR result = 'Coach') AND 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'];
$result = $fetch['result'];
$contact_no = $fetch['contact_no'];
$status = $fetch['status'];
$ip = getenv("REMOTE_ADDR") ;
$to = 'indianamateursportsfederation@gmail.com, '.$emailid.'';
$subject=$fetch['status'];
$reply="Your Certificate is Updated";
$headers = 'From:'. $emailid . "\r\n" .
'Reply-To: ' . "\r\n" .
'X-Mailer: PHP/' . phpversion();
mail($to, $subject, "Hello $name your Certificate is Update. Goto www.iasfindia.com/search-result.php and enter your serial id. !User Name: $name\n\n Email Address: $emailid\n\n Result: $result \n\n Phone: $contact_no \n\n IP: $ip\n\n",$headers);


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


	
?>