| para master saya mau tanya kenapa pas login saya muncul error ky gini yah mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\bakery\auth.php on line 10 saya pake xampp versi 1.7.3 sedangkan di versi 1.7.0 lancar |
|
| coba liat kode auth.php nya dong.. |
|
| <?php session_start(); include("config/config.php"); $user_name=$_POST['user_name']; $pass=md5($_POST['password']); $today=date('Ymd'); $sql=mysql_query("SELECT * FROM user WHERE username='$user_name'"); $result=mysql_query($sql); $hasil=mysql_num_rows($result); if($hasil>0) { $row=mysql_fetch_array($result); if($row['password']==$pass) { $_SESSION['user']=$user_name; $_SESSION['auth']=$row['hak']; header("location:home.php"); } else { header("location:index.php"); } } else { header("location:index.php"); } ?> |
|
| sepertinya salah di query mysql nya gan. coba tambahkan die(mysql_error()); di ujung nya query sql.. supaya keliatan detail kesalahannya gan. |
|
| coba tambahin, $sql=mysql_query("SELECT * FROM user WHERE username='$user_name'")or die(mysql_error()); |
|
| hasilnya mysql_fetch_array() expects parameter 1 to be resource, null given in |
|
| coba cek nama tabel dan nama kolom di databasenya, apakah sudah sesuai atau belum |
|
| bisa liat struktur table usernya... |
|
| id int(11) (NULL) NO PRI (NULL) auto_increment select,insert,update,references username varchar(20) latin1_swedish_ci NO (NULL) select,insert,update,references password varchar(32) latin1_swedish_ci NO (NULL) select,insert,update,references hak varchar(255) latin1_swedish_ci NO select,insert,update,references |
|
| REATE TABLE `userku` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(20) NOT NULL, `password` varchar(32) NOT NULL, `hak` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 |
|
| salah nama table gan.. itu table ente userku.. sementara di coding ente tablenya user |
|
| yah pantes aja error orang nama tablenya userku bukan user |
|
| udah di ganti ke user tp tetep ga bisa hohoho SELECT * FROM userku WHERE username='$user_name' |
|
| wkwkw,, makin seru ni kayknya.. Gan,, kayaknya ada salh ketik ni,.
COba perhatikan skrip ini.
$sql=mysql_query("SELECT * FROM user WHERE username='$user_name'"); $result=mysql_query($sql);
kok ada dua kali mysql_query?
biasanya sih, begini.. $sql="SELECT * FROM user WHERE username='$user_name'"; $result=mysql_query($sql);
Kira2 berpengaruh ga tuh? |
|
| bener juga ente gan.. ane malah ga perhatiin itu :v |
|
| nah iy td jg udah di ganti <?php session_start(); include("config/config.php"); $user_name=$_POST['user_name']; $pass=md5($_POST['password']); $today=date('Ymd'); $sql=mysql_query("SELECT * FROM userku WHERE username='$user_name'") or die(mysql_error()); echo "SELECT * FROM userku WHERE username='$user_name'"; //$result=mysql_query($sql) or die(mysql_error()); $hasil=mysql_num_rows($sql); if($hasil>0) { $row=mysql_fetch_array($result); if($row['password']==$pass) { $_SESSION['user']=$user_name; $_SESSION['auth']=$row['hak']; header("location:home.php"); } else { header("location:index.php"); } } else { header("location:index.php"); } ?> |
|
| tetep error maning gan |
|
| errornya tetap sama gan? |
|
| SELECT * FROM userku WHERE username='puriyadi' Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in C:\xampp\htdocs\bakery\auth.php on line 13
Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\bakery\auth.php:8) in C:\xampp\htdocs\bakery\auth.php on line 22 |
|
| coba ganti yang ini:
$row=mysql_fetch_array($result);
jadi
$row=mysql_fetch_array($sql); |
|
| soalnya kan $result udah ente komentari.. otomatis ga akan kebaca... |
|
| SELECT * FROM userku WHERE username='puriyadi' Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\bakery\auth.php:8) in C:\xampp\htdocs\bakery\auth.php on line 18 |
|
| nah.. betul tuh gan.. kan tadi si $result udah dikomen |
|
| errro maning gan |
|
| hapus echo nya mas... |
|
| echo "SELECT * FROM userku WHERE username='$user_name'"; <--- HAPUS |
Tidak ada komentar:
Posting Komentar