vikram12345 Posted November 19, 2012 Share Posted November 19, 2012 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 !!! Link to comment https://forums.phpfreaks.com/topic/270913-correction-require-please/ Share on other sites More sharing options...
Jessica Posted November 19, 2012 Share Posted November 19, 2012 See the link in my signature. Link to comment https://forums.phpfreaks.com/topic/270913-correction-require-please/#findComment-1393613 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. Link to comment https://forums.phpfreaks.com/topic/270913-correction-require-please/#findComment-1393695 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.