Course Content
Introduction to CodeIgniter
CodeIgniter is a powerful PHP framework built for developers who need a simple and elegant toolkit to create full-featured web applications.
0/3
MVC (Model-View-Controller)
MVC stands for Model-View-Controller. MVC is an application design model consisting of three interconnected parts. They include the model (data), the view (user interface), and the controller (processes that handle input).
0/6
Sessions
The Session class allows you to maintain a user’s "state" and track their activity while they browse your site.
0/1
URI Routing
There is a one-to-one relationship between a URL string and its corresponding controller class/method. The segments in a URI normally follow this pattern:
0/1
Forms and Input
Forms provide a way for users to interact with the application and submit data.
0/1
Composer
Composer is dependency manager in PHP. it allows you to declare the libraries your project depends on and it will manage (install/update) them for you.
0/1
Security
You can enable CSRF protection by modifying your application/config/config.php file
0/1
Working with Database
Like any other framework, we need to interact with the database very often and CodeIgniter makes this job easy for us. It provides a rich set of functionalities to interact with the database.
0/5
DataTable
DataTables is a table enhancing plug-in for the jQuery Javascript library that helps in adding sorting, paging, and filtering abilities to plain HTML tables with minimal effort. The main goal is to enhance the accessibility of data in normal HTML tables.
0/1
Spreadsheet
PhpSpreadsheet is a PHP library for reading and writing spreadsheet files. Importing Excel and CSV into MySQL help to save the user time and avoid repetitive work.
0/1
Payment Gateway
Razorpay and PayTM Payment Gateway
0/2
Chatbot
WhatsApp Chatbot and Telegram Chatbot
0/2
CodeIgniter 3
About Lesson

In this article, we will discuss, How to create a Login with OTP in MySQL database using the CodeIgniter.

1. Create MySQL Table user_info

CREATE TABLE `user_info` ( 
`id` INT(10) NOT NULL AUTO_INCREMENT , 
`name` VARCHAR(255) NOT NULL , 
`mobile` VARCHAR(255) NOT NULL , 
`otp` VARCHAR(255) NOT NULL , 
PRIMARY KEY (`id`)
) ENGINE = InnoDB;

2. Create a controller file Signin.php in the applications/controllers/ directory.

class Signin extends CI_Controller {

	public function __construct() {
		parent::__construct();
		$this->load->library('session');
		$this->load->model('Signin_model');
	}

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

	public function login() {
		$mobile		= $this->input->post('mobile');
		
		$user 		= $this->login_model->check_mobile($mobile);

		if($user) {

			// Generate OTP
			$otp = $this->generate_otp();

			$data = [
				'otp'	=> $otp,
			];

			// update otp in database
			$this->login_model->update_otp($mobile, $data);

			// send otp on mobile number
			$message = $otp." is your OTP. Do not share with anyone.";

			$this->send_sms($mobile, $message);

			$data['mobile'] = $mobile;
			$this->load->view('otp', $data);	

		} else {
			echo "Invalid mobile number";
		}
	}

	public function send_sms($phone, $body) {

		// Your authentication key
		$authKey 	= 'auth_key';

		// Multiple mobiles numbers separated by comma					
		// Sender ID,While using route4 sender id should be 6 characters long.
		$senderId 	= 'CXSTEC';

		// Your message to send, Add URL encoding here.
		$message 	= urlencode($body);

		//Define route 
		$route 		= 'trans';

		//Prepare you post parameters
		$postData 	= array(
			'authkey' 	=> $authKey,
			'mobiles' 	=> $phone,
			'message' 	=> $message,
			'sender' 	=> $senderId,
			'route' 	=> $route
		);	

		//API URL
		$url 		= 'http://api.msg91.com/api/sendhttp.php';	

		$ch = curl_init();
		curl_setopt_array($ch, array(
			CURLOPT_URL 			=> $url,
			CURLOPT_RETURNTRANSFER		=> true,
			CURLOPT_POST 			=> true,
			CURLOPT_POSTFIELDS 		=> $postData
			));		

		//Ignore SSL certificate verification
		curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
		curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);

		//get response
		$output = curl_exec($ch);	
				
		curl_close($ch);
	}

	public function generate_otp() {
		$OTP 	=	rand(1,9);
		$OTP 	.=	rand(0,9);
		$OTP 	.=	rand(0,9);
		$OTP 	.=	rand(0,9);
		$OTP 	.=	rand(0,9);
		$OTP 	.=	rand(0,9);
		return $OTP;
	}

	public function verify() {
		$mobile		= $this->input->post('mobile');
		$otp		= $this->input->post('otp');

		// check for otp 
		$user = $this->login_model->verify($mobile, $otp);
		if($user) {
			$this->session->set_userdata($user);
			redirect('user/dashboard');
		} else {
			echo "Invalid OTP or Mobile number.";
		}
	}
}

3. Create a controller file User.php in the applications/controllers/ directory.

class User extends CI_Controller {

	public function __construct() {
		parent::__construct();
		$this->load->library('session');
		$this->load->model('Signin_model');
	}

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

	public function dashboard() {
		echo "you are successfully logged in";
	}

}

4. Create a model file Signin_model.php in the applications/models/ directory.

class Signin_model extends CI_Model {
	public function check_mobile($mobile) {
		$this->db->where(['mobile' => $mobile]);
		$query 	= $this->db->get('user_info');
		$result = $query->num_rows();
		return $result;
	}

	public function update_otp($mobile, $data) {
		return $this->db->update('user_info', $data, ["mobile"=>$mobile]);
	}

	public function verify($mobile, $otp) {
		$data = [];
		$this->db->where([mobile => $mobile, otp => $otp]);
		$query = $this->db->get('user_info');
		$result = $query->row();
		if($result) {
			$data = [
				'login_id' 	=> $result->id,
				'login_name' 	=> $result->name,
				'login_mobile' 	=> $result->mobile,
				'login_status' 	=> TRUE,
			];
		}
		return $data;
	}
}

5. Create a sign_in.php file in the applications/views/ directory.

<form method="post" 
	action="<?php echo base_url('signin/login') ?>">
	<table width="600" align="center" border="1" 
	cellspacing="5" cellpadding="5">
		<tr>
			<td width="230">Enter Mobile</td>
			<td width="329">
				<input type="text" name="mobile" />
			</td>
		</tr>
		<tr>
			<td colspan="2" align="center">
				<input type="submit" name="login" 
				value="Login" />
			</td>
		</tr>
	</table>
</form>

6. Create a verify.php file in the applications/views/ directory.

<form method="post" 
	action="<?php echo base_url('signin/verify') ?>">
	<table width="600" align="center" border="1" 
		cellspacing="5" cellpadding="5">
		<tr>
			<td width="230">Enter OTP</td>
			<td width="329">
				<input type="hidden" name="mobile" 
				value="<?php echo $mobile; ?>"  />
				<input type="password" name="otp" />
			</td>
		</tr>
		<tr>
			<td colspan="2" align="center">
				<input type="submit" name="verify" 
				value="Verify" />
			</td>
		</tr>
	</table>
</form>