Login page (with database)

In earlier example, we learnt a simple login page with one single username and session.

Now we'll make it with more than one users using database. A sign in and login page will be there for users.

Following pages are made in this example.

In application/controllers

Main.php

In application/views

login_view.php
invalid.php
data.php
signin.php

In application/models

login_model.php

In the first page, you'll have the option for Login and Sign In.

On Login, if user has entered correct credentials matching to database then he will be directed to data.php page. But if he has entered wrong information then incorrect username/password message will appear.

We have named our CodeIgniter folder as login_db. And our table name is signup.

We need to do some basic settings in our login_db CodeIgniter folder.

Go to autoload.php file, and do the following settings.

In the above snpashot, we have loaded the libraries and helper.

In database.php file, fill your username and database name. Our database name is codeigniter.

Now, we?ll start the example.

We have made file Main.php in application/controllers folder,

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

class Main extends CI_Controller {

	public function index()
	{
		$this->login();
	}

	public function login()
	{
		$this->load->view('login_view');
	}

	public function signin()
	{
		$this->load->view('signin');
	}

	public function data()
	{
		if ($this->session->userdata('currently_logged_in')) 
		{
			$this->load->view('data');
		} else {
			redirect('Main/invalid');
		}
	}

	public function invalid()
	{
		$this->load->view('invalid');
	}

	public function login_action()
	{
		$this->load->helper('security');
		$this->load->library('form_validation');

		$this->form_validation->set_rules('username', 'Username:', 'required|trim|xss_clean|callback_validation');
		$this->form_validation->set_rules('password', 'Password:', 'required|trim');

		if ($this->form_validation->run()) 
		{
			$data = array(
				'username' => $this->input->post('username'),
				'currently_logged_in' => 1
				);	
					$this->session->set_userdata($data);
				redirect('Main/data');
		} 
		else {
			$this->load->view('login_view');
		}
	}

	public function signin_validation()
	{
		$this->load->library('form_validation');

		$this->form_validation->set_rules('username', 'Username', 'trim|xss_clean|is_unique[signup.username]');

		$this->form_validation->set_rules('password', 'Password', 'required|trim');

		$this->form_validation->set_rules('cpassword', 'Confirm Password', 'required|trim|matches[password]');

		$this->form_validation->set_message('is_unique', 'username already exists');

	if ($this->form_validation->run())
		{
			echo "Welcome, you are logged in.";
		 } 
			else {
			
			$this->load->view('signin');
		}
	}

	public function validation()
	{
		$this->load->model('login_model');

		if ($this->login_model->log_in_correctly())
		{

			return true;
		} else {
			$this->form_validation->set_message('validation', 'Incorrect username/password.');
			return false;
		}
	}

	public function logout()
	{
		$this->session->sess_destroy();
		redirect('Main/login');
	}

}
?>

In application/views folder, login_view.php file is made.

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="utf-8">
	<title>Login Page</title>
</head>
<body>
	<h1>Login</h1>
	
	<?php

	echo form_open('Main/login_action');

	echo validation_errors();

	echo "<p>Username: ";
	echo form_input('username', $this->input->post('username'));
	echo "</p>";

	echo "<p>Password: ";
	echo form_password('password');
	echo "</p>";

	echo "</p>";
	echo form_submit('login_submit', 'Login');
	echo "</p>";

 	echo form_close();

 	?>

 	<a href='<?php echo base_url()."index.php/Main/signin"; ?>'>Sign In</a>	
</body>
</html>

In application/views folder, data.php file is made.

<!DOCTYPE html>
<html>
<head>
	<title></title>
</head>
<body>
	<h1>Welcome, You are successfully logged in.</h1>

	<?php
	echo "<pre>";
	echo print_r($this->session->all_userdata());
	echo "</pre>";
	?>

	<a href='<?php echo base_url()."index.php/Main/logout"; ?>'>Logout</a>

</body>
</html>

In application/views folder, signin.php file is made.

<!DOCTYPE html>
<html>
<head>
	<title>Sign Up Page</title>
</head>
<body>
	<h1>Sign In</h1>

	<?php

	echo form_open('Main/signin_validation');

	echo validation_errors();

	echo "<p>Username:";
	echo form_input('email');
	echo "</p>";

	echo "<p>Password:";
	echo form_password('password');
	echo "</p>";

	echo "<p>Confirm Password:";
	echo form_password('cpassword');
	echo "</p>";

	echo "<p>";
	echo form_submit('signin_submit', 'Sign In');
	echo "</p>";

	echo form_close();

	?>

</body>
</html>

In application/views folder, invalid.php file is made.

<!DOCTYPE html>
<html>
<head>
	<title>Invalid Page</title>
</head>
<body>
	<h1>Sorry, You don't have access to this page.</h1>

	<a href='<?php echo base_url()."Main/login"; ?>'>Login Again</a>

</body>
</html>

In application/models folder, login_model.php file is made.

<?php

class Login_model extends CI_Model {

	public function log_in_correctly() {

		$this->db->where('username', $this->input->post('username'));
		$this->db->where('password', $this->input->post('password'));
		$query = $this->db->get('signup');

		if ($query->num_rows() == 1)
		{
			return true;
		} else {
			return false;
		}

	}

	
}
?>

On entering the URL, http://localhost/login_db/index.php/Main/

Following page will appear.