-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathnotifyhw.php
108 lines (85 loc) · 2.69 KB
/
notifyhw.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
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
<?php
require 'Exception.php';
require 'PHPMailer.php';
require 'SMTP.php';
use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;
use PHPMailer\PHPMailer\SMTP;
session_start();
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "classroom";
$coursecode = $_POST['coursecode'];
$courseName = $_POST['courseName'];
$assignment_id = $_POST['assignment_id'];
$email=$_SESSION['email'];
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM professors WHERE email='$email'";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$fname = $row['firstname'];
$lname = $row['lastname'];
$sql = "SELECT * from postassignment where assignment_id = '$assignment_id' ";
$result = $conn->query($sql);
$task="";
$deadline="";
$assigneddate="";
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$task = $row["task"];
$deadline = $row["deadline"];
$assigneddate = $row["postedtime"];
}
}
$recMail = [];
$c=0;
$sql = "SELECT student_email from studentcourses where studentcourses.coursecode = '$coursecode' ";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
array_push($recMail, $row["student_email"]);
$c=1;
}
}
foreach ($recMail as $var) {
$mail = new PHPMailer(true);
$recp = $var;
try {
$mail->isSMTP();
$mail->Host = 'smtp.gmail.com';
$mail->SMTPAuth = true;
$mail->Username = 'seventhsanctum22@gmail.com';
$mail->SMTPSecure = PHPMailer::ENCRYPTION_SMTPS;
$mail->Port = 465;
//Recipients
$mail->setFrom('from@example.com', $fname." ".$lname);
$mail->addAddress($recp);
$message = "<body '>
<div class='message'>
<h3>Dear Student ,<br> Gentle Reminder for <br> $courseName Assignment<br><br> Posted on : $assigneddate <br>Deadline : $deadline .<br><br>
Please submit it soon if not yet submitted.
</div>
</body>
";
$mail->isHTML(true);
$mail->Subject = 'Reminder for '.$courseName.' Assignment Submission';
$mail->Body = $message;
$mail->AltBody = 'Contact admin ';
$mail->send();
$c++;
} catch (Exception $e) {
echo "Message could not be sent. Mailer Error: {$mail->ErrorInfo}";
}
}
if ($c > 0) {
echo '
<script>
alert("Reminder for Assignment Submission is sent successfully")
window.location = "Assignment.php";
</script>
';
}