Formularz Ksiega gosci 2

<?php
include ('connectDataBase.php');
 // działajacy formularz
$link = mysqli_connect($server, $user, $password ,'dbLOI2') or die ("Fout met verbinding");
     mysqli_select_db($link,'dbLOI2');
     $query = 'CREATE TABLE  IF NOT EXISTS gastenboek2 (
      id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
      imie VARCHAR(50) NOT NULL,
      text VARCHAR(450) NOT NULL,
      sport VARCHAR(30) NOT NULL,
      beofenaar BOOLEAN ,
      datum TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
      )';
$result = mysqli_query($link, $query);


  $thisfile = "051R4_fc.php";

  $name = $as_name = $boodschap = $as_boodschap = $sport = $as_sport = $beoefenaar = $datum = "";
 $reg_form =<<< EOG
   <form  method="post" action="$thisfile">
    imie:<br />
   <input name="imie" type="text" value="" size=40 /><br />
    Boodschap:<br />
   <textarea name="text" cols=40 rows=3 value=""></textarea><br />
    Sport:<br />
   <select name="sport"  value="">
    <option value="tennis">tennis</option>
    <option value="voetbal">voetbal</option>
    <option value="running">running</option>
    <option value="tafeltennis">tafeltennis</option>
    <option value="squash">squash</option>
    <option value="wielrennen">wielrennen</option>
    <option value="boksen">boksen</option>
</select></br>
    Beofenaar:<br />
    <input type="radio" name="beofenaar" value="1">Ja
<input type="radio" name="beofenaar" value="0">Nee</br>
     <input type="submit" value="Submit" name="submit"/>
   </form>
EOG;


if(!isset($_POST['submit'])){
   $msg = $reg_form;
}
elseif(isset($_POST['submit']) && $_POST['submit'] == 'Submit'){
   if(!isset($_POST['imie']) || $_POST['imie'] == ''){
      echo ('wpisz swoje imie.');
   }elseif(!isset($_POST['text']) || $_POST['text'] == ''){
      echo ('Wpisz swoja wiadomosc.');
   }
   elseif(!isset($_POST['sport']) || $_POST['sport'] == ''){
      echo ('Zaznacz Twoj sport.');
   }
   else{
      $link = mysqli_connect($server, $user, $password ,'dbLOI2')
      or die('Could not connect: ' . mysqli_error());
   $name = mysqli_real_escape_string($link, $_POST['imie']);
   $as_name = trim($name);
   $boodschap = mysqli_real_escape_string($link, $_POST['text']);
   $as_boodschap = trim($boodschap);
   $sport = mysqli_real_escape_string($link, $_POST['sport']);
   $as_sport = trim($sport);
$beoefenaar = filter_input(INPUT_POST, 'beoefenaar',
   FILTER_SANITIZE_NUMBER_INT);
   $datum = strtotime("now");
      $query = "INSERT INTO gastenboek2 (id,imie,text,sport,beoefenaar,datum)
                VALUES (NULL,'$as_name','$as_boodschap','$as_sport','$beoefenaar',NOW())";
                 $result = mysqli_query($link, $query);

   if(mysqli_affected_rows($link) == 1){
              echo ('Twoj wpis został dodany');
              $noform_var = 1;
           }else{
              error_log(mysqli_error($link));
              echo ('Cos poszło nie tak');
           }
 }header('Location:051R4_fc.php');
}


?>
 <!DOCTYPE html>
<html lang=nl>
<head>
  <meta charset=utf-8>
  <title>Księga Gosci formularz</title>
</head>

 <body>
 <H1>Ksiega Gosci</H1>
<?php echo $reg_form; ?>
 </body>
 </html>