Postingan lainnya
Error ketika mau login
ketika di klik login akan muncul Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in F:\xammp\htdocs\toko\admin.php on line 21
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in F:\xammp\htdocs\toko\admin.php on line 24 gagal login
ini kodenya
<html>
<head>
<title>Halaman Login</title>
<link rel="stylesheet" type="text/css" href="css/styleadmin.css">
</head>
<body>
<div class="box-login">
<center>
<h2>Silahkan Login</h2><br><br><br><br><br>
</center>
<form action="" method="POST">
<input type="email" name="email" placeholder="Isi Email Anda" /><br>
<input type="password" name="pass" placeholder="Isi Password Anda" /><br>
<input type="submit" name="login" value="Login" />
</form>
<?php
if(isset($_POST['login'])){
include "koneksiadmin.php";
$cek_data = mysqli_query($conn, "SELECT * FROM user WHERE
email = '".$_POST['email']."' AND password = '".$_POST['pass']."'");
$data = mysqli_fetch_array($cek_data);
$level = $data['level'];
$nama = $data['nama_lengkap'];
if(mysqli_num_rows($cek_data) > 0){
session_start();
$_SESSION['nama'] = $nama;
if($level == 'admin'){
header('location:haladmin.php');
}elseif($level == 'umum'){
header('location:index.php');
}elseif($level == 'guru'){
header('location:guru.php');
}
}else{
echo 'gagal login';
}
}
?>
</div>
</body>
</html>
0
2 Jawaban:
coba cek dulu si variable cek data, apakah sqlnya sudah benar, apakah data $_POST email & pass nya sudah ada
0