-
Notifications
You must be signed in to change notification settings - Fork 0
/
delete.php
93 lines (79 loc) · 3.18 KB
/
delete.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
<?php
session_start();
$con = mysqli_connect("localhost","root","");
mysqli_select_db($con, "se");
//$new= isset($_POST["type"]);
//print $new;
$sql1="select * from booking where id=".$_REQUEST['id'].";";
$result1=mysqli_query($con,$sql1);
$row=mysqli_fetch_array($result1);
$sql = "delete from booking where id=".$_REQUEST['id'].";";
$result = mysqli_query($con, $sql);
if($result){
$_SESSION['msg']="Appointment Cancelled";
header('location:mprofile.php');
}
require_once "PHPMailerAutoload.php";
date_default_timezone_set( 'America/New_York' );
$mail = new PHPMailer;
$mail->isSMTP();
$mail->Host = "smtp.gmail.com";
$mail->SMTPAuth = true;
$mail->Username = "[email protected]";
$mail->Password = "Jimit1247";
$mail->SMTPSecure = "tls";
$mail->Port = 587;
$mail->From = "[email protected]";
$mail->FromName = "do-not-reply";
$mail->addAddress("[email protected]", "Jim");
$mail->isHTML(true);
$mail->Subject = "Important [Regarding Appointments]";
$full_name=$_COOKIE["user"];
$text_message="Regards,<br>Ualbany Health Care+<br>Phone: +1(518)442-5454 <br> Email: [email protected]";
$body_message="Your appointment has been cancelled which was scheduled on date";
$body_message .= " [ ".$row["Date"]." ] ";
$body_message .= " time ";
$body_message .= " [ ".$row["Timings"]." ] ";
$message = "<html><body>";
$message .= "<table width='100%' bgcolor='#e0e0e0' cellpadding='0' cellspacing='0' border='0'>";
$message .= "<tr><td>";
$message .= "<table align='center' width='100%' border='0' cellpadding='0' cellspacing='0' style='max-width:100%; background-color:#fff; font-family:Verdana, Geneva, sans-serif;'>";
$message .= "<thead>
<tr height='80'>
<th colspan='4' style='border-bottom:solid 1px #bdbdbd; font-family:Source Sans Pro, Arial, sans-serif;font-size: 30px;font-weight: 700;text-transform: uppercase; color:#c762cb;' >Ualbany Health Care+</th>
</tr>
</thead>";
$message .= "<tbody>
<tr align='center' height='50' style='font-family:Verdana, Geneva, sans-serif;'>
<td style='background-color: GREY; text-align:center;'></td>
</tr>
<tr>
<td colspan='4' style='padding:15px;'>
<p style='font-size:20px;'>Hi' ".$full_name.",</p>
<hr />
<p style='font-size:25px;'>".$body_message."</p>
<p style='font-size:15px; font-family:Verdana, Geneva, sans-serif;'>".$text_message.".</p>
</td>
</tr>
<tr height='80'>
<td colspan='4' align='center' style='background-color:#f5f5f5; border-top:dashed #00a2d1 2px; font-size:24px; '>
</td>
</tr>
</tbody>";
$message .= "</table>";
$message .= "</td></tr>";
$message .= "</table>";
$message .= "</body></html>";
$mail->Body = $message;
$mail->AltBody = "If you cant view the mail please contact us through email or phone.";
if(!$mail->send())
{
echo "Mailer Error: " . $mail->ErrorInfo;
}
else
{
header("Location:mprofile.php?err=Your appointment has been cancelled.You will receive an email soon regarding appointment details.");
}
//print $sql;
mysqli_close($con);
?>