Postingan lainnya
Mysql_num_rows() expects parameter 1 to be resource, boolean give
Saya ingin melakukan login, saat melakukan login muncul pesan seperti berikut
<?php
include"config/conn.php";
$pass=md5($_POST['password']);
$passw=$_POST['password'];
$user=$_POST['username'];
$sql=mysql_query("select * from user where nama='$user' and pass='$pass'");
$count=mysql_num_rows($sql);
$rs=mysql_fetch_array($sql);
if($count>0){
session_start();
$_SESSION['idu']=$rs['idu'];
$_SESSION['nama']=$rs['nama'];
$_SESSION['level']=$rs['level'];
$_SESSION['idk']="";
$_SESSION['ortu']="";
$_SESSION['id']=$rs['id'];
header('location:media.php?module=home');
}else{
$mr=md5($_POST['password']);
$sqla=mysql_query("select * from siswa where nis='$user' and pass='$mr'");
$counta=mysql_num_rows($sqla);
$rsa=mysql_fetch_array($sqla);
if($counta>0){
session_start();
$_SESSION['idu']=$rsa['nis'];
$_SESSION['nama']=$rsa['nama'];
$_SESSION['level']="user";
$_SESSION['ortu']=$passw;
$_SESSION['idk']=$rsa['idk'];
$_SESSION['id']="";
header('location:media.php?module=home');
}else{
$gr=md5($_POST['password']);
$sqlz=mysql_query("select * from guru where nip='$user' and pass='$gr'");
$countz=mysql_num_rows($sqlz);
$rsz=mysql_fetch_array($sqlz);
if($countz>0){
session_start();
$_SESSION['idu']=$rsz['nip'];
$_SESSION['nama']=$rsz['nama'];
$_SESSION['idk']=$rsz['idk'];
$_SESSION['level']="guru";
$_SESSION['ortu']="";
$_SESSION['id']="";
header('location:media.php?module=home');
}else{
echo"<center><h2>username atau password anda salah.</h2><br>
<a href=index.php><b>Ulangi Lagi</b></a></center>";
}
}
}
?>
0
1 Jawaban:
Jawaban Terpilih
Hai @Mickwagey mysql_query butuh 2 parameter koneksi dan query/perintah <pre> $sql = mysql_query($koneksi, $query); </pre>lebih disarankan menggunakan mysqli. Semoga membantu ^^
1