Javascript Autocomplete list a MySQL result

Question

I have a Autocomplete script that look for Var tags, my question is, How can i populate the "avaiableTags" with a result of MySQL?

$SQL = "SELECT username FROM users"; for example

(function($) {
    $(document).ready(function(e) {
        if($.fn.autocomplete) {
            var availableTags = [
                "User 1", //mysql result here
                "User 2",
                "ecc..."
            ];

do an ajax request, or insert the data from mysql at the time the page that contains this JS code is generated. — Marc B
– Marc B, Commented Aug 2, 2013 at 15:20

usman allam · Accepted Answer · 2013-08-02 15:27:28Z

1

//javascript
   <script type="text/javascript">
   $(function() {

    //autocomplete
    $(".auto").autocomplete({
        source: "search.php",
        minLength: 1
    });                

   });
  </script>

//search.php something like this

   $stmt = $conn->prepare('SELECT country FROM countries WHERE country LIKE :term');
   $stmt->execute(array('term' => '%'.$_GET['term'].'%'));

   while($row = $stmt->fetch()) {
   $return_arr[] =  $row['country'];
   }

For full example please check here http://www.daveismyname.com/tutorials/php-tutorials/autocomplete-with-php-mysql-and-jquery-ui/

answered Aug 2, 2013 at 15:27

usman allam

2841 silver badge5 bronze badges

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

Collectives™ on Stack Overflow

Javascript Autocomplete list a MySQL result

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related