Login script

<?php
$gebruikersnaam = "";
$wachtwoord = "";
    $conn = new mysqli('host', 'username', 'password', 'database_name');
 if(mysqli_connect_errno()){
 trigger_error('Connection problem: '.$conn->error);
 }

if($_SERVER["REQUEST_METHOD"] === POST){
    $gebruikersnaam = $_POST['gebruiker'];
    $wachtwoord = $_POST['wachtwoord'];


   $sql = "SELECT * FROM users WHERE username = '$gebruikersnaam' and password = '$wachtwoord'";
      $result = mysqli_query($conn,$sql);
      $row = mysqli_fetch_array($result,MYSQLI_ASSOC);
      $count = mysqli_num_rows($result);
	if($count == 1) {
		echo "Hoi $gebruikersnaam";
} else {
echo "gebruikersnaam of wachtwoord is incorrect";
}
}
}
?>