Welcome Guest, Not a member yet? Register   Sign In
Help session grab user_id from database
#37

[eluser]Samus[/eluser]
I'll rewrite it for you how I would write it and you let me know how that works.

Login check:

Code:
Login Check:

// Logged In
function check()
{
  
    
  $this->form_validation->set_rules('username', 'required|max_length[15]');
  $this->form_validation->set_rules('password', 'required|sha1');
    
  if ($this->form_validation->run() == FALSE) {
  
   $data['title'] = "Customer Login";
   $this->load->view('user/logon', $data);
  }
  else {

// Check user and password
  $query = $this->user_model->checkUser($this->input->post('username'), sha1($this->input->post('password')));
   if($query['true']) {
    
     $result = $query['result'];
    
     foreach($result as $res) {
         $session_data = array(
           'username'     => $res['username'],
           'is_user'      => true,
           'is_logged_in' => true,
           'last_login'   => time(),
           'customer_id'  => $res['id'],
           'acc_number'   => $res['acc_number'],
           'name'         => $res['name']
                );
  
     $this->session->set_userdata($session_data);
     redirect('user/myaccount');
      }
   }
   else {
    // username or password incorrect, should probably create a callback instead
   }
  }
}
Code:
function checkUser($username, $password)
{

  $query = $this->db->get_where('users', array('username' => $username, 'password' => $password));

  if($query->num_rows() == 1)
  {
    $data['true'] = TRUE;
    $data['result'] = $query->result_array();
  }
  else {
    $data['true'] = FALSE;
  }
return $data;
}

You should probably do a callback in your validation rules to check if the username / password match.


Messages In This Thread
Help session grab user_id from database - by El Forum - 05-23-2012, 08:16 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 08:36 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 08:40 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 08:43 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 08:45 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 08:52 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 08:56 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 08:58 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 09:01 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 09:06 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 09:07 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 09:13 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 09:15 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 09:20 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 09:21 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 10:19 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 10:22 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 10:25 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 10:29 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 10:30 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 10:37 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 10:42 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 11:07 AM
Help session grab user_id from database - by El Forum - 05-23-2012, 12:42 PM
Help session grab user_id from database - by El Forum - 05-24-2012, 08:50 AM
Help session grab user_id from database - by El Forum - 05-24-2012, 09:06 AM
Help session grab user_id from database - by El Forum - 05-24-2012, 09:16 AM
Help session grab user_id from database - by El Forum - 05-24-2012, 09:35 AM
Help session grab user_id from database - by El Forum - 05-24-2012, 09:37 AM
Help session grab user_id from database - by El Forum - 05-24-2012, 10:30 AM
Help session grab user_id from database - by El Forum - 05-24-2012, 10:41 AM
Help session grab user_id from database - by El Forum - 05-25-2012, 08:57 AM
Help session grab user_id from database - by El Forum - 05-25-2012, 08:12 PM
Help session grab user_id from database - by El Forum - 05-25-2012, 08:29 PM
Help session grab user_id from database - by El Forum - 05-26-2012, 12:35 AM
Help session grab user_id from database - by El Forum - 05-26-2012, 03:01 AM
Help session grab user_id from database - by El Forum - 05-26-2012, 03:37 AM
Help session grab user_id from database - by El Forum - 05-26-2012, 09:03 AM
Help session grab user_id from database - by El Forum - 05-26-2012, 11:35 AM
Help session grab user_id from database - by El Forum - 05-28-2012, 01:35 AM
Help session grab user_id from database - by El Forum - 05-28-2012, 03:13 AM
Help session grab user_id from database - by El Forum - 05-29-2012, 04:40 AM
Help session grab user_id from database - by El Forum - 05-29-2012, 07:56 AM
Help session grab user_id from database - by El Forum - 05-29-2012, 09:52 AM
Help session grab user_id from database - by El Forum - 05-29-2012, 09:54 AM
Help session grab user_id from database - by El Forum - 05-29-2012, 11:37 AM
Help session grab user_id from database - by El Forum - 05-29-2012, 12:57 PM
Help session grab user_id from database - by El Forum - 06-09-2012, 09:07 PM
Help session grab user_id from database - by El Forum - 06-11-2012, 12:59 PM



Theme © iAndrew 2016 - Forum software by © MyBB