Kamis, 22 Agustus 2013

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

Tidak ada komentar:

Posting Komentar