codeigniter Archives - W3school.info

Hi Geeks,
I am showing you “complete login system in codeigniter php”. In this example i’ll show you a simple login example with srored procedure in codeigniter framework.
Step 1. Install Codeigniter and configure database.php in application/config folder
Step2. create a table in your databse by following sql statement

--create table staement--
CREATE TABLE IF NOT EXISTS `webadmin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT '0',
  `is_delete` int(11) NOT NULL DEFAULT '0',
  `added_date` datetime NOT NULL,
  `modified_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `address` varchar(255) NOT NULL,
  `admin_ip` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `webadmin`
--

INSERT INTO `webadmin` (`id`, `name`, `email`, `password`, `website`, `is_active`, `is_delete`, `added_date`, `modified_date`, `address`, `admin_ip`) VALUES
(1, 'Jeetendra', 'jeetu91.singh@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 'https://www.w3school.info', 1, 0, '2015-11-18 08:24:49', '2015-11-18 11:58:01', 'JAIPUR', '192.256.1.1');

--create table staement--

CREATE TABLE IF NOT EXISTS `webadmin` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(255) NOT NULL,

`email` varchar(255) NOT NULL,

`password` varchar(255) NOT NULL,

`website` varchar(255) NOT NULL,

`is_active` int(11) NOT NULL DEFAULT '0',

`is_delete` int(11) NOT NULL DEFAULT '0',

`added_date` datetime NOT NULL,

`modified_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,

`address` varchar(255) NOT NULL,

`admin_ip` varchar(255) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

-- Dumping data for table `webadmin`

INSERT INTO `webadmin` (`id`, `name`, `email`, `password`, `website`, `is_active`, `is_delete`, `added_date`, `modified_date`, `address`, `admin_ip`) VALUES

(1, 'Jeetendra', 'jeetu91.singh@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 'https://www.w3school.info', 1, 0, '2015-11-18 08:24:49', '2015-11-18 11:58:01', 'JAIPUR', '192.256.1.1');

Note : By default in sql dump we have following login details set
Login Credentials:
email : jeetu91.singh@gmail.com
password:123456
//in sql dump file password saved in md5 encryted.

Step 3.Now Create a Procedure named LOGIN_AUTH by executing following sql statement in phpmyadmin by select your db and in sql execute area.

CREATE PROCEDURE `LOGIN_AUTH`(IN `_email` VARCHAR(255) CHARSET utf8, IN `_password` VARCHAR(255) CHARSET utf8) NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER SELECT * FROM `webadmin` WHERE (`is_active`='1' and `is_delete`='0') and ( `email`= _email and `password` = _password )

1	CREATE PROCEDURE `LOGIN_AUTH`(IN `_email` VARCHAR(255) CHARSET utf8, IN `_password` VARCHAR(255) CHARSET utf8) NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER SELECT * FROM `webadmin` WHERE (`is_active`='1' and `is_delete`='0') and ( `email`= _email and `password` = _password )

In this satement we have created a stored procedure which accepts 2 parameters varchar email and password, and in procedure body there is a select match sql statement that verify that user is having details or exists with these details.

Step 4. Create a Model named “Common_model.php” in your model folder by putting following code.

<?php
class Common_Model  extends CI_Model  {
 
	function __construct()
    {
        parent::__construct();
    }
	 
	function exec_proc($proc_name,$data=array(),$only_exec=0)
	{
		 
        try 
		{
            $this->db->reconnect();
            $sql = "CALL `".$proc_name."`";
			$indexes=array();
			foreach($data as $c)
			{
			  $indexes[]="?";
			}
			if(count($indexes)>0)
			 $sql.= "(".implode(",",$indexes).")";
			else
			 $sql.= "()";
		 
			$result = $this->db->query($sql,$data);
			
			if($only_exec==0)
			$ret = $result->result_array();
			else
			$ret = $result;
        
		$this->db->close();
        } 
		catch (Exception $e) 
		{
            echo $e->getMessage();
        }
		
		return $ret;

    }

    

}
?>

<?php

class Common_Model extends CI_Model {

function __construct()

{

parent::__construct();

}

function exec_proc($proc_name,$data=array(),$only_exec=0)

{

try

{

$this->db->reconnect();

$sql = "CALL `".$proc_name."`";

$indexes=array();

foreach($data as $c)

{

$indexes[]="?";

}

if(count($indexes)>0)

$sql.= "(".implode(",",$indexes).")";

else

$sql.= "()";

$result = $this->db->query($sql,$data);

if($only_exec==0)

$ret = $result->result_array();

else

$ret = $result;

$this->db->close();

}

catch (Exception $e)

{

echo $e->getMessage();

}

return $ret;

}

Note : Make home controller as default controller in application/config/routes.php

$route['default_controller'] = 'home';

1	$route['default_controller'] = 'home';

Step 5. Now create a Controller named “Home.php” controller in you Controller folder with following code.

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

class Home   extends CI_Controller {
 
 public $load_view;
 public $data;
	public function __construct()
	{
		parent::__construct();

		$this->load->database();
		$this->load->helper('url');
		$this->load->model('Common_model');

	}
	public function index()
	{ 
$this->check_alreadylogin();//send to dashboard if session data is exist or user is already logged in or logged information is saved in session.

		$this->load->library('form_validation');
		
		$config = array(
			array(
				'field'	=> 'user_username',
				'label'	=> 'Email',
				'rules'	=> 'trim|required|valid_email'
			),
			array(
				'field' => 'user_password',
				'label' => 'Password',
				'rules'	=> 'trim|required'
			)
		);
		
		$this->form_validation->set_rules($config);
		 
		if($this->form_validation->run() == FALSE)
		{ 
		  $this->data['page_title']="Login Controller";
		  $this->load->view('login');
		 
			
		}else{  
			$username = trim($this->input->post('user_username'));
			$password = md5(trim($this->input->post('user_password')));
			 
			$data[0]=$username;
			$data[1]=$password;
			$this->_authenticate($data);
			
		}
		
		
	}
	 
 
	public function _authenticate($data)
	{
		$retRes=$this->Common_model->exec_proc("LOGIN_AUTH",$data);
		 
		if(!empty($retRes)){
				$this->session->set_userdata('webadmin_session',$retRes[0]);
				$this->webadmin_session = $this->session->userdata('webadmin_session');
				redirect('/dashboard');
			}else{
				$this->session->set_flashdata('fail_msg','You don\'t have permission to access this Admin panel.');
				redirect('/');
			}
	}
public function checklogin()
	{
		$is_login=$this->session->userdata('webadmin_session');
		if(!isset($is_login['id']) || $is_login['id'] == 0 || $is_login['id'] == ""   )
		{
			$this->session->unset_userdata('webadmin_session');
			redirect('/');
		}
	}
	public function check_alreadylogin()
	{
		$already_login=$this->session->userdata('webadmin_session');
		if(isset($already_login['id']) && $already_login['id'] > 0)
		{
			redirect('/dashboard');
		}
	}
                 public function dashboard()
	{ 
  $this->checklogin(); //use to logged out if use is not logged in or session has been out
$UserData=$this->session->userdata('webadmin_session'); //retrieve user data from session

$this->data['logged_username']=$UserData['name'];  //assign the user name to the view for showing welcome username
                   $this->load->view('dashboard');
               }

	public function logout()
	{ 
			$this->session->unset_userdata('webadmin_session');
			redirect('/');
	}
}

?>

100

101

102

103

104

<?php

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

class Home extends CI_Controller {

public $load_view;

public $data;

public function __construct()

{

parent::__construct();

$this->load->database();

$this->load->helper('url');

$this->load->model('Common_model');

}

public function index()

{

$this->check_alreadylogin();//send to dashboard if session data is exist or user is already logged in or logged information is saved in session.

$this->load->library('form_validation');

$config = array(

array(

'field' => 'user_username',

'label' => 'Email',

'rules' => 'trim|required|valid_email'

array(

'field' => 'user_password',

'label' => 'Password',

'rules' => 'trim|required'

)

);

$this->form_validation->set_rules($config);

if($this->form_validation->run() == FALSE)

{

$this->data['page_title']="Login Controller";

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

}else{

$username = trim($this->input->post('user_username'));

$password = md5(trim($this->input->post('user_password')));

$data[0]=$username;

$data[1]=$password;

$this->_authenticate($data);

}

public function _authenticate($data)

{

$retRes=$this->Common_model->exec_proc("LOGIN_AUTH",$data);

if(!empty($retRes)){

$this->session->set_userdata('webadmin_session',$retRes[0]);

$this->webadmin_session = $this->session->userdata('webadmin_session');

redirect('/dashboard');

}else{

$this->session->set_flashdata('fail_msg','You don\'t have permission to access this Admin panel.');

redirect('/');

}

public function checklogin()

{

$is_login=$this->session->userdata('webadmin_session');

if(!isset($is_login['id']) || $is_login['id'] == 0 || $is_login['id'] == "" )

{

$this->session->unset_userdata('webadmin_session');

redirect('/');

}

public function check_alreadylogin()

{

$already_login=$this->session->userdata('webadmin_session');

if(isset($already_login['id']) && $already_login['id'] > 0)

{

redirect('/dashboard');

}

public function dashboard()

{

$this->checklogin(); //use to logged out if use is not logged in or session has been out

$UserData=$this->session->userdata('webadmin_session'); //retrieve user data from session

$this->data['logged_username']=$UserData['name']; //assign the user name to the view for showing welcome username

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

}

public function logout()

{

$this->session->unset_userdata('webadmin_session');

redirect('/');

}

In this Controller index function we create a login logic and called the model’s procedure execution function where we passes 2nd parameter as a data in array form with email and password respectively indexes.
Now model picks the data array and set a order and prepare a stored procedure statement to execute.
First parameter is procedure name,second is a order data array required by procedure, and third parameter if we require a data to be return by model then we have to pass third parameter with value 1 .
Note: third parameter is optional. by default it doesn’t return any data it just receive 0 in third parameter by default.

Step 6. Now we have create a View for loading the Login form with name “login.php”

<h2>Login to your account</h2>
					<form class="form-horizontal" method="post">
					      
	   
	   <?php  
	   if($this->session->flashdata('fail_msg')!="")
	   {
		   echo '<p style="colr:red;">';
		   echo $this->session->flashdata('fail_msg');
		   echo '</p>';
	   }
	   
	    
	   ?>
	 
						<fieldset>
							
							<div class="input-prepend" title="Username">
								<span class="add-on"><i class="halflings-icon user"></i></span>
								<input class="input-large span10" name="user_username" value="<?php echo set_value('user_username'); ?>" id="user_username" type="email" placeholder="type email"/>
								<?php echo form_error('user_username','<p class="alert alert-error">','</p>'); ?>
							</div>
							<div class="clearfix"></div>

							<div class="input-prepend" title="Password">
								<span class="add-on"><i class="halflings-icon lock"></i></span>
								<input class="input-large span10" name="user_password" value="<?php echo set_value('user_password'); ?>" id="user_password" type="password" placeholder="type password"/>
								<?php echo form_error('user_password','<p class="alert alert-error">','</p>'); ?>
								
								
							 
						
						
							</div>
							<div class="clearfix"></div>
							 

<input  type="submit" value="Login" name="login_button"   />
													<div class="clearfix"></div>
</fieldset>
</form>

<h2>Login to your account</h2>

<?php

if($this->session->flashdata('fail_msg')!="")

{

echo '<p style="colr:red;">';

echo $this->session->flashdata('fail_msg');

echo '</p>';

}

<input class="input-large span10" name="user_username" value="<?php echo set_value('user_username'); ?>" id="user_username" type="email" placeholder="type email"/>

<?php echo form_error('user_username','<p class="alert alert-error">','</p>'); ?>

</div>

<input class="input-large span10" name="user_password" value="<?php echo set_value('user_password'); ?>" id="user_password" type="password" placeholder="type password"/>

<?php echo form_error('user_password','<p class="alert alert-error">','</p>'); ?>

</div>

</fieldset>

</form>

Step 7. create Dashboard View in views folder named dashboard.php with following code

<table>
<tr>
<td>Welcome <?php echo $logged_username; ?></td><td><a href="<?php echo $this->config->base_url(); ?>index/logout">LOGOUT</a></td>
</tr>
<tr>
<td colspan="2">Now you are logged are in and this is dashboard view  </td>
</tr>
<tr>
<td colspan="2">You cannot directly inter in this area,want to try on unlogged session ? just copy the current url from url bar and logout out by clicking on log out link in top.  </td>
</tr><tr>
<td colspan="2">Now Paste the url in browser again it will automatic redirect to login form.  </td>
</tr>
</table>

<table>

<tr>

<td>Welcome <?php echo $logged_username; ?></td><td><a href="<?php echo $this->config->base_url(); ?>index/logout">LOGOUT</a></td>

</tr>

<tr>

<td colspan="2">Now you are logged are in and this is dashboard view </td>

</tr>

<tr>

<td colspan="2">You cannot directly inter in this area,want to try on unlogged session ? just copy the current url from url bar and logout out by clicking on log out link in top. </td>

</tr><tr>

<td colspan="2">Now Paste the url in browser again it will automatic redirect to login form. </td>

</tr>

</table>

If you Want Seo friendly Url or Remove index.php from the codeigniter url then Read following article.
https://www.w3school.info/2015/10/20/how-to-remove-index-php-from-codeigniter-url/

Tag: codeigniter

How to remove index.php from Codeigniter url