forked from vipinkhushu/Xunbao
-
Notifications
You must be signed in to change notification settings - Fork 0
/
checkAnswer.php
97 lines (70 loc) · 1.82 KB
/
checkAnswer.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
<?php
session_start();
include('login/credentials.php');
$conn=new mysqli ($DB_SERVER , $DB_USERNAME ,$DB_PASSWORD , $DB_DATABASE);
if($conn->connect_error)
{
die("connection failed: ".$conn->connect_error);
}
$secureans=mysqli_real_escape_string($conn,stripslashes($_POST['answer']));
$ans=strtolower($secureans);
$sql="SELECT `level` FROM `users` WHERE `email`='$_SESSION[user_check]'";
$result= $conn->query($sql);
if($result->num_rows > 0)
{
while($row= $result->fetch_assoc())
{
$level=$row['level'];
break;
}
}
$sql="INSERT INTO `submissions` (`level` , `user` ,`answer`,`time_stamp`) VALUES ('$level' ,'$_SESSION[user_check]', '$ans',now())";
$conn->query($sql);
$a=0;
$level++;
$sql="SELECT `answer` FROM `question` WHERE `level`='$level'";
$result= $conn->query($sql);
if($result->num_rows > 0)
{
while($row= $result->fetch_assoc())
{
if($ans==$row['answer'])
{
$a=1;
}
break;
}
}
if($a==1)
{
$sql = "UPDATE `users` SET `level`='$level',`lastSubmission`=now() WHERE email='$_SESSION[user_check]'";
if ($conn->query($sql) === TRUE) {
//echo "Record updated successfully";
header('location: home.php');
} else {
//echo "Error updating record: " . $conn->error;
header('location: index.php');
}
$conn->close();
}
else if($level==6){
if($ans==$_SESSION["user_check"]){
$sql = "UPDATE `users` SET `level`='$level',`lastSubmission`=now() WHERE email='$_SESSION[user_check]'";
if ($conn->query($sql) === TRUE) {
//echo "Record updated successfully";
header('location: home.php');
} else {
//echo "Error updating record: " . $conn->error;
header('location: index.php');
}
$conn->close();
}else{
header('location: home.php?answer=0');
}
}
else
{
header('location: home.php?answer=0');
//echo $level;
}
?>