jQuery - autocomplete doesn't display results from database

Question

I am working with jQuery autocomplete plugin and this is my index:

<script> 
  $(document).ready(function(){
    $("#tag").autocomplete({source: "./search.php?q="+ $("#tag").val()});
   });
</script>

<form action="search.php" method="post" class="form-inline search">
  <input type="text" id="tag" name="tag">
  <input type="submit" class="btn" value="Search" />
</form>

in search.php which is in the same folder as index.php is following:

 include 'config.php';
 $q=$_GET['q'];
 $my_data=mysql_real_escape_string($q);

 $sql="SELECT * FROM tags WHERE tag LIKE '%$my_data%'";
 $result = mysql_query($sql) or die(mysql_error());

 if($result)
 {
  while($row=mysql_fetch_array($result))
  {
   echo $row['tag']."\n";
  }
 }

When I start typing, autocomplete doesn't offer me any suggestions. Also no errors in JS console. In the code is just displayed No search results.. The paths are set up correctly, the database connection as well.

Thus, where could be a problem?

Thank you

do you see any results when you access search.php?q=something directly? — Alex Ackerman
– Alex Ackerman, Commented Jan 5, 2013 at 1:24

Salman Arshad · Accepted Answer · 2013-01-05 07:07:57Z

1

You don't need to use a query string on the src url of autocomplete. Just write your src file without query string:

$("#tag").autocomplete({source: "./search.php"});

And in your php file you have to capture the term parameter:

$q = $_GET['term'];

edited Jan 5, 2013 at 7:07

Salman Arshad

274k85 gold badges450 silver badges540 bronze badges

answered Jan 5, 2013 at 1:32

Alessandro G.

93 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user984621 · Accepted Answer · 2013-01-05 02:02:18Z

0

Solved this way - in PHP file must be data returned in JSON:

while($row=mysql_fetch_array($data))
{
    $result[] = $row['tag'];
}
echo json_encode($result);

answered Jan 5, 2013 at 2:02

user984621

48.8k79 gold badges236 silver badges430 bronze badges

Collectives™ on Stack Overflow

jQuery - autocomplete doesn't display results from database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related