Nevar pievienot vairāk kā 25 tēmas Tēmai ir jāsākas ar burtu vai ciparu, tā var saturēt domu zīmes ('-') un var būt līdz 35 simboliem gara.

76 rindas
3.1 KiB
PHP

<?php
include __DIR__ . "/../bits/navbar.php";
?>
<div class="container pt-4">
<div class="card-deck">
<div class="card text-light bg-primary">
<div class="card-body">
<h5 class="card-title">Questions</h5>
<h1><i class="fas fa-question-circle"></i> <?php echo $database->count("questions"); ?></h1>
</div>
</div>
<div class="card text-light bg-success">
<div class="card-body">
<h5 class="card-title">Responses</h5>
<h1><i class="fas fa-reply-all"></i> <?php echo $database->count("responses"); ?></h1>
</div>
</div>
</div>
<div class="table-responsive">
<table id="questions" class="table table-hover mt-4">
<thead>
<tr>
<th data-priority="0"></th>
<th data-priority="1"><i class="far fa-fw fa-question-circle d-none d-md-inline"></i> Question</th>
<th data-priority="2"><i class="fas fa-fw fa-link d-none d-md-inline"></i> Code</th>
<th data-priority="2"><i class="fas fa-fw fa-list d-none d-md-inline"></i> Answers</th>
<th data-priority="1"><i class="fas fa-fw fa-reply-all d-none d-md-inline"></i> Responses</th>
</tr>
</thead>
<tbody>
<?php
$table = $database->select("questions", ['qid', 'qtext', 'qcode']);
foreach ($table as $row) {
$answers = $database->count("answers", ['qid' => $row['qid']]);
$responses = $database->count("responses", ['qid' => $row['qid']]);
?>
<tr>
<td>
<a class="btn btn-sm btn-info" href="<?php echo "./q/" . $row['qcode']; ?>">
<i class="fas fa-chart-bar"></i> Results
</a>
</td>
<td>
<?php echo $row['qtext']; ?>
</td>
<td>
<?php echo $row['qcode']; ?>
</td>
<td>
<?php echo $answers; ?>
</td>
<td>
<?php echo $responses; ?>
</td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<tr>
<th data-priority="0"></th>
<th data-priority="1"><i class="far fa-fw fa-question-circle d-none d-md-inline"></i> Question</th>
<th data-priority="2"><i class="fas fa-fw fa-link d-none d-md-inline"></i> Code</th>
<th data-priority="2"><i class="fas fa-fw fa-list d-none d-md-inline"></i> Answers</th>
<th data-priority="1"><i class="fas fa-fw fa-reply-all d-none d-md-inline"></i> Responses</th>
</tfoot>
</table>
</div>
</div>