jordanwhite Posted December 19, 2010 Share Posted December 19, 2010 Hey Guys Im following PHPACADEMY tutorial for integrating login. Im on the second video The problem im getting is when i enter in my login and password from my table in my database [(alex, abc) I tried copying them directly also] "I get the error that user doesn't exist" index.php <html> <form action='login.php' method='POST'> Username: <input type='text' name='username'><br> Password: <input type='password' name='password'><br> <input type='submit' value='Log In'> </form> </html> Login.php <?php $username = $_POST['username']; $password = $_POST['password']; if ($username&&$password) { $connect = mysql_connect("localhost","root","") or die ("couldnt connect"); mysql_select_db("phplogin") or die ("could not connect to db"); $query = mysql_query("SELECT * FROM users WHERE username='$username'"); $numrow = mysql_num_rows($query); if ($numrows!=0) { //code to login } else die("that user doesn't exist"); } else die("Please Enter username and password"); ?> Link to comment https://forums.phpfreaks.com/topic/222142-not-finding-username-basic/ Share on other sites More sharing options...
Pikachu2000 Posted December 19, 2010 Share Posted December 19, 2010 The problem that stands out is $numrow versus $numrows. Link to comment https://forums.phpfreaks.com/topic/222142-not-finding-username-basic/#findComment-1149329 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.