grade.php

<!DOCTYPE html>
<!-- Made by Julia Tasa-->
<!--- Quiz's results (linked with quiz.html) --->

<link rel="stylesheet" type="text/css" href="style.css" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta charset="utf-8">

<html>
     <head>
        <title>Tulokset</title>
    </head>
    <body>
        <div id="page-wrap">
            <h1> Sinun tuloksesi</h1>
            <p> Katso, miten pärjäsit tietovisassa</p>


            <?php
                $answer1 = $_POST['question-1-answer'];
                $answer2 = $_POST['question-2-answer'];
                $answer3 = $_POST['question-3-answer'];
                $answer4 = $_POST['question-4-answer'];
                $answer5 = $_POST['question-5-answer'];

                $total = 0;

                if ($answer1 == "B") { $total++; }
                if ($answer2 == "C") { $total++; }
                if ($answer3 == "A") { $total++; }
                if ($answer4 == "D") { $total++; }
                if ($answer5 == "C") { $total++; }


                echo "<div id='results' style='color:red; font-size: 30px'  > $total / 5 oikein! </div>";

// Let's create a database
$servername = "127.0.0.1";
$username = "jukfu";
$password = "";
$dbname = "quiz";


$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$name = $_POST['pelaaja'];


$sql = "SELECT * FROM results WHERE name = '$name' ";
$result = $conn->query($sql);

if($results){
    $sql = "UPDATE results SET total='$total' WHERE name='$name'"; //database updating

    if ($conn->query($sql) === TRUE) {
        echo "Yhteys tietokantaan luotu!";
    } else {
        echo "Error updating record: " . $conn->error;
    }
}
else{
    //insert
    $sql = "INSERT INTO results (name, total)
    VALUES ('$name', '$total')";

    if ($conn->query($sql) === TRUE) {
        echo "<div id='results' style='color:red; font-size: 30px' > Katso sijoituksesi! </div>";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}

//results are ordered

                    $sql = "SELECT * FROM results ORDER BY total DESC";
                    $result = $conn->query($sql);

                    if ($result->num_rows > 0) {
                    echo "<table style='border: 3px solid green; '>";

                        while($row = $result->fetch_assoc()) {
                            echo "<tr>";
                            echo "<td style='border: 1px solid green; color:red; font-size: 30px' ;'>  " . $row["name"]. "</td> <td style='border: 1px solid green; color:red; font-size: 30px'> ". $row["total"]. " p. </td>";
                            echo "</tr>";
                        }
                        echo "</table>";
                    } else {
                        echo "0 results";
                    }


                    $conn->close();


                    ?>
            <div>               <h4> <form action = "quiz.html" method = "post">
                    <input type="submit" align= center size= 30 color= red value="Takaisin Quizziin" />
                </form></h4>

        </div>
    </body>
</html>