complete login system in codeigniter php

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’, ‘[email protected]’, ‘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 : [email protected] 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 ) 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.

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

$route[‘default_controller’] = ‘home’;

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

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”

Login to your account

   <?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>
						 

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

If you Want Seo friendly Url or Remove index.php from the codeigniter url then Read following article.

/blog/how-to-remove-index-php-from-codeigniter-url/