-
Notifications
You must be signed in to change notification settings - Fork 0
/
StudentScore.php
23 lines (20 loc) · 987 Bytes
/
StudentScore.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
<?php include 'headercontent.php'; ?>
<fieldset id="submission">
<label>Scores</label>
<br /><br />
<table>
<tbody>
<?php
$sqlessayscore = "SELECT DISTINCT score, essay_title"
. " FROM essay_answer, essay, class_essay WHERE essay_answer.username = '$user'"
. " AND essay_answer.essay_id = essay.essay_id AND class_essay.essay_id = essay_answer.essay_id AND class_essay.essay_id = essay.essay_id ORDER BY answer_id DESC LIMIT 15";
$resultessayscore = $conn->query($sqlessayscore);
?>
<?php while ($rowessayscore = $resultessayscore->fetch_assoc()): ?>
<tr>
<td style="font-size: 11px; padding: 3px; border-bottom: 1px solid gray;">You got <?= $rowessayscore['score'] ?> point(s) in "<?= $rowessayscore['essay_title'] ?>"</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</fieldset>