4 * Class Users_model models user information from DB
10 class Users_model extends CI_Model {
13 public function __construct()
15 parent::__construct();
17 if ($this->db === NULL)
19 $this->load->library('singleton_db');
20 $this->db = $this->singleton_db->connect();
25 * Check authentication credentials. $username can be username or e-mail.
27 * @param string $username
28 * @param string $password
30 public function login($username, $password)
32 $this->load->helper('email');
34 // User logs with e-mail address.
35 if (! valid_email($username))
36 $cond_user = "username = '$username'";
38 $cond_user = "email = '$username'";
40 $enc_password = sha1($password);
42 // TODO select only required fields.
43 $query = $this->db->query("SELECT * FROM `users`
44 WHERE $cond_user AND password = '$enc_password'");
46 if ($query->num_rows() !== 1)
49 return $query->row_array();
53 /* End of file users_model.php */
54 /* Location: ./application/models/users_model.php */