This video learn how to login using Codeigniter.
1- Create Database "logindb" and then create table
CREATE TABLE tbl_users (
userid tinyint(4) NOT NULL AUTO_INCREMENT,
username varchar(10) NOT NULL,
password varchar(100) NOT NULL,
PRIMARY KEY (userid)
)ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
2- Insert New Row
INSERT INTO tbl_users(username,password) VALUES('demo',md5('test'));
3- Download Codeigniter
- Create web directory name or web root 'loginwebsite'
- Extract codeigniter to web root 'loginwebsite'
application
system
index.php
4- Update application/config/database.php
$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'logindb';
5- Update $route['default_controller'] = "loginwebsite"; in application/config/routes.php
6- Update application/config/autoload.php
$autoload['libraries'] = array('database','session');
$autoload['helper'] = array('url');
7- Update encryption_key in application/config/config.php
$config['encryption_key'] = 'APANtByIGI1BpVXZTJgcsAG8GZl8pdwwa84'
8- Create User Model in application/models/user.php
<?php
Class User extends CI_Model
{
function login($username, $password)
{
$this -> db -> select('userid, username, password');
$this -> db -> from('tbl_users');
$this -> db -> where('username', $username);
$this -> db -> where('password', MD5($password));
$this -> db -> limit(1);
$query = $this -> db -> get();
if($query -> num_rows() == 1)
{
return $query->result();
}
else
{
return false;
}
}
}
?>
9- Create Login Controller in application/controllers/login.php
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Login extends CI_Controller {
function __construct()
{
parent::__construct();
}
function index()
{
$this->load->helper(array('form'));
$this->load->view('login_view');
}
}
?>
10- Create Login View in application/views/login_view.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Simple Login with CodeIgniter</title>
</head>
<body>
<h1>Simple Login with CodeIgniter</h1>
<?php echo validation_errors(); ?>
<?php echo form_open('verifylogin'); ?>
<label for="username">Username:</label>
<input type="text" size="20" id="username" name="username"/>
<br/>
<label for="password">Password:</label>
<input type="password" size="20" id="passowrd" name="password"/>
<br/>
<input type="submit" value="Login"/>
</form>
</body>
</html>
11- Create VerifyLogin Controller in application/controllers/verifylogin.php
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class VerifyLogin extends CI_Controller {
function __construct()
{
parent::__construct();
$this->load->model('user','',TRUE);
}
function index()
{
//This method will have the credentials validation
$this->load->library('form_validation');
$this->form_validation->set_rules('username', 'Username', 'trim|required|xss_clean');
$this->form_validation->set_rules('password', 'Password', 'trim|required|xss_clean|callback_check_database');
if($this->form_validation->run() == FALSE)
{
//Field validation failed. User redirected to login page
$this->load->view('login_view');
}
else
{
//Go to private area
redirect('home', 'refresh');
}
}
function check_database($password)
{
//Field validation succeeded. Validate against database
$username = $this->input->post('username');
//query the database
$result = $this->user->login($username, $password);
if($result)
{
$sess_array = array();
foreach($result as $row)
{
$sess_array = array(
'userid' => $row->userid,
'username' => $row->username
);
$this->session->set_userdata('logged_in', $sess_array);
}
return TRUE;
}
else
{
$this->form_validation->set_message('check_database', 'Invalid username or password');
return false;
}
}
}
?>
12- Create Home Controller in application/controllers/home.php
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
session_start(); //we need to call PHP's session object to access it through CI
class Home extends CI_Controller {
function __construct()
{
parent::__construct();
}
function index()
{
if($this->session->userdata('logged_in'))
{
$session_data = $this->session->userdata('logged_in');
$data['username'] = $session_data['username'];
$this->load->view('home_view', $data);
}
else
{
//If no session, redirect to login page
redirect('login', 'refresh');
}
}
function logout()
{
$this->session->unset_userdata('logged_in');
session_destroy();
redirect('home', 'refresh');
}
}
?>
13- Create Home View in application/views/home_view.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Simple Login with CodeIgniter - Private Area</title>
</head>
<body>
<h1>Home</h1>
<h2>Welcome <?php echo $username; ?>!</h2>
<a href="home/logout">Logout</a>
</body>
</html>
14- Demo
http://localhost/loginwebsite/index.php/login
15- Source
http://downloads.ziddu.com/download/24382218/loginwebsite.zip.html
Read more blog
http://www.freeonlinelecture.com
Follow Us with Facebook
https://www.facebook.com/pages/PHP-Tutorial/782239958529506
1- Create Database "logindb" and then create table
CREATE TABLE tbl_users (
userid tinyint(4) NOT NULL AUTO_INCREMENT,
username varchar(10) NOT NULL,
password varchar(100) NOT NULL,
PRIMARY KEY (userid)
)ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
2- Insert New Row
INSERT INTO tbl_users(username,password) VALUES('demo',md5('test'));
3- Download Codeigniter
- Create web directory name or web root 'loginwebsite'
- Extract codeigniter to web root 'loginwebsite'
application
system
index.php
4- Update application/config/database.php
$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'logindb';
5- Update $route['default_controller'] = "loginwebsite"; in application/config/routes.php
6- Update application/config/autoload.php
$autoload['libraries'] = array('database','session');
$autoload['helper'] = array('url');
7- Update encryption_key in application/config/config.php
$config['encryption_key'] = 'APANtByIGI1BpVXZTJgcsAG8GZl8pdwwa84'
8- Create User Model in application/models/user.php
<?php
Class User extends CI_Model
{
function login($username, $password)
{
$this -> db -> select('userid, username, password');
$this -> db -> from('tbl_users');
$this -> db -> where('username', $username);
$this -> db -> where('password', MD5($password));
$this -> db -> limit(1);
$query = $this -> db -> get();
if($query -> num_rows() == 1)
{
return $query->result();
}
else
{
return false;
}
}
}
?>
9- Create Login Controller in application/controllers/login.php
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Login extends CI_Controller {
function __construct()
{
parent::__construct();
}
function index()
{
$this->load->helper(array('form'));
$this->load->view('login_view');
}
}
?>
10- Create Login View in application/views/login_view.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Simple Login with CodeIgniter</title>
</head>
<body>
<h1>Simple Login with CodeIgniter</h1>
<?php echo validation_errors(); ?>
<?php echo form_open('verifylogin'); ?>
<label for="username">Username:</label>
<input type="text" size="20" id="username" name="username"/>
<br/>
<label for="password">Password:</label>
<input type="password" size="20" id="passowrd" name="password"/>
<br/>
<input type="submit" value="Login"/>
</form>
</body>
</html>
11- Create VerifyLogin Controller in application/controllers/verifylogin.php
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class VerifyLogin extends CI_Controller {
function __construct()
{
parent::__construct();
$this->load->model('user','',TRUE);
}
function index()
{
//This method will have the credentials validation
$this->load->library('form_validation');
$this->form_validation->set_rules('username', 'Username', 'trim|required|xss_clean');
$this->form_validation->set_rules('password', 'Password', 'trim|required|xss_clean|callback_check_database');
if($this->form_validation->run() == FALSE)
{
//Field validation failed. User redirected to login page
$this->load->view('login_view');
}
else
{
//Go to private area
redirect('home', 'refresh');
}
}
function check_database($password)
{
//Field validation succeeded. Validate against database
$username = $this->input->post('username');
//query the database
$result = $this->user->login($username, $password);
if($result)
{
$sess_array = array();
foreach($result as $row)
{
$sess_array = array(
'userid' => $row->userid,
'username' => $row->username
);
$this->session->set_userdata('logged_in', $sess_array);
}
return TRUE;
}
else
{
$this->form_validation->set_message('check_database', 'Invalid username or password');
return false;
}
}
}
?>
12- Create Home Controller in application/controllers/home.php
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
session_start(); //we need to call PHP's session object to access it through CI
class Home extends CI_Controller {
function __construct()
{
parent::__construct();
}
function index()
{
if($this->session->userdata('logged_in'))
{
$session_data = $this->session->userdata('logged_in');
$data['username'] = $session_data['username'];
$this->load->view('home_view', $data);
}
else
{
//If no session, redirect to login page
redirect('login', 'refresh');
}
}
function logout()
{
$this->session->unset_userdata('logged_in');
session_destroy();
redirect('home', 'refresh');
}
}
?>
13- Create Home View in application/views/home_view.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Simple Login with CodeIgniter - Private Area</title>
</head>
<body>
<h1>Home</h1>
<h2>Welcome <?php echo $username; ?>!</h2>
<a href="home/logout">Logout</a>
</body>
</html>
14- Demo
http://localhost/loginwebsite/index.php/login
15- Source
http://downloads.ziddu.com/download/24382218/loginwebsite.zip.html
Read more blog
http://www.freeonlinelecture.com
Follow Us with Facebook
https://www.facebook.com/pages/PHP-Tutorial/782239958529506
