PHP Ajax Autocomplete Search from Database Example – Technology

PHP Ajax Autocomplete Search from Database Example – Technology

In this post we will give you information about PHP Ajax Autocomplete Search from Database Example – Technology. Hear we will give you detail about PHP Ajax Autocomplete Search from Database Example – TechnologyAnd how to use it also give you demo for it if it is necessary.

Today, We want to share with you PHP Ajax Autocomplete Search from Database Example.In this post we will show you MySQL Database Live Search with PHP and AJAX, hear for jQuery Autocomplete Search using PHP, MySQL and Ajax we will give you demo and example for implement.In this post, we will learn about Autocomplete Textbox using jQuery, PHP and MySQL with an example.

PHP Ajax Autocomplete Search from Database Example

There are the Following The simple About PHP Ajax Autocomplete Search from Database Example Full Information With Example and source code.

Another must read:  Laravel 6 insert or update multiple records

As I will cover this Post with live Working example to develop Ajax Search Box in PHP and MySQL, so Creating Autocomplete for City Search Using PHP and MySQL Database for this example is following below.

Step 1: Create members table

List of all Google Adsense, VueJS, AngularJS, PHP, Laravel Examples.

CREATE TABLE IF NOT EXISTS 'members' (
  'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
  'name' varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  'email' varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  'password' varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  'created_at' timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  'updated_at' timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY ('id'),
  UNIQUE KEY 'members_email_unique' ('email')
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

Step 2: Create index.php file

<!DOCTYPE html>
<html>
<head>
	<meta charset="utf-8">
	<title>onlinecode - </title>
	<link rel="stylesheet" href="#">
	<style type="text/css">
		.pakainfo{
			margin-top:20px;
		}
		#pakainfo_find{
			display: none;
		}
		.list-span3-list a{
			text-decoration: none !important;
		}
		.list-span3 li{
			cursor: pointer;
			padding: 4px 0px;
		}
		.list-span3{
			list-style-type: none;
    		background: #d4e8d7;
		}
		.list-span3 li:hover{
			color: white;
			background-color: #3d3d3d;
		}
	</style>
</head>
<body>
<div >
	<h1 >Auto Complete Search using jQuery</h1>
	<div >
		<div >
			<form id="pakainfoFrm" method="POST" action="">
				<div >
				  	<input type="text" id="searchquery" name="searchquery"  placeholder="Eneter Your Search Name" aria-describedby="basic-addon2">
				</div>
			</form>
			<ul  id="pakainfo_find"></ul>
		</div>
	</div>
	<a href="http://tridentsportscars.com/?big=" target="_blank" alt="pakainfo" title="pakainfo">Free Download Example - onlinecode</a>
</div>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.js"></script>
<script type="text/javascript">
	$(document).ready(function(){
	//jQuery Autocomplete search using Serever side Get Data PHP, MySQLi, Ajax and jQuery
		//here HTML Form to generate suggestion on keyup
		$('#searchquery').keyup(function(e){
			e.preventDefault();
			var form = $('#pakainfoFrm').serialize();
			$.ajax({
				type: 'POST',
				url: 'get_membersList.php',
				data: form,
				dataType: 'json',
				success: function(response){
					if(response.error){
						$('#pakainfo_find').hide();
					}
					else{
						$('#pakainfo_find').show().html(response.data);
					}
				}
			});
		});
		//jQuery fill the input
		$(document).on('click', '.list-span3-list', function(e){
			e.preventDefault();
			$('#pakainfo_find').hide();
			var memberFname = $(this).data('memberFname');
			$('#searchquery').val(memberFname);
		});
	});
</script>
</body>
</html>

Step 3: Create get_membersList.php file

<?php
	if(isset($_POST['searchquery'])){
		$conn = new mysqli('localhost', 'root', 'root', 'atmiya_25');
		$datar_response = array('error' => false, 'data' => '');
 
		$searchquery = $_POST['searchquery'];
 
		if(empty($searchquery)){
			$datar_response['error'] = true;
		}else{
			$sql = "SELECT * FROM members WHERE name LIKE '%$searchquery%'";
			$sqlquery = $conn->query($sql);
 
			if($sqlquery->num_rows > 0){
				while($memberData = $sqlquery->fetch_assoc()){
					$datar_response['data'] .= "
						<li class='list-span3-list' data-memberFname='".$memberData['name']." ".$memberData['lastname']."'>".$memberData['name']." ".$memberData['lastname']."</li>
					";
				}
			}
			else{
				$datar_response['data'] = "
					<li class='list-span3-list'>No Any found data matches Members Records</li>
				";
			}
		}
 
		echo json_encode($datar_response);
	}
?>
Angular 6 CRUD Operations Application Tutorials

Read :

Another must read:  Laravel 7 Create Custom Helper Function Tutorial Example

Summary

You can also read about AngularJS, ASP.NET, VueJs, PHP.

I hope you get an idea about PHP Ajax Autocomplete Search from Database Example.
I would like to have feedback on my onlinecode blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

Hope this code and post will helped you for implement PHP Ajax Autocomplete Search from Database Example – Technology. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs

For More Info See :: laravel And github

Leave a Comment

Your email address will not be published. Required fields are marked *

12  +    =  18

We're accepting well-written guest posts and this is a great opportunity to collaborate : Contact US