Today, We want to share with you Ajax Autocomplete Live Search Suggestion using PHP MySQL.In this post we will show you PHP Ajax Autocomplete Search from Database Example, hear for Auto complete search with Ajax, jQuery, PHP and MYSQL we will give you demo and example for implement.In this post, we will learn about Search Suggestion Functionality with PHP and MySQL with an example.
Ajax Autocomplete Live Search Suggestion using PHP MySQL
There are the Following The simple About Ajax Autocomplete Live Search Suggestion using PHP MySQL Full Information With Example and source code.
As I will cover this Post with live Working example to develop Autocomplete Textbox using jQuery, PHP and MySQL, so the Autocomplete with PHP, MySQL and Jquery UI for this example is following below.
Step 1: HTML Interface
index.html
First of all, let’s simple create HTML an index.html file for Autocomplete or Search Suggestion.
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="Content-Language" content="en-us">
<title>Autocomplete Textbox using jQuery, PHP and MySQL - Pakainfo.com</title>
<meta charset="utf-8">
<link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css" rel="stylesheet">
<script src="//code.jquery.com/jquery-2.1.4.min.js"></script>
<script src="//maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
<script src="//netsh.pp.ua/upwork-demo/1/js/typeahead.js"></script>
<style>
h1 {
font-size: 20px;
color: #f5f5f5f;
}
.content {
width: 80%;
margin: 0 auto;
margin-top: 60px;
}
.tt-hint,
.city {
border: 2px solid #c60000;
border-radius: 10px 10px 10px 10px;
font-size: 24px;
height: 45px;
line-height: 30px;
outline: medium none;
padding: 10px 12px;
width: 500px;
}
.tt-dropdown-menu {
width: 500px;
margin-top: 5px;
padding: 10px 12px;
background-color: #fff;
border: 1px solid #ccc;
border: 1px solid rgba(0, 0, 0, 0.2);
border-radius: 10px 10px 10px 10px;
font-size: 110px;
color: #111;
background-color: #3d3d3d;
}
</style>
<script>
$(document).ready(function() {
$('input.city').typeahead({
name: 'city',
remote: 'get_members.php?search=%SEARCH'
});
})
</script>
</head>
<body>
<div class="Pakainfo content">
<form>
<h1>Please type of the City or Zip code</h1>
<input type="text" name="city" size="30" class="city" placeholder="Please Enter Your City or Country ZIP code">
</form>
</div>
</body>
</html>
Step 2: Serever Side Source code
get_members.php
And then I shall create a PHP Page mysql.php file which will all the aggregate Mysql Database query to MySQL DB as well as also give outpur response as type of the JSON. Serever Side Code for Creating Autocomplete or Search Suggestion Functionality with PHP and MySQL
<?php
//CREDENTIALS FOR Database
define ('DBSERVER', 'localhost');
define ('DBUSER', 'root');
define ('DBPASS','Mypassword');
define ('DBNAME','memberlist');
$connection = mysql_connect(DBSERVER, DBUSER, DBPASS) or die("Can't connect to server.");
$result = mysql_select_db(DBNAME) or die("Can't your select database.");
//CREATE Mysql search TO Database as wel as PUT RECEIVED DATA INTO PHP ASSOCIATIVE ARRAY
if (isset($_REQUEST['search'])) {
$search = $_REQUEST['search'];
$sql = mysql_query ("SELECT zip, city FROM zips WHERE city LIKE '%{$search}%' OR zip LIKE '%{$search}%'");
$membersarray = array();
while ($datamembers = mysql_fetch_array($sql)) {
$membersarray[] = array (
'label' => $datamembers['city'].', '.$datamembers['zip'],
'value' => $datamembers['city'],
);
}
//RETURN JSON ARRAY
echo json_encode ($membersarray);
}
?>
Angular 6 CRUD Operations Application Tutorials
Read :
Summary
You can also read about AngularJS, ASP.NET, VueJs, PHP.
I hope you get an idea about Ajax Autocomplete Live Search Suggestion using PHP MySQL.
I would like to have feedback on my Pakainfo.com 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.
