Jump to content

Not Finding Username (BASIC)


jordanwhite

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.