????????????????????
??????????????????
ÿØÿà
 JFIF      ÿÛ C      


!"$"$ÿÛ C    
ÿÂ p 
" ÿÄ     
         ÿÄ             ÿÚ 
   ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   @  

adadasdasdasasdasdas


.....................................................................................................................................????????????????????
??????????????????
ÿØÿà
 JFIF      ÿÛ C      


!"$"$ÿÛ C    
ÿÂ p 
" ÿÄ     
         ÿÄ             ÿÚ 
   ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   @  

adadasdasdasasdasdas


.....................................................................................................................................<?php
   include('session.php');
?>

<!DOCTYPE html>
<html>
  
<head>
    <title>Insert Page page</title>
</head>
  
<body>
    <center>
        <?php
        $conn = mysqli_connect("localhost", "xceljsr_db", "xcel@123#$", "xceljsr_db");
          
        // Check connection
        if($conn === false){
            die("ERROR: Could not connect. " 
                . mysqli_connect_error());
        }

		use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;

require 'vendor/autoload.php';

        if (isset($_GET['id'])){

		// Store the value from get to a
		// local variable "course_id"
		$course_id=$_GET['id'];
		$email=$_GET['email'];

		// SQL query that sets the status
		// to 1 to indicate activation.
		$sql="UPDATE `registration` SET
			`status`=0 WHERE id='$course_id'";


		

$body = '<HTML>
<body>
<h4>Hello sir your acount is deactivated</h4>
</body>
</HTML>';

$mail = new PHPMailer(true);

try {
	$mail->SMTPDebug = 0;									
	$mail->isSMTP();											
	$mail->Host	 = 'smtp.gmail.com;';					
	$mail->SMTPAuth = true;							
	$mail->Username = 'homeshifting2222@gmail.com';				
	$mail->Password = 'qrahoeeuepsgiodq';						
	$mail->SMTPSecure = 'tls';							
	$mail->Port	 = 587;

	$mail->setFrom('homeshifting2222@gmail.com','CORRECTSATHI.COM');		
	$mail->addAddress($email);
	
	
	
	$mail->isHTML(true);								
	$mail->Subject = 'Your Account is Deactivated';
	$mail->Body = $body;
	
	if($mail->send())
	{
	echo '<script>alert("Sent Successfully..."); window.location.href="index.php"</script>';
	}
	else {
	echo '<script>alert("Mail Not Sent..."); window.location.href="index.php"</script>';
		}

} catch (Exception $e) {
	echo "Message could not be sent. Mailer Error: {$mail->ErrorInfo}";
}

  

		// Execute the query
		mysqli_query($conn,$sql);
	}
          
     
      header('location: registration.php');
       

    

        ?>

        
    </center>
</body>
  
</html>







