[RESOLVED] Login Page Problem

BlueGemini

What do you think is wrong in my code? It seems nothing is happening. It suppose to go to another page (main.php) confirming whether the login is correct or not.. 😕 😕 😕

<?php
// Use session variable on this page. This function must put on the top of page.
session_start();

////// Logout Section. Delete all session variable.
session_destroy();

$message="";

////// Login Section.
$Login=($POST['Login']);
if(!$Login){ // If clicked on Login button.
$username=$POST['username'];
$md5_password=md5($_POST['password']); // Encrypt password with md5() function.

// Connect database.
$host="localhost"; // Host name.
$db_user="root"; // MySQL username.
$db_password=""; // MySQL password.
$database="SAMPLE"; // Database name.
mysql_connect($host,$db_user,$db_password);
mysql_select_db($database);

// Check matching of username and password.
$result=mysql_query("select * from user where username=$username and password=$md5_password");

if(mysql_num_rows($result)!=0)
{ // If match.
session_register("username"); // Craete session username.
header("location:main.php"); // Re-direct to main.php
exit;
}else{ // If not match.
$message="--- Incorrect Username or Password ---";
}

} // End Login authorize check.
?>

<title>LOGIN</title>
</head>

<body>
<?php echo $message; ?>
<form id="form1" name="form1" method="post" action="<?php echo $PHP_SELF; ?>">
<table>
<tr>
<td>User : </td>
<td><input name="username" type="text" id="username" /></td>
</tr>
<tr>
<td>Password : </td>
<td><input name="password" type="password" id="password" /></td>
</tr>
</table>
<input name="Login" type="submit" id="Login" value="Login" />
</form>
</body>

</html>

sagee

try this:

mysql_query("select * from user where username='".$username."' and password='".$md5_password."'");

BlueGemini

sagee wrote:
try this:

mysql_query("select * from user where username='".$username."' and password='".$md5_password."'");

Uhm, its still the same, nothing happens

sagee

your connection settings are incorrect.
try this:

$connection=mysql_connect($host,$db_user,$db_password) or die ("connection wrong");
$db=mysql_select_db($database,$connection) or die ("db");

BlueGemini

sagee wrote:
your connection settings are incorrect.
try this:

$connection=mysql_connect($host,$db_user,$db_password) or die ("connection wrong");
$db=mysql_select_db($database,$connection) or die ("db");

Still not right. Nothing happens 😕 hmm 😕

But I agree... something's not right in my connection. I just can't figure it out.

sagee

here is the full WORKING code:

<?php
// Use session variable on this page. This function must put on the top of page.
session_start();

////// Logout Section. Delete all session variable.
session_destroy();

$message="";

////// Login Section.
if(isset($POST['Login'])){ // If clicked on Login button.
$username=$POST['username'];
$md5_password=md5($_POST['password']); // Encrypt password with md5() function.

// Connect database.
$host="localhost"; // Host name.
$db_user="root"; // MySQL username.
$db_password="xxxx"; // MySQL password.
$database="dbname"; // Database name.

$connection=mysql_connect($host,$db_user,$db_password) or die ("connection wrong");
$db=mysql_select_db($database,$connection) or die ("db");


// Check matching of username and password.
$result=mysql_query("select * from user where username='".$username."' and password='".$md5_password."'");

if(mysql_num_rows($result)!=0)
{ // If match.
session_register("username"); // Craete session username.
header("location:main.php"); // Re-direct to main.php
exit;
}else{ // If not match.
$message="--- Incorrect Username or Password ---";
}

} // End Login authorize check.
?>

BlueGemini

sagee wrote:
here is the full WORKING code:

<?php
// Use session variable on this page. This function must put on the top of page.
session_start();

////// Logout Section. Delete all session variable.
session_destroy();

$message="";

////// Login Section.
if(isset($POST['Login'])){ // If clicked on Login button.
$username=$POST['username'];
$md5_password=md5($_POST['password']); // Encrypt password with md5() function.
// Connect database.
$host="localhost"; // Host name.
$db_user="root"; // MySQL username.
$db_password="xxxx"; // MySQL password.
$database="dbname"; // Database name.

$connection=mysql_connect($host,$db_user,$db_password) or die ("connection wrong");
$db=mysql_select_db($database,$connection) or die ("db");


// Check matching of username and password.
$result=mysql_query("select * from user where username='".$username."' and password='".$md5_password."'");

if(mysql_num_rows($result)!=0)
{ // If match.
session_register("username"); // Craete session username.
header("location:main.php"); // Re-direct to main.php
exit;
}else{ // If not match.
$message="--- Incorrect Username or Password ---";
}
} // End Login authorize check.
?>

Waaah! Its not working either... 🙁🙁 🙁 does it work on you? What went wrong on me??? 🙁🙁

sagee

it works on my system.
the code is correct.

did you change the database name & mysql username & password?

BlueGemini

sagee wrote:
it works on my system.
the code is correct.

did you change the database name & mysql username & password?

Yeah, I change them... so it work on you? Does it mean it switch to main.php after the log-in? or it shows the message, "Incorrect Username or Password" if its wrong?

BlueGemini

HWAAH! Hey, I got it. I finally got it work! The one's giving me the prob is the md5() function. Don't know why but when I remove it, it finally work.

Thanks for everything!

😃