Nog een vraag
Met inloggen gebeurt het volgende:
<!DOCTYPE html>
<html>
<head>
<title>Inloggen</title>
</head>
<body>
<center>
<br>
<h1>Inloggen</h1>
<br>
<div style= "background-color: grey; width: 1000px">
<br>
<br>
<form action =# method="POST">
<div>
<label>Gebruikersnaam</label>
<input type="text" name="username" required placeholder="Gebruikersnaam">
</div>
<br>
<br>
<div>
<label>Password</label>
<input type="password" name="password1" required placeholder="Wachtwoord">
</div>
<br>
<br>
<div>
<input type="submit" value="Login">
<button><a href = "Create_user_admin.php">Nog geen account?</a></button>
</div>
</form>
<br>
</div>
</center>
</body>
</html>
<?php
session_start();
$host = "localhost";
$user = "root";
$password ="usbw";
$db = "login";
$data = mysqli_connect($host, $user, $password, $db);
if($data==false)
{
die ("Connection error");
}
if($_SERVER ["REQUEST_METHOD"]=="POST")
{
$username = $_POST["username"];
$password = $_POST["password1"];
$sql = "SELECT * FROM user WHERE username = '".$username."' AND password1 = '".$password."'";
$result = mysqli_query($data,$sql);
if( $result = mysqli_query($data,$sql) )
{
$row = mysqli_fetch_array($result);
if( $row["usertype"]=="user" )
{
$_SESSION["username"] = $username;
header ("location:userhome.php");
}
elseif($row["usertype"]=="admin")
{
$_SESSION["username"] = $username;
header ("location:adminhome.php");
}
else
{
echo "username or password incorrect";
}
} else
{
echo "De query is niet gelukt: ".mysqli_error($data);
}
}
?>
met user en 1234 inloggen gaat wel, (dan kom je in he mainprogramma terecht) maar met admin en 1234 gaat niet (je zou dan dan in het admingedeelte terecht moeten komen). wat gaat hier weer mis??
