Hello All... I am Newbie in CodeIgniter
I want to make my own website for my company and I have a problem in making a Login from 2 database table.
My Controller :
Quote: public function process()
{
$username = $this->input->post('username');
$password = $this->input->post('password');
$staff = $this->login_m->login_staff($username, $password);
if ($staff->num_rows() > 0) {
$data = $staff->row_array();
$this->session->set_userdata('login', TRUE);
if ($data['level'] == '1') {
$this->session->set_userdata('akses', '1');
$this->session->set_userdata('ses_id', $data['username']);
$this->session->set_userdata('ses-name', $data['name']);
redirect('dashboard');
} else if ($data['level'] == '2') {
$this->session->set_userdata('akses', '2');
$this->session->set_userdata('ses_id', $data['username']);
$this->session->set_userdata('ses-name', $data['name']);
redirect('dashboard');
} else if ($data['level'] == '3') {
$this->session->set_userdata('akses', '3');
$this->session->set_userdata('ses_id', $data['username']);
$this->session->set_userdata('ses-name', $data['name']);
redirect('dashboard');
} else if ($data['level'] == '4') {
$this->session->set_userdata('akses', '4');
$this->session->set_userdata('ses_id', $data['username']);
$this->session->set_userdata('ses-name', $data['name']);
redirect('dashboard');
}
} else {
$cust = $this->login_m->login_cust($username, $password);
if ($cust->num_rows() > 0) {
$data = $cust->row_array();
$this->session->set_userdata('login', TRUE);
$this->session->set_userdata('akses', '5');
$this->session->set_userdata('ses_id', $data['username']);
$this->session->set_userdata('ses_name', $data['name']);
redirect('dashboard');
} else {
$this->session->set_flashdata('message', '<div class="alert alert-danger" role="alert">Username/Password are Wrong</div>');
redirect('v_login');
}
}
Here is My Model :
Quote:public function login_staff($username, $password)
{
$query = $this->db->query("SELECT * FROM manajemen WHERE handphone='$username' AND password=MD5('$password') LIMIT 1");
return $query;
}
public function login_cust($username, $password)
{
$query = $this->db->query("SELECT * FROM customer WHERE handphone='$username' AND password=MD5('$password') LIMIT 1");
return $query;
}
When I try this code, the page dont show any error,...just return to the login page.
please help me solve this problem.
tq