Login problem.
Posted: Mon Apr 10, 2006 7:25 am
I wrote this code:
And it's always printing "ERROR", even if the details true.
What can be the problem?
Thanks,
Yoav.
Code: Select all
<?php
echo "<center><div id=\"contentbox\">\n";
echo "<h2><u>LOGIN</u></h2><br />\n";
if($_POST['login']) {
$login_counter = 0;
$username = htmlspecialchars($_POST['username'], ENT_QUOTES);
$password = htmlspecialchars($_POST['password'], ENT_QUOTES);
$password_md5 = md5($password);
$sql_login_activated = @mysql_query("SELECT * FROM digital_blog WHERE username='$username' AND password='$password_md5' AND activated=0") or die (mysql_error());
$login_check_activated = @mysql_num_rows($sql_login_activated);
echo "<center><div id=\"note\"><u>NOTES AFTER SENDING:</u><br /><br />\n";
if($username == "") {
$login_counter = 1;
echo "<b>USERNAME REQUIRED</b><br />\n";
}
if($password == "") {
$login_counter = 1;
echo "<b>PASSWORD REQUIRED</b><br />\n";
}
if($login_check_activated > 0) {
$login_counter = 1;
echo "<b>BEFORE YOU LOGIN YOU NEED TO ACTIVATE</b><br />\n";
}
if($login_counter == 0) {
$sql_login = @mysql_query("SELECT * FROM digital_blog WHERE username='$username' AND password='$password_md5' AND activated=1 AND login=0") or die (mysql_error());
$login_check = @mysql_num_rows($sql_login);
if($login_check > 0) {
header("Location: index.php");
}
else {
echo "<b>ERROR</b>\n";
}
}
echo "</div></center><br />\n";
}
echo "<form method=\"post\" action=\"$PHP_SELF?d=login\">\n";
echo "<b>USERNAME:</b><br /><input type=\"text\" name=\"username\" id=\"username\" /><br />\n";
echo "<b>PASSWORD:</b><br /><input type=\"password\" name=\"password\" id=\"password\" /><br /><br />\n";
echo "<input type=\"submit\" name=\"login\" id=\"login\" value=\" LOGIN \" /></form>\n";
echo "</div></center>\n";
?>What can be the problem?
Thanks,
Yoav.