HELP!!!! Problem with my MySQL connected PHP login form :'(

Ross_B_00 · #1 (**permalink**) 08-19-11, 04:12 AM

Im new to PHP and MySQL and am trying to get my head around connecting my PHP login form scripts with my MySQL database form login username and password verification. Im completely stuck with this one have been at it all night and i know its probably something silly.

Can anyone HELP!!!!!!

I keep getting the Undefined login error message from one of my PHP file on line 14 in the first file but im quite sure i have defined it:

HTML Code:

[PHP]
<html>
<body>

<form action="index4.php?login=yes" method="POST">
Username:<input type="text" name="user"><br />
Password:<input type="password" name="pass" ><br/>
<input type="submit" value="SIGN-IN" ><p>
</form>

<?php

$user=$_POST['user'];
$pass=$_POST['pass'];
$login=$_POST['login'];

function denied()
	{
	echo '<h3><span style= "color:red"> Access Denied!!! </span></h3><br><br>';
	}
	
function granted ($user)
	{
	echo '<h3><span style= "color:green"> Access Granted!!! </span></h3>';
	echo 'Welcome, ' . $user; 
	}

if($login=='yes')
	{
	$con= include_once "mysql_connect.php";
	$get = mysql_query("SELECT count(id) FROM login WHERE user='$user' and pass='$pass'");
	$result = mysql_result($get, 0);
	
	if (empty($user) || empty($pass))
		{
		denied();
		die("<br>Please fill out user login fields carefully....<br>");
		}
		
	if ($result!=1) 
		{
		granted($user);
		}
		
	else
		{
		denied ();
		}
	}

?>

</body>
</html>
 [/PHP]

The following script is associated with the above script:

PHP Code:


			
<?php

$db_host = "localhost";
$db_username = "root";
$db_pass = "rhianna";
$db_name = "signin";

@mysql_connect("$db_host", "$db_username", "$db_pass") or die ("Could not connect to MySQL");
@mysql_select_db("$db_name") or die ("No $db_name Database ");

?>