Postingan lainnya
Error mysqli_num_rows()
Solusinya gan, Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\login\login.php on line 13
<?php
session_start();
$pesan="";
if (isset($_POST['btlogin'])) {
$email = $_POST['email'];
$pass = $_POST['pass'];
$pass_enc = md5($pass);
include_once("koneksi.php");
$cek = "SELECT * FROM tb_user WHERE email='$email' AND password='$pass_enc'";
$nilai = mysqli_query($con,$cek);
$login = mysqli_num_rows($nilai);
if ($login > 0) {
$ambil = "SELECT * FROM tb_user WHERE email='$email'";
$ambil_eks = mysqli_query($con,$ambil);
$data = mysqli_fetch_array($ambil_eks);
$uid = $data['id_user'];
$nm = $data['nm_user'];
$tglahir = $data['tgl_lahir'];
$jk = $data['jsn_kelamin'];
$lvl = $data['level'];
$_SESSION['$sesuid'] = $uid;
$_SESSION['$sesnama'] = $nm;
$_SESSION['$seslahir'] = $tglahir;
$_SESSION['$sesjk'] = $jk;
$_SESSION['seslevel'] = $lvl;
$_SESSION['$sesemail'] = $email;
header("location:index.php");
}
elseif($login == 0){
$pesan = '<div class="pesan">Login Gagal</div>';
}
}
?>
9 Jawaban:
Biasanya ada error di eksekusi query nya mas, coba di die query atau instruksi sebelumnya dan analisa salahnya dimana.
udh saya cek mas belum dapat dimana letak kesalahannya:( Padahal udh coba ganti varialbe querynya tapi masih juga gak bisa. mohon bantuannya
Koding lengkap nya di post gan biar tau dimana errornya.. di line 13 masalah tuh..
kayaknya sih variable nilai itu isinya true / false deh bukan berbentuk array atau objek array
coba cek dulu apa isi dari variable nilai..
jika isinya bukan data yang dimaksud maka cek query nya . coba jalan kan misal di phpmyadmin atau database manager dan semacam nya
Ini mas syntaxnya. Mohon bantuannya
<?php
session_start();
$pesan="";
if (isset($_POST['btlogin'])) {
$email = $_POST['email'];
$pass = $_POST['pass'];
$pass_enc = md5($pass);
include_once("koneksi.php");
$cek = "SELECT * FROM tb_user WHERE email='$email' AND password='$pass_enc'";
$nilai = mysqli_query($con,$cek);
$login = mysqli_num_rows($nilai);
if ($login > 0) {
$ambil = "SELECT * FROM tb_user WHERE email='$email'";
$ambil_eks = mysqli_query($con,$ambil);
$data = mysqli_fetch_array($ambil_eks);
$uid = $data['id_user'];
$nm = $data['nm_user'];
$tglahir = $data['tgl_lahir'];
$jk = $data['jsn_kelamin'];
$lvl = $data['level'];
$_SESSION['$sesuid'] = $uid;
$_SESSION['$sesnama'] = $nm;
$_SESSION['$seslahir'] = $tglahir;
$_SESSION['$sesjk'] = $jk;
$_SESSION['seslevel'] = $lvl;
$_SESSION['$sesemail'] = $email;
header("location:index.php");
}
elseif($login == 0){
$pesan = '<div class="pesan">Login Gagal</div>';
}
}
?>
"$nilai = mysqli_query($con,$cek);"
nilai dari variabel $con nya apa?
query pertama :
SELECT * FROM tb_user WHERE email='$email' AND password='$pass_enc'
ganti jadi
SELECT * FROM `tb_user `WHERE `email`='$email' AND `password`='$pass_enc'
query kedua :
SELECT * FROM tb_user WHERE email='$email'
ganti jadi
SELECT * FROM `tb_user` WHERE `email`='$email'