Login Validation

#1
[eluser]SparkyCola[/eluser]
Hi,

I'm a bit stuck. In PHP, this is what I want to do, just as a rough idea:

Code:
$query = "SELECT * FROM users WHERE username='$user_name' AND password='$password'";
$result = mysql_query($query, $connection) or die ('error making query');
$affected_rows = mysql_num_rows($result);
if($affected_rows == 1) {
  // Validated so continue...
} else {
  // Not validated so error
}



In CI this is what I have:

Code:
function _validation($user_name, $password) {
        
        $rules['username']    = "required|callback_username_check";
        $rules['password']    = "required|";

        $this->validation->set_rules($rules);
    }

    function username_check($user_name) {
        
        $query = $this->db->query("SELECT * FROM users WHERE username = '$user_name' LIMIT 1");
        $row = $query->row_array();
        
        if ($query->num_rows() == 0) {
            $this->validation->set_message('username_check', 'Not found in the user database');
            return FALSE;
        } else {
            $db_username = $row['username'];
            
            if ($user_name == $db_username) {
                return TRUE;
            } else {
                $this->validation->set_message('username_check', 'Not found in the user database');
                return FALSE;
            }
        }
    }

I'd appreciate any help, just not sure how to achieve the same result - i.e. checking the username AND password together. I could do a callback thing with password as well, but I don't want to do that in case the username is in the database, and the password is in the DB too, but not together on the same row. Thanks,

Sparky


Messages In This Thread
Login Validation - by El Forum - 03-06-2008, 02:04 PM
Login Validation - by El Forum - 03-06-2008, 04:02 PM
Login Validation - by El Forum - 03-06-2008, 04:47 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.