Login System does not work
Posted: Sat Dec 02, 2006 8:05 am
http://adamb10.com/pb2/index.php
The first textbox is the username. The login info is adam/123
It's gonna tell you that it's wrong. Time for some code/pix

Database Structure
So any reason why it wont work?
Thanx!
The first textbox is the username. The login info is adam/123
It's gonna tell you that it's wrong. Time for some code/pix

Database Structure
Code: Select all
<?
session_start();
db_connect();
$username=$_POST['username'];
$password=$_POST['password'];
$settings_query = mysql_query("SELECT * FROM guestbook_settings WHERE setting_id='2'='$username' AND setting_id='3'='$password'") or die(mysql_error());
while ($row = mysql_fetch_assoc($settings_query))
{
$settings[$row['setting_id']] = $settings[$row['setting_name']] = $row['setting_value'];
}
mysql_real_escape_string($username);
mysql_real_escape_string($password);
if (mysql_num_rows($settings_query)== 0){
//Login Details = incorrect?
session_destroy();
echo 'Login failed because of the following error returned:<br>
<b>You entered in a wrong username/password</b>';
} else {
echo 'Hey! your like logged in man!';
}
?>Thanx!