RE: [PHP] php Login script issue
argh! hotmail sucks I don't see in the script where you are using $_POST / $_GET / $_REQUEST to access tha data from the form. Its likely that the example you are following is old and uses 'register_globals'. Since register_globals is a huge security hole and is not active in any new installations of PHP you need to change your script to use the above methods to get the form data. The error you are getting is due to the fact that you are not passing in the values to the sql and not getting a valid result Note that the below example fixes your issue but DOES NOT do any validation, which you really should do before passing your data to the sql... $userid=mysql_real_escape_string($_POST['userid']); $password=mysql_real_escape_string($_POST['password']); if($rec=mysql_fetch_array(mysql_query("SELECT * FROM tablename WHERE> userName='$userName' AND password = '$password'"))){ if(($rec['userName']==$userName)&&($rec['password']==$password)) bastien > Date: Sun, 16 Sep 2007 02:39:57 -0700> From: [EMAIL PROTECTED]> To: php-general@lists.php.net> Subject: [PHP] php Login script issue>>> Hi,>> Its just a login and password validation that I am trying to achieve. If the> username is correct then the person is able to view certain page, if> incorrect then he is directed elsewhere.>> $userid=mysql_real_escape_string($userid);> $password=mysql_real_escape_string($password);>> if($rec=mysql_fetch_array(mysql_query("SELECT * FROM tablename WHERE> userName='$userName' AND password = '$password'"))){> if(($rec['userName']==$userName)&&($rec['password']==$password)){> include "../include/newsession.php";> echo " Successfully,Logged in> logout.php Log OUT welcome.php Click here if your browser is not> redirecting automatically or you don't want to wait. ";> print "";>> }> }> else {>> session_unset();> echo "Wrong Login. Use your correct Userid and Password and Try> onClick='history.go(-1)'>";>> }> ?>>> I am getting this error when I am using this code:>> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result> resource in thispage.php on line 37> Wrong Login. Use your correct Userid and Password and Try>> Why does it show up everytime and whats wrong with mysql_fetch_array().>> Please advice also if there is some other way available please help me try> that.>> Thanks,>> Chris> --> View this message in context: http://www.nabble.com/php-Login-script-issue-tf4450691.html#a12698139> Sent from the PHP - General mailing list archive at Nabble.com.>> --> PHP General Mailing List (http://www.php.net/)> To unsubscribe, visit: http://www.php.net/unsub.php> _ Connect to the next generation of MSN Messenger http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] php Login script issue
Hi, $result = mysql_query("SELECT * FROM tablename WHERE userName='$userName' AND password = '$password'"); if($rec = mysql_fetch_array($result)){ //your code } Try like this it may solve. It may solve your problem Don't try to fetch the result from one single line code. Warm Regards, Sanjeev http://www.sanchanworld.com/ http://webdirectory.sanchanworld.com - Submit your website URL http://webhosting.sanchanworld.com - Choose your best web hosting plan -Original Message- From: Chris Carter [mailto:[EMAIL PROTECTED] Sent: Sunday, September 16, 2007 3:10 PM To: php-general@lists.php.net Subject: [PHP] php Login script issue Hi, Its just a login and password validation that I am trying to achieve. If the username is correct then the person is able to view certain page, if incorrect then he is directed elsewhere. Successfully,Logged in logout.php Log OUT welcome.php Click here if your browser is not redirecting automatically or you don't want to wait. "; print ""; print " self.location='submit-store-details.php';"; // Comment this line if you don't want to redirect print ""; } } else { session_unset(); echo "Wrong Login. Use your correct Userid and Password and Try "; } ?> I am getting this error when I am using this code: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in thispage.php on line 37 Wrong Login. Use your correct Userid and Password and Try Why does it show up everytime and whats wrong with mysql_fetch_array(). Please advice also if there is some other way available please help me try that. Thanks, Chris -- View this message in context: http://www.nabble.com/php-Login-script-issue-tf4450691.html#a12698139 Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] php Login script issue
On 9/16/07, Chris Carter <[EMAIL PROTECTED]> wrote: > > Hi, > > Its just a login and password validation that I am trying to achieve. If the > username is correct then the person is able to view certain page, if > incorrect then he is directed elsewhere. > > $userid=mysql_real_escape_string($userid); Here you call it $userid > $password=mysql_real_escape_string($password); > > if($rec=mysql_fetch_array(mysql_query("SELECT * FROM tablename WHERE > userName='$userName' AND password = '$password'"))){ and here you call it $userName. If this is the full code, $userName is not set here, and it would result in query userName='' and mysql_query will return FALSE, which isn't a valid mysql resource for mysql_fetch_array. >if(($rec['userName']==$userName)&&($rec['password']==$password)){ > include "../include/newsession.php"; >echo " Successfully,Logged in > logout.php Log OUT welcome.php Click here if your browser is not > redirecting automatically or you don't want to wait. "; > print ""; > print " self.location='submit-store-details.php';"; // Comment this > line if you don't want to redirect > print ""; > >} >} >else { > >session_unset(); > echo "Wrong Login. Use your correct Userid and Password and Try > onClick='history.go(-1)'>"; > >} > ?> > > I am getting this error when I am using this code: > > Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result > resource in thispage.php on line 37 > Wrong Login. Use your correct Userid and Password and Try > > Why does it show up everytime and whats wrong with mysql_fetch_array(). > > Please advice also if there is some other way available please help me try > that. > > Thanks, > > Chris I advice you to split the code up in 2 seperate actions, and check for errors. > if($rec=mysql_fetch_array(mysql_query("SELECT * FROM tablename WHERE > userName='$userName' AND password = '$password'"))){ would become: $result = mysql_query("SELECT * FROM tablename WHERE userName='$userName' AND password = '$password'") or die (mysql_error()); // You could also add some checks here with mysql_num_rows for example... if($rec=mysql_fetch_array($result)){ Tijnema -- If this is a mailing list: DO NOT TOP POST! why?: http://www.caliburn.nl/topposting.html Vote for PHP Color Coding (aka Syntax Highlighting) in Gmail! -> http://gpcc.tijnema.info -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] php Login script issue
Hi, Its just a login and password validation that I am trying to achieve. If the username is correct then the person is able to view certain page, if incorrect then he is directed elsewhere. Successfully,Logged in logout.php Log OUT welcome.php Click here if your browser is not redirecting automatically or you don't want to wait. "; print ""; print " self.location='submit-store-details.php';"; // Comment this line if you don't want to redirect print ""; } } else { session_unset(); echo "Wrong Login. Use your correct Userid and Password and Try "; } ?> I am getting this error when I am using this code: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in thispage.php on line 37 Wrong Login. Use your correct Userid and Password and Try Why does it show up everytime and whats wrong with mysql_fetch_array(). Please advice also if there is some other way available please help me try that. Thanks, Chris -- View this message in context: http://www.nabble.com/php-Login-script-issue-tf4450691.html#a12698139 Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP Login Script
Chuck wrote: Could anyone let me know or point me to where I could find out how to setup a login for my php site. I've been looking around and found plenty of stuff for PHP/Apache, but nothing for just PHP. You need to store user information somewhere and apache .htpasswd files and mysql databases are popular choices. Shamless plug: I can direct you to a php and mysql login system at http://www.radinks.net/user/ Any help or info about this would be appreciated. Thanks, Chuck -- Raditha Dissanayake. http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader Graphical User Inteface. Just 128 KB | with progress bar. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP Login Script
Could anyone let me know or point me to where I could find out how to setup a login for my php site. I've been looking around and found plenty of stuff for PHP/Apache, but nothing for just PHP. Any help or info about this would be appreciated. Thanks, Chuck -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP login script
I'm looking for some good, secure login code, and found the following article: http://www.devshed.com/c/a/PHP/Creating-a-Secure-PHP-Login-Script/ Not being much of a security expert, I was wondering if anyone here could say whether this code is any good? Or if there's a better one elsewhere? (I'm developing with MySQL, and do not know object-oriented PHP or PEAR—which this samplel uses.) ...Rene -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php