error_reporting(E_ALL);
 ini_set('display_errors', 1);
    session_start();
    $db = mysqli_connect("localhost","root","ovlovw8","reparatie");
    if(isset($_POST['submit'])){

        $username = mysqli_real_escape_string($db,$_POST['username']);
        $password = mysqli_real_escape_string($db,$_POST['password']);

        $password = md5($password);
        $sql ="SELECT * FROM users WHERE username='$username' AND   password='$password'";
        $result = mysqli_query($db, $sql);

        if(mysqli_num_rows($result) == 1){
            $_SESSION['message'] = "je bent ingelogd";
            $_SESSION['username'] = $username;
            header("location: overzicht.php");
            }else{
                $_SESSION['message'] = "verkeerde inlog gegevens";
            }

    }

error_reporting(E_ALL);
ini_set('display_errors', 1);
    session_start();
    $db = mysqli_connect("localhost","root","ovlovw8","reparatie");
    if(isset($_POST['submit'])){

        $username = mysqli_real_escape_string($db,$_POST['username']);
        $password = mysqli_real_escape_string($db,$_POST['password']);

        $password = md5($password);
        $sql ="SELECT * FROM users WHERE username='$username' AND    password='$password'";
        $result = mysqli_query($db, $sql);

        if(mysqli_num_rows($result) == 1){
            switch ($role) {
   case '1':
 $_SESSION['message'] = "je bent ingelogd";
            $_SESSION['username'] = $username;
   $redirect = 'repairs.php';
  break;
 case '2':
$_SESSION['message'] = "je bent ingelogd";
            $_SESSION['username'] = $username;
 $redirect = 'lloverzicht.php';
break;
 case '3':
$_SESSION['message'] = "je bent ingelogd";
            $_SESSION['username'] = $username;
  $redirect = 'overzicht.php';
break;
}

header('Location: ' . $redirect);

}