Wali faizy Wali faizy - 1 year ago 90
Ajax Question

autocomplete in jquery ajax and php5


<div class="input-group">
<input type="text" class="form-control autosuggest" placeholder="Search for">
<span class="input-group-btn">
<button class="btn btn-info"><span class="glyphicon glyphicon-search"></span></button>
<div class="dropdown">
<ul class="result">


jquery/ajax file

$(document).ready(function() {
$(".autosuggest").keyup(function() {
var search_term = $(this).attr('search');
var dataString = 'search_term='+ search_term;
type: 'post',
url : 'search.php',
data: dataString,
success: function(data) {


search.php file

include 'includes/db.php';

if(isset($_POST['search_term']) && !empty($_POST['search_term'])) {
$search_term = mysqli_real_escape_string($conn, $_POST['search_term']);
$sql = "SELECT name FROM names WHERE name LIKE $search_term%";
$run_sql = mysqli_query($conn, $sql);
while($rows = mysqli_fetch_assoc($run_sql)) {
echo "<li>$rows[name]</li>";

I am just making a simple autocomple suggestion in php mysql and ajax, my php version is 5 and jquery version is 2,i want to populate my mysql data in autosuggest container,First i am trying to alert the data on page with the help of javascript alert function but thrie is some error,can anyone please review my code

Thank you

Answer Source

Use quotes arround search variable

 $sql = "SELECT name FROM names WHERE name LIKE '$search_term%' ";
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download