SHOW:
|
|
- or go back to the newest paste.
1 | <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); | |
2 | ||
3 | class Login_model extends CI_Model{ | |
4 | ||
5 | public function __construct() | |
6 | { | |
7 | //parent::__construct(); | |
8 | $this->load->session(); | |
9 | - | parent::__construct(); |
9 | + | $this->load->database(); |
10 | $this->load->dbforge(); | |
11 | } | |
12 | ||
13 | function validation_login(){ | |
14 | // filter | |
15 | ||
16 | $username = $this->security->xss_clean( $this->input->post('username') ); | |
17 | ||
18 | $password = $this->security->xss_clean( $this->input->post('password') ); | |
19 | ||
20 | // seleksi data dari username dan password dan status aktif | |
21 | ||
22 | $this->db->where('user_name', $username); | |
23 | ||
24 | $this->db->where('user_password', $password); | |
25 | ||
26 | $this->db->where('status', '1'); | |
27 | ||
28 | $rs = $this->db->get('view_user_login'); | |
29 | ||
30 | // get result row, prepare and create session | |
31 | ||
32 | if ( 1 == $rs->num_rows ) { | |
33 | ||
34 | $data = $rs->row(); | |
35 | ||
36 | $vars = array( | |
37 | ||
38 | "no" => $data->no, | |
39 | ||
40 | "id_role" => $data->id_role, // pkey to role | |
41 | ||
42 | "role_name" => $data->role_name, | |
43 | ||
44 | "user_name" => $data->user_name, | |
45 | ||
46 | "no_emp" => $data->no_emp, // unique to employee | |
47 | ||
48 | "name" => $data->name, | |
49 | ||
50 | "validated" => true | |
51 | ||
52 | ); | |
53 | ||
54 | $this->session->set_userdata( $vars ); | |
55 | ||
56 | return true; | |
57 | ||
58 | } | |
59 | - | } else { |
59 | + | else { |
60 | ||
61 | return false; | |
62 | ||
63 | } | |
64 | ||
65 | } | |
66 | ||
67 | } |