Untitled

<?php
   if(isset($_GET["terning"])){
       $terning = $_GET["terning"];
   }else{
       $terning = 1;
   }

?>
<?php
   $system_info = "";

   $server   = "localhost";
   $username = "root";
   $password = "";
   $database = "jul";

   $conn = mysqli_connect($server, $username, $password, $database);
           mysqli_set_charset($conn, "utf8");
   if (!$conn){die();}

   //SQL for Tabell
   $sqlAll = "SELECT * FROM brus";
   if(isset($terning) )
   {
       $sqlAll = "SELECT * FROM brus WHERE terningkast >= $terning";
   }
   $resultAll = mysqli_query($conn, $sqlAll);
   //SQL for input
   if (isset( $_POST["velg"] ) &&  $_POST["velg"] == "insert")
   {
       $content = $_POST["id"];

       $sqlID = "INSERT INTO stemme (brus, timestamp) values (" . $content . ", now());";
       $result = mysqli_query($conn, $sqlID);

       if ($result){
           $id = mysqli_insert_id( $conn );
           $system_info = $system_info . "Good insert on ID = " . $id . ",";
       }
   }
   //SQL for clear
   if (isset( $_POST["clear"] ) &&  $_POST["clear"] == "clearVotes")
   {
       $sqlClear = "DELETE FROM stemme";
       $resultClear = mysqli_query($conn, $sqlClear);

       if ($resultClear){
           $idClear = mysqli_insert_id( $conn );
           $system_info = $system_info . " Cleared all votes, ";
       }
   }
   //SQL for Stemmer
   #$sqlStemmer = "SELECT * FROM brus, stemme WHERE stemme.brus = brus.id;";
   $sqlStemmer = "SELECT brus.id as \"id\", navn, count(brus) as \"stemmer\", bilde FROM brus, stemme where stemme.brus = brus.id group by brus order by stemmer desc limit 1;";
   $resultStemmer = mysqli_query($conn, $sqlStemmer);

   if ($resultStemmer){
       $idStemmer = mysqli_insert_id( $conn );
       $system_info = $system_info . " Votes dispalyed, ";
   }


?>


<!DOCTYPE html>
<html>
 <head>
   <meta charset="UTF-8">
   <title>JulebrusKonkurranse</title>
 </head>
 <body>

   <p>Stem på Julebrusen du liker best! <br>
   <em style="font-size: 75% ">Tast inn id til din favorittbrus</em></p>

   <form action ="index.php" method="post">
       <input type="text" id="inputText" name="id">
       <input type="hidden" name="velg" value ="insert">
       <input type="submit" value="Velg">
   </form>
   <form action ="index.php" method="post">
       <input type="hidden" name="clear" value ="clearVotes">
       <input type="submit" value="Slett stemmer">
   </form>

   <?php
       if(mysqli_num_rows($resultStemmer) > 0){
           echo "<p> <strong>Årets julebrus er: </strong>";
           while($row = mysqli_fetch_assoc($resultStemmer)){
              echo "Julebrusen til " . $row["navn"] . ", med " .$row["stemmer"]. " stemmer. <br>" . "<img src=\"" . $row["bilde"] . "\" alt=\"julebrusbilde\" height=\"100\"  >" . "<br>";
           }
           echo "</p>";
       }
   ?>


   <?php echo $system_info; ?>


   <?php
       if(mysqli_num_rows($resultAll) > 0)
       {
           echo "<table border=\"1\"  style=\"width:500px\">";
               echo "<tr>";
                   echo "<th>ID</th>";
                   echo "<th>Navn</th>";
                   echo "<th>Bilde</th>";
                   echo "<th>Terningkast</th>";
               echo "</tr>";

           while($row = mysqli_fetch_assoc($resultAll))
           {
               echo "<tr>";
                   echo "<td style=\"text-align: center\"><strong>" . $row["id"] . "</strong></td>";
                   echo "<td>" . $row["navn"] . "</td>";
                   echo "<td style=\"text-align: center\">" . "<img src=\"" . $row["bilde"] . "\" alt=\"julebrusbilde\" height=\"100\"  >"."</td>";
                   echo "<td style=\"text-align: center\">" . "<img src=\"./media/diceface_".$row["terningkast"].".png\" alt=\"Terningkast: " . $row["terningkast"] . " \" height=\"50\" >" . "</td>";
               echo "</tr>";
           }

           echo "</table>";
       }
   ?>

 </body>
 <footer>
       <br><?php echo "$system_info"; ?>
 </footer>
</html>

<?php
mysqli_close($conn);

?>