forked from FuseOrg/Feedie
-
-
Notifications
You must be signed in to change notification settings - Fork 2
/
done_check.php
31 lines (28 loc) · 1.11 KB
/
done_check.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
<?php
if( isset($_SESSION["st_username"]) AND isset($_SESSION["class"]) ){
include('db_config.php');
$flag = 0;
$counter = 0;
$sql = "SELECT te_username, sub_name, sub_code FROM teachersinfo WHERE class = '".$_SESSION["class"]."'";
$result = $conn->query($sql);
if($result->num_rows > 0) {
while($row = $result->fetch_assoc()){
$sql1 = "SELECT st_username FROM feeds WHERE st_username = '".$_SESSION["st_username"]."' AND sub_code = '".$row["sub_code"]."' AND class = '".$_SESSION["class"]."'";
$result1 = $conn->query($sql1);
if( $result1->num_rows > 0 ){
++$flag;
}
else{
$flag = 0;
}
++$counter;
}
}
if($flag == $counter){
$value = 1;
$sql = "UPDATE students SET done = '".$value."' WHERE st_username ='".$_SESSION["st_username"]."' AND class = '".$_SESSION["class"]."'";
$result = $conn->query($sql);
}
}
echo "<script>var myWindow = window.open('https://docs.google.com/forms/d/e/1FAIpQLSdTxHOw8H1stOIk7uhlQXlESA-97_iRa625wLDOYWiDgq5Z5Q/viewform');</script>";
?>