JQuery PHP Tutorials

Jquery Autocomplete With PHP and Mysql Example

Below is the small example of Jquery autocomplete using PHP and Mysql.





search.php

$term = trim(strip_tags($_REQUEST['term']));

$query = "SELECT id, name from employees WHERE first_name LIKE '%$term%'";
$return_arr = array();
$result = mysql_query($query,$db);

while($row = mysql_fetch_array($result)) {
 $return_arr[] = array("value"=>$row['id'],"label"=>$row['name']);
}
echo $jsonResponse = json_encode($return_arr);
flush();
?>

For local data with out mysql autocomplete

Related Articles

techfolks php tutorials logo
General Mysql PHP

10 Mistakes Which PHP MySQL Developers Make

viveik

1. Using MyISAM rather than InnoDB MySQL has a number of database engines, but you’re most likely to encounter MyISAM and InnoDB. MyISAM is used by default. However, unless you’re creating a very simple or experimental database, it’s almost certainly the wrong choice! MyISAM doesn’t support foreign key constraints or transactions, which are essential for […]
PHP

How to Show Errors in PHP

viveik

Below script is to show errors in PHP, the error_reporting function will show all the error.You have to initialize at the start of PHP tag.

PHP Mysql Visitor Counter Script
Mysql PHP PHP Scripts Sample Programs

PHP Mysql Visitor Counter Script

viveik

If you want to add a counter to a web page or a website then use the below simple PHP Counter Script using MySql. It is very easy to implement it and it counts whenever a page is being refreshed and the script won’t reduce page speed, unlike page counter scripts. PHP Visitor Counter Script […]