how to get userid after login codeigniter

Question

I have successfully created a registration and login system. I have used username and password in the login form and i want to put the userid in other form like hidden field

login model cliente.php:

public function login($username,$password){
    $this->db->select('IdCliente');
    $this->db->where('LoginCliente',$username);
    $this->db->where('PassCliente',$password);
    $q = $this->db->get('clientes');

    if($q->num_rows()>0){
        return true;
    }else{
        return false;
    }

login controller login.php:

   public function index(){
    if($this->session->userdata('LoginCliente')){
        redirect('profile');
    }
    if(isset($_POST['password'])){
        $this->load->model('cliente');
        if($this->cliente->loginemp($_POST['username'],$_POST['password'])){
            $this->session->set_userdata('Login',$_POST['username']);
            redirect('PanelIndex');
        }elseif(isset($_POST['password'])){
        $this->load->model('cliente');
        if($this->cliente->login($_POST['username'],$_POST['password'])){
            $this->session->set_userdata('LoginCliente',$_POST['username']);
            $this->session->userdata('IdCliente');
            redirect('profile');
        }else{
            redirect('login');              
        }
    }

    }

    $this->load->view('inicio/loginview');  

}

profile.php

public function index()
{


         $this->load->view("/clientes/clienteindex");

}

Answer 1

If you want to IdCliente you need to return it first from the login function.

public function login($username,$password){
    $this->db->select('IdCliente,LoginCliente');
    $this->db->where('LoginCliente',$username);
    $this->db->where('PassCliente',$password);
    $q = $this->db->get('clientes');

    if($q->num_rows()>0){
        return $q->row_array();
    }else{
        return false;
    }
}

Now In Index Function:

$session_data = $this->cliente->login($_POST['username'],$_POST['password'])
if(isset($session_data) && !empty($session_data){            
        $this->session->userdata('session_data',$session_data);
        redirect('profile');
 }

At the Profile(at the View):

$session_data = $this->session->userdata('session_data');
    $IdCliente= $session_data['IdCliente'];
    $LoginCliente= $session_data['LoginCliente'];

Answer 2

Create Simple_login.php file from your CI libraries folder and put this code.

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

/******************
* SHAHBLOGGER.COM*
******************/

class Simple_login {

   // SET SUPER GLOBAL
   var $CI = NULL;

   /**
    * Class constructor
    *
    * @return   void
    */
   public function __construct() {
       $this->CI =& get_instance();
   }


   public function login($email, $password, $referer) {

       //check username and password
       $query = $this->CI->db->get_where('clientes',array('LoginCliente'=>$username,'PassCliente' => $password)); // better use md5($password)

       if($query->num_rows() == 1) {
           //let start query

           $row  = $query;
           $user = $row->row();
           $id   = $user->IdCliente;


           //set session user

           $this->CI->session->set_userdata('id', $id);

           redirect($referer);

       }else{

           //redirect them to you login page
           redirect(site_url('login'));
       }
        return false;
    }



   /* check If They're login. If yes, set userdata */
   public function check_login() {

       //check session id set or not set. if not set, they're not login
       if($this->CI->session->userdata('id') == '') {


           //they're not login so redirect them to login page
           redirect(site_url('login'));

       } 
   }



   // Unset session data
   public function logout() {   
       $this->CI->session->unset_userdata('id');
       redirect(site_url('login'));
   }
}

then modify your controller

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

 class Login extends CI_Controller { //<<-- change 'Login' to your own class base on your controller file name 

     public function index() {

         // Fungsi Login
         $valid = $this->form_validation;
         $username= $this->input->post('username');
         $password = $this->input->post('password');
         $referer = $_SERVER['HTTP_REFERER'];// change where you want user redirect after success login
         $valid->set_rules('username','Username','required');
         $valid->set_rules('password','Password','required');


         if($valid->run()) {

             $this->simple_login->login($username,$password, $referer);
         }
         // End login

           $this->load->view('you_login_view');

     }

     public function logout(){
         $this->simple_login->logout();
     }
 }

1. makesure activated Codeigniter Autoload features. Follow this link

2. to call id of login user use this $this->session->userdata('id');

3. to make page only can access by login user user, paste this at controller $this->simple_login->check_login();

Updated: Base on comment below. I've changed Query to modified Query (Codeigniter Active Record) to avoid SQL Injection