Viewing file:  approve.php (2.08 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include('conn.php');
$updateQuery = mysqli_query($con,"UPDATE count_appo SET count_approve = count_approve + 1 WHERE id = 1");
$email1 = $_GET['id'];
$approv = "Approved";
$update_query = mysqli_query($con,"UPDATE appointments SET status='$approv' WHERE email='$email1'");
?>
<?php
// Start session
session_start();
require_once('conn.php');
use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;
require_once '../Exception.php';
require_once '../PHPMailer.php';
require_once '../SMTP.php';
// Check connection
if (!$con) {
die("Connection failed: " . mysqli_connect_error());
}
$email = $_GET['id'];
$approv = "Approved";
$insert_query = mysqli_query ($con, "INSERT INTO appointments (status) VALUES ('$approv') WHERE email = '$email' ");
$name = $_POST['name'];
$password = $_POST['password'];
$messageFromForm = $_GET['message'];
$message = "Your Appointment Approved! پروسه تایین وقت شما تایید شد<br>" . $messageFromForm;
$message = nl2br($message);
$mail = new PHPMailer;
$mail->isSMTP();
$mail->Host = 'mail.katebhospital.af';
$mail->SMTPAuth = true;
$mail->Username = 'info@katebhospital.af';
$mail->Password = 'QVwmlXxqnsDV';
$mail->SMTPSecure = 'tls';
$mail->Port = 587;
$mail->setFrom('info@katebhospital.af', 'Kateb Hospital');
$mail->addAddress($email, $name);
$mail->Subject = 'Appointemt';
$mail->isHTML(true);
$mail->CharSet = 'UTF-8';
$mail->Encoding = 'base64';
$mail->Body = $message;
if (!$mail->send()) {
$error_message = "Failed to send email. Please try again later.";
} else {
echo '<script>alert("Message send Successfully");</script>';
echo "<script>window.location.href = 'appointments.php'</script>";
exit();
}
?>
|