php 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/

Here we will learn how to remove index.php from codeigniter url.

Each of codeigniter constructed url contains the value index.php and excluding root url. No url cannot be run without index.php

Assume a scenario , we have a website named www.myciportal.com

Where we didn’t remove the index.php from url and i have a category with following details

category name: techbuzz

So by default it’s url will create like following

default url : www.myciportal.com/index.php/techbuzz

it will not run like this way

www.myciportal.com/techbuzz

For make this possible we have to work on config and htaccess both and steps are following to achieve this task

If you are using mod_rewrite to remove the index.php in each url construct of codeigniter then you have to follow these steps:
Step 1: In CI Project root Folder of your project create a .HTACCESS file and place following code in it

RewriteEngine on
RewriteBase /myprojectname
RewriteRule ^(application|system|\.svn) index.php/$1 [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php/$1 [QSA,L]

RewriteEngine on

RewriteBase /myprojectname

RewriteRule ^(application|system|\.svn) index.php/$1 [L]

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule ^(.*)$ index.php/$1 [QSA,L]

Comments :: In above code myprojectname is passed with RewriteBase , which is the demo project name of our ci project,if you are running on main domain then Redirect base will be / only , or if you are running your project in any directory then you have to specify that name.
Now Step 2:
in your project >> application/config/config.php
Replace following line

$config['index_page'] = 'index.php';

1	$config['index_page'] = 'index.php';

with

$config['index_page'] = ''; //removed the index.php after htaccess done

1	$config['index_page'] = ''; //removed the index.php after htaccess done

Now you can run your Codeigniter project and you can see the index.php has been removed from every Controller Action

Tag: php

How to remove index.php from Codeigniter url

How to Make First PHP Program?

How to Install Xampp Server?

PHP Tutorial for Beginners – An Introduction