model_login

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class App_Model extends CI_Model {



	//query login
	public function getLoginData($usr,$psw)
	{
		$u = mysql_real_escape_string($usr);
		$p = md5(mysql_real_escape_string($psw.$this->config->item("key_login")));
		$q_cek_login = $this->db->get_where('user', array('u_nama' => $u, 'u_password' => $p));
		if(count($q_cek_login->result())>0)
		{
			foreach($q_cek_login->result() as $qck)
			{
				if($qck->u_level='user'){
				foreach($q_cek_login->result() as $qad)
				{
					$sess_data['user_in'] = 'yesGetMeLogin';
					$sess_data['username'] = $qad->u_nama;
					$this->session->set_userdata($sess_data);
				}
				header('location:'.base_url().'app_user');

			}else if ($qck->u_level='admin'){
				foreach($q_cek_login->result() as $qcd)
					{
						$sess_data['admin_in'] = 'yesGetMeLogin';
						$sess_data['username'] = $qcd->u_nama;
						$this->session->set_userdata($sess_data);
					}
				header('location:'.base_url().'app_admin');
			}

			}
		}
		else
		{
			$this->session->set_flashdata('result_login', 'Username atau Password yang anda masukkan salah.');
			header('location:'.base_url().'app_front/login');
		}
	}