Hi friend, I hope all are good now I am describing how to create auto complete suggestion with help of jquery and php.
Step1:
first we will create HTML layout file which is contain all reference file as well as all CSS style code.
HTML CODE
Step2:
Now we will create PHP script file, It has all Sql Query to get matching records for show auto suggestion.
PHP Code
- <?php
-
-
-
- $dbLink = mysql_connect(‘localhost’, ‘root’ ,”) ;
- $db = mysql_select_db(‘test’,$dbLink);
-
-
- if(!$db) {
-
- echo ‘ERROR: Could not connect to the database.’;
- } else {
-
- if(isset($_POST['queryString'])) {
- $queryString = mysql_real_escape_string($_POST['queryString']);
-
-
-
- if(strlen($queryString) >0) {
-
-
-
-
-
-
-
-
- $query = mysql_query(“SELECT value FROM countries WHERE value LIKE ’$queryString%’ LIMIT 10″);
-
- if($query) {
-
-
- while ($result = mysql_fetch_row($query)) {
-
-
-
-
- echo ‘<li onClick=”fill(\”.$result[0].‘\’);”>’.$result[0].‘</li>’;
- }
- } else {
- echo ‘ERROR: There was a problem with the query.’;
- }
- } else {
-
- }
- } else {
- echo ‘There should be no direct access to this script!’;
- }
- }
- ?>
// PHP5 Implementation – uses MySQLi.
// mysqli(‘localhost’, ‘yourUsername’, ‘yourPassword’, ‘yourDatabase’);
$dbLink = mysql_connect(‘localhost’, ‘root’ ,”) ;
$db = mysql_select_db(‘test’,$dbLink);
//$db = new mysql_connect(‘localhost’, ‘root’ ,”, ‘test’);
if(!$db) {
// Show error if we cannot connect.
echo ‘ERROR: Could not connect to the database.’;
} else {
// Is there a posted query string?
if(isset($_POST['queryString'])) {
$queryString = mysql_real_escape_string($_POST['queryString']);
// Is the string length greater than 0?
if(strlen($queryString) >0) {
// Run the query: We use LIKE ‘$queryString%’
// The percentage sign is a wild-card, in my example of countries it works like this…
// $queryString = ‘Uni’;
// Returned data = ‘United States, United Kindom’;
// YOU NEED TO ALTER THE QUERY TO MATCH YOUR DATABASE.
// eg: SELECT yourColumnName FROM yourTable WHERE yourColumnName LIKE ‘$queryString%’ LIMIT 10
$query = mysql_query(“SELECT value FROM countries WHERE value LIKE ‘$queryString%’ LIMIT 10″);
if($query) {
// While there are results loop through them – fetching an Object (i like PHP5 btw!).
while ($result = mysql_fetch_row($query)) {
// Format the results, im using <li> for the list, you can change it.
// The onClick function fills the textbox with the result.
// YOU MUST CHANGE: $result->value to $result->your_colum
echo ‘<li onClick=”fill(\”.$result[0].’\');”>’.$result[0].’</li>’;
}
} else {
echo ‘ERROR: There was a problem with the query.’;
}
} else {
// Dont do anything.
} // There is a queryString.
} else {
echo ‘There should be no direct access to this script!’;
}
}
?>