Autocomplete using data from MYSQL

Question

I want to make autocomplete feature using jquery ui when searching data from mysql database....for nw am using data from array, but I dont know. How can I check it from the database? Here is my code.

<script>
$(function() {
    var availableTags = [
        "ActionScript",
        "AppleScript",
        "Asp",
        "BASIC",
        "C",
        "C++",
        "Clojure",
        "COBOL",
        "ColdFusion",
        "Erlang",
        "Fortran",
        "Groovy",
        "Haskell",
        "Java",
        "JavaScript",
        "Lisp",
        "Perl",
        "PHP",
        "Python",
        "Ruby",
        "Scala",
        "Scheme"
    ];

    $( "#tags" ).autocomplete({
        source: result_array 
    });
});
</script>

any help?

Edit to:

?php  
$q=mysql_query("select rfname from research_details") or die(mysql_error()); 

$array_data = mysql_fetch_array($q);

foreach($array_data as $data) {
 $data1[] = "'".$data."',";
}
$data1 = implode(",",$data1); 
$data = substr($data1,0,-1);


?>
$(function() {

var availableTags = [
<?php echo $data; ?>
];
$( "#tags" ).autocomplete({
source:availableTags 
});
});
</script>

user925885 · Accepted Answer · 2013-06-20 12:41:38Z

1

Using AJAX (jQuery.ajax()) you can send a request to a PHP file on your server to retrive the data from the database and return it as a JSON encoded string which you'll then parse in jQuery / Javascript and add it to the DOM.

answered Jun 20, 2013 at 12:41

user925885

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

Comments

kevinandrada · Accepted Answer · 2013-06-20 13:04:46Z

0

You can code it like the following:

$("#tags").autocomplete({
    source: function(request, response) {
        jQuery.ajax({
            url: '/autocomplete_query.php',
            dataType: 'json',
            success: function(data) {
                response(data);
            }
    });
});

The structure of the result in your SELECT query at autocomplete_query.php should be something similar to this array:

$result = array(0 => "ActionScript", 1 => "AppleScript", 2 => "Asp",...);

And then should be returned like this:

echo json_encode($result);

And make sure that that's the only echo statement on autocomplete_query.php.

answered Jun 20, 2013 at 13:04

kevinandrada

4992 gold badges5 silver badges15 bronze badges

2 Comments

internally1 Over a year ago

tanx, this seems helpfull....but i don get wat u meant by this $result = array(0 => "ActionScript", 1 => "AppleScript", 2 => "Asp",...);

kevinandrada Over a year ago

sorry for that! what i only meant by that was, the $result should just be a one-dimensional array and should not be multi.

GautamD31 · Accepted Answer · 2013-06-20 12:41:28Z

0

In place of availableTags you need to get the result as json format and you can get those results using ajax.On the ajax call you need to get the data from Database and then encode them in JSON format like

echo json_encode($result_array);

and parse them and add that to the availableTags.Try these JSON ENCODE

answered Jun 20, 2013 at 12:41

GautamD31

28.8k10 gold badges66 silver badges86 bronze badges

Comments

Knelis · Accepted Answer · 2013-06-20 12:45:32Z

0

Look at the jQueryUI API documentation for autocomplete.

Basically, you specify a URL as the source. That URL then outputs a page that jQuery can handle, such as JSON or XML data.

$('#autocomplete').autocomplete({
    source: '/data/my-page.php'
});

answered Jun 20, 2013 at 12:45

Knelis

7,2292 gold badges40 silver badges59 bronze badges

Comments

Fawad Ghafoor · Accepted Answer · 2013-06-20 12:54:47Z

0

You need to study following links Link1 Link2 Link3 and Demo

answered Jun 20, 2013 at 12:54

Fawad Ghafoor

6,2377 gold badges43 silver badges54 bronze badges

1 Comment

internally1 Over a year ago

hey thenx alot maryam for dat links, they are great

Balaji Kandasamy · Accepted Answer · 2013-06-20 14:30:24Z

0

You can try like this. Get data from db as array, then pass it in you jquery function.

<?php
$array_data;  // get data from db as array
foreach($array_data as $data) {
$data1[] = "'".$data."',";
} 
$data1=implode(",",$data1);
   $data = substr($data1,0,-1);
?>

<script>
$(function() {

var availableTags = [
<?php echo $data; ?>
];
$( "#tags" ).autocomplete({
source:result_array 
});
});
</script>

edited Jun 20, 2013 at 14:30

answered Jun 20, 2013 at 12:52

Balaji Kandasamy

4,50410 gold badges42 silver badges58 bronze badges

2 Comments

internally1 Over a year ago

see my update, but i still get a warning ) Warning: substr() expects parameter 1 to be string, array given in

Balaji Kandasamy Over a year ago

try with implode function before the substr finction

Collectives™ on Stack Overflow

Autocomplete using data from MYSQL

6 Answers 6

Comments

2 Comments

Comments

Comments

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

2 Comments

Comments

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related