· 8 years ago · Sep 29, 2017, 11:20 AM
1<?php
2$db_host = 'localhost'; // Server Name
3$db_user = 'root'; // Username
4$db_pass = ''; // Password
5$db_name = 'kot'; // Database Name
6
7$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
8if (!$conn) {
9 die('Failed to connect to MySQL: ' . mysqli_connect_error());
10}
11
12$sql = 'SELECT *
13 FROM questions';
14
15$query = mysqli_query($conn, $sql);
16
17if (!$query) {
18 die('SQL Error: ' . mysqli_error($conn));
19}
20?>
21
22<!DOCTYPE html>
23<html>
24 <head>
25 <meta name="viewport" content="width=device-width, initial-scale=1">
26 <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
27 <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script>
28 <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
29 <script type="text/javascript">
30 function timeout()
31 {
32 var hours = Math.floor(timeLeft / 3600);
33 var minute = Math.floor((timeLeft - (hours * 60 * 60) - 30) / 60);
34 var second = timeLeft % 60;
35 var hrs = checktime(hours);
36 var mint = checktime(minute);
37 var sec = checktime(second);
38 if (timeLeft <= 0)
39 {
40 clearTimeout(tm);
41 document.getElementById("form1").submit();
42 }
43 else
44 {
45
46 `document.getElementById("time").innerHTML=hrs+":"+mint+":"+sec;
47 }
48 timeLeft--;
49 var tm= setTimeout(function(){timeout()},1000);
50 }
51 function checktime(msg)
52 {
53 if(msg<10)
54 {
55 msg="0"+msg;
56 }
57 return msg;
58 }
59 </script>
60
61 </head>
62 <body onload="timeout()" >
63
64 <div class="container">
65 <div class="col-sm-2"></div>
66 <div class="col-sm-8">
67 <h2>WELCOME FOR DEMO
68 <script type="text/javascript">
69 var timeLeft=3*60*60;
70
71 </script>
72
73 <div id="time"style="float:right">timeout</div></h2>
74 <form method="post" id="form1" action="answer.php">
75 <table class="data-table">
76
77 <div class="list-group">
78
79 <?php
80 $no = 1;
81
82 while ($row = mysqli_fetch_array($query)) {
83 $amount = $row['amount'] == 0 ? '' : number_format($row['amount']);
84 <?php $ans_array = array($row->ans1, $row->ans2, $row->ans3, $row->ans4);
85 shuffle(ans_array);
86 ?>
87 echo '<tr>
88
89 <tR><td><span class=style2>'.$no.'. '.$row['question'].'</td></tr>
90 <tr><td a= href"#" class=list-group-item><input type=radio name='.$no.' value=1>'.$row['ans1'].'</td></tr>
91 <tr><td a= href"#" class=list-group-item><input type=radio name='.$no.' value=2>'.$row['ans2'].'</td></tr>
92 <tr><td a= href"#" class=list-group-item><input type=radio name='.$no.' value=3>'.$row['ans3'].'</td></tr>
93 <tr><td a= href"#" class=list-group-item><input type=radio name='.$no.' value=4>'.$row['ans4'].'</td>
94 </tr>';
95 $no++;
96
97
98
99
100
101
102 }
103
104 ?>
105
106
107
108
109
110 </div>
111
112 </table>
113
114
115
116 <center><input type="submit" value="submit Quiz" class="btn btn-success" /></center>
117 <?php
118 $value = mysql_real_escape_string($_POST['submit']);
119 $sql = ("insert into mst_useranswer(sess_id, test_id, que_des, ans1,ans2,ans3,ans4,true_ans,your_ans) values ('" . session_id() . "', $tid,'$row[2]','$row[3]','$row[4]','$row[5]', '$row[6]','$row[7]','$ans')") or die(mysql_error());
120 ?>
121 </form>
122 </div>
123 <div class="col-sm-2"></div>
124 </div>
125
126 </body>
127</html>
128
129CREATE TABLE IF NOT EXISTS `mst_useranswer` (
130`sess_id` varchar(80) DEFAULT NULL,
131`test_id` int(11) DEFAULT NULL,
132`que_des` varchar(200) DEFAULT NULL,
133`ans1` varchar(50) DEFAULT NULL,
134`ans2` varchar(50) DEFAULT NULL,
135`ans3` varchar(50) DEFAULT NULL,
136`ans4` varchar(50) DEFAULT NULL,
137`true_ans` int(11) DEFAULT NULL,
138`your_ans` int(11) DEFAULT NULL
139) ENGINE = InnoDB DEFAULT CHARSET = latin1;