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

#2
[eluser]James Gifford[/eluser]
There are any number of ways to do validation that depend a lot on your preferred coding style. Here is a simple way:
Code:
function login ()
{
   $this->load->library('validation');

   $fields['user_name'] = 'username';
   $fields['password'] = 'password';

   $this->validation->set_fields($fields);

   $rules['user_name'] = 'required|callback__check_login';
   $rules['password'] = 'required';

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

   if ($this->validation->run())
   {
      // Log user in
   }

   // Display the login form
}

function _check_login ($user_name)
{
   $this->validation->set_message('_check_login', 'Your login information is invalid');

   $this->db->where('user_name', $user_name);
   $this->db->where('password', $this->validation->password);
   $query = $this->db->get('users');

   return ($query->num_rows() > 0);
}

#3
[eluser]SparkyCola[/eluser]
Ah I see- thanks very much James Smile

Sparky


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


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