Login using session with user role

Controller:
function login($msg = NULL){
$data['msg'] = $msg;
$this->load->view('head');
$this->load->view('loginform',$data);
$this->load->view('footer');
}
function process(){
if($this->input->post('Submit')){
echo $username=$this->input->post('username');
echo $pws=$this->input->post('pws');
$result=$this->Login_model->process($username,$pws);
if($result){
redirect('/Home', 'refresh');
}else{
$msg="<font color=red>Invalid username and/or password.</font><br />";
$this->login($msg);
}
}
}
function logout(){
$this->session->unset_userdata($array_items);
redirect('/Login/login', 'refresh');
}


View:

<form action="<?php echo base_url();?>/login/process" method="post">
  <div class="form-group">
    <label for="email">Email address:</label>
    <input type="email" class="form-control" name="username" >
  </div>
  <div class="form-group">
    <label for="pwd">Password:</label>
    <input type="password" class="form-control" name="pws" >
  </div>
  <input type="submit" class="form-control btn btn-danger" name="Submit" value="Submit">
</form>


Model:

function process($username,$pws){

$this->db->SELECT('*');
$this->db->FROM('`user_login`');
$this->db->WHERE('`user_name`',$username);
$this->db->WHERE('`user_pwd`',$pws);
$this->db->WHERE('`user_active`=1');
$query=$this->db->get();
if($query->num_rows() == 1){
$row=$query->row();
$data=array(
'username'=>$row->user_name,
'user_role'=>$row->user_role
);
//print_r($data);die;
$this->session->set_userdata($data);
return true;
}

}

Database:


CREATE TABLE `user_login` (
  `user_id` int(11) NOT NULL,
  `user_name` varchar(250) NOT NULL,
  `user_pwd` varchar(250) NOT NULL,
  `user_role` int(11) NOT NULL,
  `user_active` int(11) NOT NULL,
  `user_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `user_login`
  ADD PRIMARY KEY (`user_id`);

ALTER TABLE `user_login`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;



use session data in other page:
echo $name = $this->session->userdata('username');
echo $user_role = $this->session->userdata('user_role');


Comments

Popular posts from this blog

Displaying a flash message after redirect in Codeigniter

What is required for it startup company ?

how to export html data to pdf in angularjs and javascript