vikram12345 Posted November 19, 2012 Share Posted November 19, 2012 (edited) My user authentication code -- <?php $useremail = $_POST['emailfield'] ; $userpassword = $_POST['pwfield'] ; require ('sqlauth2.php') ; mysql_select_db($database, $con); $sql = "SELECT * FROM userregistry WHERE email='".$useremail."' AND password='".$userpassword."'" ; $run = mysql_query($sql) ; $row = mysql_fetch_array($run) ; if(mysql_num_rows($run) == 1) { echo "SUCCESS <br>" ; } else { echo "No login for you " ; } ?> Looks perfect, but I keep getting this error Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\bullet2\logincheck.php on line 10 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\bullet2\logincheck.php on line 12 No login for you Any idea ? Searched everywhere, couldn't find anything proper. I know there is something wrong somewhere, can't seem to find it. Help me out people, thanks !!! Edited November 19, 2012 by PFMaBiSmAd removed wysiwyg formatting to fix micro size font Quote Link to comment Share on other sites More sharing options...
Jessica Posted November 19, 2012 Share Posted November 19, 2012 See the link in my signature. Quote Link to comment Share on other sites More sharing options...
Christian F. Posted November 20, 2012 Share Posted November 20, 2012 I also recommend this article about secure login systems, as you have some major security concerns in your code. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.