PHP Indonesia - Facebook: para master saya mau tanya kenapa pas login saya m...

PHP Indonesia - Facebook PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/

How to Get into Medical School A tested blueprint to approach the daunting admissions process with both confidence and success! Enroll in this online course for just $29. From our sponsors

para master saya mau tanya kenapa pas login saya m... Aug 22nd 2013, 07:30, by Puriyadi Dexter Puriyadi Dexter 7:30am Aug 22 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 Andy Wijaya 7:33am Aug 22 coba liat kode auth.php nya dong.. Puriyadi Dexter 7:34am Aug 22 <?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"); } ?> Rio Andrew M Purba 7:35am Aug 22 sepertinya salah di query mysql nya gan. coba tambahkan die(mysql_error()); di ujung nya query sql.. supaya keliatan detail kesalahannya gan. Rio Andrew M Purba 7:36am Aug 22 coba tambahin, $sql=mysql_query("SELECT * FROM user WHERE username='$user_name'")or die(mysql_error()); Puriyadi Dexter 7:38am Aug 22 hasilnya mysql_fetch_array() expects parameter 1 to be resource, null given in Andy Wijaya 7:39am Aug 22 coba cek nama tabel dan nama kolom di databasenya, apakah sudah sesuai atau belum Rizaldi Maulidia 7:41am Aug 22 bisa liat struktur table usernya... Puriyadi Dexter 7:42am Aug 22 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 Puriyadi Dexter 7:45am Aug 22 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 Andy Wijaya 7:46am Aug 22 salah nama table gan.. itu table ente userku.. sementara di coding ente tablenya user Rizaldi Maulidia 7:46am Aug 22 yah pantes aja error orang nama tablenya userku bukan user Puriyadi Dexter 7:47am Aug 22 udah di ganti ke user tp tetep ga bisa hohoho SELECT * FROM userku WHERE username='$user_name' Rio Andrew M Purba 7:48am Aug 22 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? Andy Wijaya 7:49am Aug 22 bener juga ente gan.. ane malah ga perhatiin itu :v Puriyadi Dexter 7:49am Aug 22 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"); } ?> Puriyadi Dexter 7:49am Aug 22 tetep error maning gan Andy Wijaya 7:51am Aug 22 errornya tetap sama gan? Puriyadi Dexter 7:51am Aug 22 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 Rizaldi Maulidia 7:51am Aug 22 coba ganti yang ini: $row=mysql_fetch_array($result); jadi $row=mysql_fetch_array($sql); Rizaldi Maulidia 7:52am Aug 22 soalnya kan $result udah ente komentari.. otomatis ga akan kebaca... Puriyadi Dexter 7:52am Aug 22 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 Andy Wijaya 7:53am Aug 22 nah.. betul tuh gan.. kan tadi si $result udah dikomen Puriyadi Dexter 7:53am Aug 22 errro maning gan Rizaldi Maulidia 7:53am Aug 22 hapus echo nya mas... Rizaldi Maulidia 7:53am Aug 22 echo "SELECT * FROM userku WHERE username='$user_name'"; <--- HAPUS

You are receiving this email because you subscribed to this feed at blogtrottr.com. If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions