annoying error - cant get login script working!

[foxboro]

This is the code from the checklogin.php page - obviously minus the connection information to MYSQL.

 

 

if (!mysql_connect($db_host, $db_user, $db_pwd))

    die("Can't connect to database");

 

if (!mysql_select_db($database))

    die("Can't select database");

 

//Username and password sent from form

$username= $_POST['username'];

$password= $_POST['password'];

 

//To protect against MySQL injection.

$username = stripslashes($username);

$password = stripslashes($password);

$username = mysql_real_escape_string($username);

$password = mysql_real_escape_string($password);

 

 

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

$result=mysql_query($sql);

 

mysql_close();    //Closes the connection to the mysql db.

 

//Mysql_num_row is counting table rows returned.

$count=mysql_num_rows($result);

 

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

$info = mysql_fetch_array($result);

$access = $info['access'];

 

if($count==1){

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

  session_register("username");

  session_register("password");

  session_register("access");

  header("location:login_success.php");

}else{

  echo "Wrong Username or Password";

}

 

?>

 

 

There seems to be a problem with the bold part. any ideas?

would be greatful of help!

[lonewolf217]

i believe the issue is that you are closing your DB connection and then trying to process the results from the query with mysql_num_rows() and mysql_fetch_array()

 

try closing the connection at the end of the script instead. 

 

If that doesn't work you are going to have to be much more clear on why you think it doesn't work

 

[anupamsaha]

First of all, as a rule of this forum, post your code in code block. E.g.

 

<?php
echo "Something";
?>

 

Now, regarding the issue, change this:

session_register("username");
session_register("password");
session_register("access");

 

To:

$_SESSION["username"] = $username;
$_SESSION("password"] = $password;
$_SESSION["access"] = $access;

 

Hope this will help you.

 

[anupamsaha]

First of all, as a rule of this forum, post your code in code block. E.g.

 

<?php
echo "Something";
?>

 

Now, regarding the issue, change this:

session_register("username");
session_register("password");
session_register("access");

 

To:

$_SESSION["username"] = $username;
$_SESSION("password"] = $password;
$_SESSION["access"] = $access;

 

Hope this will help you.

 

Also, make sure that the statement session_start() is triggered from top of every script.

 

[laffin]

I wud add a bit of debugging.

$result=mysql_query($sql) or die("Error (".mysql_errorno()."): ".mysql_error()."<br>"Query='{$sql}'");

 

I think is correct.

[jxrd]

Uhh...you do realise that you're closing your mysql connection before you're fetching/counting your results...?

[foxboro]

cheers guys il try the suggestions out now.

i'm fairly new to PHP hense the dumbness of whats going on.

Also another person made the log in script, im just trying to make it work on my computer