Ajax Live Database Search with PHP CodeIgniter

-

 You can create a simple live database search functionality utilizing the Ajax and PHP, where the search results will be displayed as you start typing some character in search input box.

In order to use Select2, you must include the compiled JavaScript and CSS files on your website. There are multiple options for including these pre-compiled files, also known as a distribution, in your website or application.



Step 1: First you need to adding jQuery to your web pages

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>

Step 2: Also include the following lines of code in the <head> section of your page:

<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>

Step 3: Now you need to create one select box

<select name="search_bank_list" id="search_bank_list" style="width:200px;">
  <option value="">Select</option>
</select>

Step 4: In above code you must have to declare id=”search_bank_list” which is used for AJAX call as below.

<script>
$('#search_bank_list').select2({
ajax: { 
url:"https://app.shinerweb.com/index.php/bankcode/search_bank_list",
type: "post",
dataType: 'json',
delay: 250,
data: function (params) {
return {
searchTerm: params.term // search term
};
},
processResults: function (response) {
return {
results: response
};
},
cache: true
}  
});
</script>

Step 5: Create one function in controller file as below (* If you use simple PHP then you can ignore below steps and direct follow step 6.

function search_bank_list()
{
   $this->bankcode_model->search_bank_list();
}

Step 5: Create one function in model file as below.

function search_bank_list(){
	
	$searchTerm = $this->input->post('searchTerm');
	
	$query_data=$this->db->query("SELECT DISTINCT BANK, ID
	FROM BANK_IFSC_CODE
	WHERE DELETE_STATUS = 'N' AND BANK LIKE '%".$searchTerm."%'
	ORDER BY BRANCH ASC LIMIT 10;");
	
	$rowcount = $query_data->num_rows();
	if ($rowcount != 0) {
		$data = array();
		foreach ($query_data->result_array() as $row)
		{	   
		$data[] = array("id"=>$row['ID'], "text"=>$row['BANK']);
		}
	}
	
	echo json_encode($data);
	
	}


Comments

Post a Comment

Popular posts from this blog

Codeigniter Pro Level Tips and Tricks

-
  Codeigniter is my all time favorite php framework in my life. So here I want to share few codeigniter tips and tricks to you. feel free to ask any doubts about this tips. CodeIgniter is very easy me to install. It requires PHP version 4.3.2 or newer and one of the following databases: MySQL, MySQLi, MS SQL, ODBC, Oracle, Postgre or SQLite. Most people (myself included) use MySQL, but it’s good to know it supports some of the other big names. Best of all, CodeIgniter is available as freeware so there is no charge for  downloading  and using this software! Even though EllisLab Network offers the CodeIgniter software free of charge, they still provide user forums, a wiki and a bug tracker to help support the application and its community of users. If you are looking for the best way to streamline your PHP web development process, then CodeIgniter may be just the application that you need – I know it was for me. I have more than 7 years exp in codeigniter. Always try to fol...
Read more

Login with Facebook in CodeIgniter

-
  In the example CodeIgniter Facebook OAuth application, we will implement user authentication with   Facebook PHP Graph SDK   v5.x and store the user’s profile information in the MySQL database. Before you begin to integrate Facebook Login in CodeIgniter, take a look at the files structure of the application. codeigniter_facebook_login / ├── application / │ ├── config / │ │ └── facebook.php │ ├── controllers / │ │ └── User_authentication.php │ ├── libraries / │ │ └── Facebook.php │ ├── models / │ │ └── User.php │ ├── third_party / │ │ └── facebook-php-graph-sdk / │ └── views / │ └── user_authentication / │ └── index.php └── assets / ├── css / │ └── style.php └── images / └── fb-login-btn.png Create Facebook App To getting started to implement Facebook login in  CodeIgniter 3 using PHP SDK , you need to create a Facebook App in the Facebook developers panel and get the App ID and App S...
Read more

PHP - File Uploading

-
Image
A PHP script can be used with a HTML form to allow users to upload files to the server. Initially files are uploaded into a temporary directory and then relocated to a target destination by a PHP script. Information in the  phpinfo.php  page describes the temporary directory that is used for file uploads as  upload_tmp_dir  and the maximum permitted size of files that can be uploaded is stated as  upload_max_filesize . These parameters are set into PHP configuration file  php.ini The process of uploading a file follows these steps − The user opens the page containing a HTML form featuring a text files, a browse button and a submit button. The user clicks the browse button and selects a file to upload from the local PC. The full path to the selected file appears in the text filed then the user clicks the submit button. The selected file is sent to the temporary directory on the server. The PHP script that was specified as the form handler in the form's actio...
Read more