jQuery Autocomplete From MySQL Result (No JSON - If Possible)

Question

I need to have autocomplete feature on my website, but I'm not JSON-guy. I never dealing with JSON so I hope I still can have autocomplete from plain MySQL result.

but from what I saw here : http://jqueryui.com/demos/autocomplete/ I don't see any possibilities to get autocomplete from MySQL result. is it true?

I'm using PHP. do you have some example of this autocomplete? — Saint Robson
– Saint Robson, Commented Oct 5, 2012 at 7:45

M.I.T. · Accepted Answer · 2012-10-05 04:46:32Z

1

you can simply use php also

check here

this is ajax demo :)

download

edited Oct 5, 2012 at 4:46

answered Oct 5, 2012 at 4:34

M.I.T.

1,0422 gold badges17 silver badges34 bronze badges

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

Comments

G . R · Accepted Answer · 2012-10-05 04:45:12Z

0

You just need to make an AJAX call and take the search results then send them back as JSON to the client side.Then just bind it with the AutoComplete Textbox.

The jQuery plgin to be used is http://docs.jquery.com/UI/API/1.8/Autocomplete

Example- A textbox with ID 'txtlocation' is added with autocomplete functionality here.
$(document).ready(function(){

   $("#txtlocation").autocomplete({
    source: function (request, response) {
        $.ajax({
            url: "/PublicHome/AutoPopulateLocation", //Call to Server Side 
            data: "{ 'searchText': '" + request.term + "' }",
            dataType: "json",
            type: "POST",
            contentType: "application/json; charset=utf-8",
            dataFilter: function (data) { return data; },
            success: function (data) {
                    response($.map(data, function (item) {
                        return {
                            value: item.Suburb 

                    }))
                },
            error: function (XMLHttpRequest, textStatus, errorThrown) {

            }
        });
    },
    open: function (event, ui) {
        $(this).autocomplete("widget").css({
            "width": 344,
            "font-size": 11,
            "font-family": "Arial"
        });
      }
   });


});

edited Oct 5, 2012 at 4:45

answered Oct 5, 2012 at 4:33

G . R

5411 gold badge6 silver badges12 bronze badges

2 Comments

Saint Robson Over a year ago

correct me if I'm wrong : url: "/PublicHome/AutoPopulateLocation", //Call to Server Side >> means I have to refer to my php file like this url: "search.php" and what that search.php does is actually convert MySQL output into JSON format, is that what you mean?

Saint Robson Over a year ago

and what 'search text' on this line data: "{ 'searchText': '" + request.term + "' }", refers to?

Collectives™ on Stack Overflow

jQuery Autocomplete From MySQL Result (No JSON - If Possible)

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related