[Resolved] login problem

baraba

<?
session_start();
$name=$HTTP_POST_VARS[name];
$password=$HTTP_POST_VARS[password];
if ($name && $password)
{
$mysql=mysql_connect("localhost");
mysql_select_db("vpis", $mysql);
$query = "select name, password from clani where
name='$name' and
pass='$password'";
$result = mysql_query($query, 0, 0);
$count=mysql_result( $result);
if ($count > 0)
{
$valid_user=$name;
session_register("valid_user");
}
}
?>
<html code>
<?
if (session_is_registered("valid_user"))
{
echo "<center>Welcome on members page.</center>";
}
else
{
if (isset($name))
{
echo "<center><font color=#ff0000></font> Could not log in! Please retype username/password.";
}
else
{
echo "<center>You are not logged in.";
}
echo "<html>
<form method=post action=login.php>
<table border=0 align=center>
<tr>
<th>Username</th>
<td><input type=text name=name></td>
<th>Password</th>
<td><input type=password name=password></td>
</tr>
<tr>
<td colspan=4 align=center>
<input type=submit value=Login>
</td>
</tr>
</table>";
}
?>

The problem is i cannot login at all. I checked mysql connection and select_db and it works fine.

zmola

Hi. If register_globals if off, then use $SESSION instead. When using $SESSION, don't use session_register(), session_is_registered(), or session_unregister().

scoppc

Originally posted by zmola
When using $_SESSION, don't use session_register(), session_is_registered(), or session_unregister().

I dont think you cant use em, coz it really works fine for me. In fact, I'll start the session and register it in each and every page that need the session variable. 🙂

zmola

What's your register_globals set to?

baraba

Well i have globals on. But the problem is that i used one database for testing and everything worked fine. Then i droped that database and created a new one with same name and same table name, chars, primary key and everything but different username and pass. Now it doesnt work.

zmola

Perhaps look at...

$result = mysql_query($query, 0, 0); 
$count=mysql_result( $result); 
// versus
$result = mysql_query($query, $mysql);
$count=mysql_result( $result, 0);

baraba

Hmm. I think its problem with mysql cause now i cannot concect not even in my movie db.

baraba

Nope. MySql is working OK. So it must be the php script.

baraba

Ok. Now it works. I changed code from $result = mysql... to if statement like this:

$result = mysql_query($query, $mysql);
if(mysql_num_rows($result) >0)

but it still didnt work, so i inserted this line after if statement:

echo "$result";

Now it works but i have no idea why and how. 😕

baraba

I inserted this line next to mysql_query :

or die("<pre>" . mysql_error() . "\n\nLast query: $query</pre>");

and i found out that i wrote pass instead password in $query.

Thx for help anyway.

🙂