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

how to export html data to pdf in angularjs and javascript

Push Notification in Android using Firebase (FCM) and PHP

add more button new row using javascript