/
CountErrors.php
58 lines (49 loc) · 2.06 KB
/
CountErrors.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
<?php
require "db-login.php";
$userSection = $_POST['userSection'];
if($userSection=='study-e')
$userName="P1.userName LIKE 'ThesisE%' AND";
else if($userSection=='study-c')
$userName="P1.userName LIKE 'ThesisC%' AND";
else
$userName="";
$userProblemQ = $db->prepare("SELECT DISTINCT (userProblem) FROM OPEN_PROBLEM_ATTEMPT AS P1 WHERE $userName P1.userSection='$userSection'");
$userProblemQ->execute();
if ($myProbs = $userProblemQ->fetch()) {
do {
$curProb=$myProbs["userProblem"];
echo "<BR>Problem Name : '$curProb'<BR>";
$userProblem="P1.userProblem = '$curProb' AND";
$sql = $db->prepare("SELECT P1.userName,COUNT(*) FROM OPEN_PROBLEM_ATTEMPT AS P1,STEP_TRANSACTION AS P2 WHERE $userName $userProblem P1.userSection='$userSection' AND P1.clientID = P2.clientID AND P2.server LIKE '%\"mode\":\"incorrect\"%' GROUP BY P1.userName ORDER BY P1.startTime");
$sqlTot = $db->prepare("SELECT P1.userName,COUNT(*) FROM OPEN_PROBLEM_ATTEMPT AS P1,STEP_TRANSACTION AS P2 WHERE $userName $userProblem P1.userSection='$userSection' AND P1.clientID = P2.clientID GROUP BY(P1.userName) ORDER BY(P1.startTime)");
$sql->execute();
$sqlTot->execute();
$sum=0;
if ($myrow = $sqlTot->fetch()) {
echo "<table border=1>";
echo "<tr><th>User Name</th><th>Total Number of Entries</th></tr>";
do {
$user=$myrow["userName"];
$count=$myrow["COUNT(*)"];
$sum=$sum+$count;
echo "<tr><td align='center'>$user</td><td align='center'>$count</td></tr>";
} while ($myrow = $sqlTot->fetch());
echo "</table>";
echo "<BR>Total is $sum<BR>";
}
if ($myrow = $sql->fetch()) {
echo "<table border=1>";
echo "<tr><th>User Name</th><th>Number of Red Entries</th></tr>";
$sum=0;
do {
$user=$myrow["userName"];
$count=$myrow["COUNT(*)"];
$sum=$sum+$count;
echo "<tr><td align='center'>$user</td><td align='center'>$count</td></tr>";
} while ($myrow = $sql->fetch());
echo "</table>";
echo "<BR>Total is $sum<BR>";
}
} while($myProbs = $userProblemQ->fetch());
}
?>