side3.php

<?php
if(isset($_POST["next"])) {
    /*$db = mysqli_connect("localhost", "root", "", "VM");
    if (!$db) {
        die("Feil i knytning til databasen!");
    } else {
        echo "knyttet til databse! <br>";
    }*/
    $db = new mysqli("localhost", "root", "", "VM");
    $db->set_charset("utf8");
    $fornavn = $_POST["firstname"];
    $etternavn = $_POST["surname"];
    $adresse = $_POST["adress"];
    $tlf = $_POST["telefonnr"];
    $bilett = $_POST["bilett"];
    $kategori = $_POST["kategori"];

    $sql = "INSERT INTO competitor(name,surname,nationality,excersize)";
    $sql .= "VALUES ('$fornavn','$etternavn','$nasjonalitet','$droppliste')";
    //$resultat = mysqli_query($db, $sql);
    $resultat = $db->query($sql);


    $sql = "SELECT * FROM competitor";
//$resultat = mysqli_query($db,$sql);
    if (!$resultat) {
        echo "FEIL! ", $db->error;
    }
    echo '<table>';

//while ($rad=mysqli_fetch_array($resultat,MYSQLI_ASSOC)) {
   for($i = 0 ; $i < $db->affected_rows; $i ++){
       $radObject = $db->fetch_object() ;
       echo '<tr>';
        /*echo '<td>'.$rad["name"].'</td>';
        echo '<td>'.$rad["surname"].'</td>';
        echo '<td>'.$rad["adress"].'</td>';
        echo '<td>'.$rad["phone"].'</td>';
        echo '<td>'.$rad["tickettype"].'</td>';
        echo '<td>'.$rad["excersize"].'</td>';*/
        echo '<td>' . $radObject->name . '</td>';
        echo '<td>' . $radObject->surname . '</td>';
        echo '<td>' . $radObject->adress . '</td>';
        echo '<td>' . $radObject->phone . '</td>';
        echo '<td>' . $radObject->tickettype . '</td>';
        echo '<td>' . $radObject->excersize . '</td>';
        echo '</tr>';
    }

    echo '<table>';

}

?>