PHP/MySQL Help

[catacon]

Hey,

I am using a login script for my website that I wrote for a former site. On that site it worked, but now it won't. When I try to login it says that the information is not valid (which it is). The code is below. I was wonder what I doing wrong.

I am using phpMyAdmin for creating the databases and was wondering if that could cause problems. I saw a new setting that says "Collation" and it is set to latin-swedish. I have never used that in previous version and thought that could be causing this. Any help would be appreciated. Thanks!

PHP Code:


<?php

if (isset($_POST['submit'])) {
    require_once ("../mysql_connect.php");

// Check Username
    
    if (empty($_POST['username'])) {
        $u = FLASE;
        echo "Please enter your username.";
    } else {
        $u = escape_data($_POST['username']);
    }
    
// Check Password

    if (empty($_POST['password'])) {
        $p = FLASE;
        echo "Please enter your password.";
    } else {
        $p = escape_data($_POST['password']);
    }
    
    if ($u && $p) { //All is well
        $query = "SELECT user_id, username, time_offset FROM members WHERE username='$u' AND password=PASSWORD('$p')";
        $result = @mysql_query ($query);
        $row = mysql_fetch_array ($result, MYSQL_NUM);
        
        if ($row) { // Match was made
        
            $_SESSION['time_offset'] = $row[2];
            $_SESSION['username'] = $row[1];
            $_SESSION['user_id'] = $row[0];
            
            if (isset($_POST['remember'])) {
                setcookie ("cooktime", $row[2], time()+60*60*24*30, "/");
                setcookie ("cookname", $row[1], time()+60*60*24*30, "/");
                setcookie ("cookuser", $row[0], time()+60*60*24*30, "/");
            }
            
            $update = "UPDATE members SET last_activity=NOW(), loggedin='1' WHERE user_id={$row[0]}";
            $result = @mysql_query($update);
            
            if ($result) { //worked 
                        
            ob_end_clean();
            
            header ("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/main.php");
            exit();
            
            }
            
        } else {
            echo "Information entered did not match those in our database.";
        }
        
        
    } else {
        echo "Please try again."; 
    }
}

?>

<span class="title">Login</span>


Your browser must allow cookies in order for you to login.




<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">

Username: <input type="text" name="username" size="10" maxlength="20" value="<?php if(isset($_POST['username'])) { echo $_POST['username']; } ?>" />




Password: <input type="password" name="password" size="10" maxlength="16" />




Forget Me Not: <input type="checkbox" name="remember" />



<center><input type="submit" name="submit" value="Login" /></center>

</form>

[blue60007]

What information is invalid? Can you give us an exact error message?

[catacon]

Well, it's the message I put in there if the password and/or username do not match. After the query it says if($row), if that is not true, the message "Information entered did not match those in our database." There is no mysql error.

[blue60007]

Well it sorta sounds like something was changed during a MYSQL and/or PHP upgrade... I might try to duplicate that database and try connecting to it with a duplicate.

[hartken]

Try changing all the $result = @mysql_query ($query); to $result = @mysql_query ($query) or die(mysql_error()); This will give you the specific error from the MySQL on what's going wrong.

I bet it is a simple connection problem. Did you change your settings to the new db?