Login Script Issue

[roberts78]

I have a login page for users to sign in, however when I click on Login it doesn't do anything. Just asked to login again. The login.php page goes to ....method="post" action="check.php"> to verify and login. I cant figure out what in my code is stopping the login process. Here is the code from the check.php page.

 

<?php

/**

* Connect to the mysql database.

*/

$host="localhost"; // Host name

$username="someone"; // Mysql username

$password="password"; // Mysql password

$db_name="test"; // Database name

$tbl_name="users"; // Table name

 

// Connect to server and select database.

mysql_connect("$host", "$username", "$password")or die("cannot connect");

mysql_select_db("$db_name")or die("cannot select DB");

 

// username and password sent from form

$myusername=$_POST['username'];

$mypassword=$_POST['password'];

 

// encrypt password

$encrypted_mypassword=md5($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$encrypted_mypassword'";

$result=mysql_query($sql);

 

// To protect MySQL injection (more detail about MySQL injection)

$myusername = stripslashes($myusername);

$mypassword = stripslashes($mypassword);

$myusername = mysql_real_escape_string($myusername);

$mypassword = mysql_real_escape_string($mypassword);

 

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";

$result=mysql_query($sql);

 

// Mysql_num_row is counting table row

$count=mysql_num_rows($result);

// If result matched $myusername and $mypassword, table row must be 1 row

 

if($count==1){

// Register $myusername, $mypassword and redirect to file "login_success.php"

session_register("myusername");

session_register("mypassword");

header("location:login_success.php");

}

else {

echo header("location:login2.php");

}

?>

[ignace]

session_register("myusername");

session_register("mypassword");

 

is deprecated use:

 

$_SESSION['myusername'] = $myusername;

$_SESSION['mypassword'] = $mypassword;

 

echo header("location:login2.php");

 

should be:

 

header("location:login2.php");

[ldougherty]

After this line:

 

$count=mysql_num_rows($result);

 

You should echo the value of $count to see if it is what you expect it to be.

 

If it is not then you need to go higher in your code and output variables before they are processed to see exactly what is not working.