Bootstrap Autocomplete (typeahead) does not work

Question

I am trying to make a autocomplete textbox that uses Bootstrap's typeahead functions. I have tested it through an array in javascript, manually typed. However I tried to add code that would allow autocomplete to use data from a mysql database, but I can't get this to work. What can I do to fix this so that autocomplete will show suggested words from a MySQL database?

HTML (test2.html)

<div class="well">  
    <input type="text" class="span3" id="typeahead" data-provide="typeahead" data-items="4" />  
</div>  

<script>    
$('#typeahead').typeahead({
    source: function(typeahead, query){
        $.ajax({
            url: 'source.php',
            type: 'POST',
            data: 'query=' + query,
            dataType: 'JSON',
            async: 'false',
            success: function(data){
                typeahead.process(data);
            }
        });
    } 
});     
</script>

PHP (source.php)

<?php 

include 'connect.php'; // connects to database

if (isset($_POST['query'])) {
    $query = $_POST['query'];
    $mysql_query = mysql_query("SELECT * FROM country WHERE country LIKE '%{$query}%'");

    while ($row = mysql_fetch_assoc($mysql_query)) {  
        $array[] = $row['name'];
    }

    json_cnode($array)

}

what is the error ... what are you getting ... what is the problem ... did you debug ? — lagbox, Apr 27 '14 at 16:48
json_cnode($array) .. not json_encode[$array]; ... that should be throwing an error there atleast — lagbox, Apr 27 '14 at 16:49
Still didn't work. The problem is that nothing happens when I type in (aka autosuggest doesn't activate) so I don't know the source of the problem. I know the mysql query works for sure though, so that's not the problem. — user3377126, Apr 27 '14 at 16:55
Your code is vulnerable to SQL injections. You should read on [how to prevent them in PHP](http://stackoverflow.com/q/60174/53114). — Gumbo, Apr 27 '14 at 17:01
I know that http://www.jshint.com/ doesn't report a Javascript error while http://phpcodechecker.com/ doesn't report a PHP error — user3377126, Apr 27 '14 at 17:02
Yeah I know, I planned on securing the textbox once I figure out how to get it to work. But thanks for telling me. — user3377126, Apr 27 '14 at 17:04
Yeah, it's json_encode($array) right? I added that in but no autosuggestion shows up — user3377126, Apr 27 '14 at 17:14
Sorry, a bit of a beginner at this. How would I check my error log if one uses Notepad++ ? — user3377126, Apr 28 '14 at 01:19

score 0 · Answer 1 · answered Aug 22 '14 at 01:13

0

The error is in the next part of your code:

json_cnode ($array)

It should say:

echo json_encode ($array);

answered Aug 22 '14 at 01:13

Cubanomayor

11
2

Bootstrap Autocomplete (typeahead) does not work

1 Answers1