sql-quizzer/index.php at master · full-stack-web-developer-and-designer/sql-quizzer · GitHub

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
<?php
    include 'database.php';
?>
<?php session_start(); ?>
<?php
/*
* Get Total Questions
*/
$query = "SELECT * FROM questions";
// Get results
$results = $mysqli->query($query) or die($mysqli->error . __LINE__);
$total = $results->num_rows;
?>
<!DOCTYPE html>
<html lang="en">
<?php
    include 'head.php';
?>
<body>
    <header>
        <div class="container">
            <h1>SQL Quizzer</h1>
        </div>
    </header>
    <main>
        <div class="container">
            <h2>Test your SQL knowledge</h2>
            <p>This is a multiple choice quiz to test your knowledge of SQL</p>
            <ul>
                <li><strong>Number of Questions: </strong><?php echo $total; ?></li>
                <li><strong>Type: </strong>Multiple choice</li>
                <li><strong>Estimated Time: </strong><?php echo $total * .5; ?> minutes</li>
            </ul>
            <a href="question.php?n=1" class="start">Start Quiz</a>
            <a href="add.php" class="start">Add Question</a>
        </div>
    </main>
    <?php include 'footer.php' ?>
</body>
</html>