[eluser]ywftdg[/eluser]
I have been trying to get this to work in a MVC setup, but nothing works. It works when its just in controller as:
Code:
$data['password'] = $this->input->post('password');
$data['email'] = $this->input->post('email');
$this->db->select('*');
$this->db->where('designer.dEmail' , $data['email']);
$this->db->where('designer.dPassword' , $data['password']);
$this->db->from('designer');
$query = $this->db->get();
But if I try and put this in a model/controller setup, the variables wont pass. Any suggestions on how you would flip the query on this to a model and pass the variables email and password? Then bring back to the controller for a if statement?
MY attempted MVC is:
model
Code:
function check_emailpassword($data) {
$email = $data['email'];
$password = $data['password'];
$this->db->select('*');
$this->db->where('designer.dEmail' , $email);
$this->db->where('designer.dPassword' , $password);
$this->db->from('designer');
$query = $this->db->get();
return $query->result();
}
controller
Code:
function login()
{
$this->load->library('validation');
$this->load->model('Designers_model', 'designer');
if ($this->validation->run() == TRUE) {
$data['password'] = $this->input->post('password');
$data['email'] = $this->input->post('email');
$this->load->model('Designers_model', 'designer');
$query = $this->designer->check_emailpassword($data);
if ($query->num_rows() > 0) { // DB TRUE
redirect('designers/account');
} else { // QUERY FALSE
$this->load->view('login_view');
}
}
else { // Validation FALSE
$this->load->view('login_view');
}
}