How to load data from database using autocomplete?

Question

Here is my jQuery:

$(function() {
      $( "#user_role" ).autocomplete({ 
        source: function( request, response ) {
            $.ajax({
                url: "ajax/search_username",
                dataType: "json",
                data: request,
                success: function(data){
                    if(data.response == 'true') {
                       response($data);
                    }
                }
            });
        },
        minLength: 1,
        select: function( event, ui ) {
            //Do something extra on select... Perhaps add user id to hidden input    
        },

    });
}());

here is my HTML,

<input type="text" id="user_role" name="user_role">

Here is my controller,

function search_username() {

    $keyword=$this->input->get('term');
    $this->load->model('chat_model');
    $data=$this->chat_model->GetRow($keyword);        
    echo json_encode($data);
}

Here is my model

public function GetRow($keyword) {       

    $this->db->like('user_type', $keyword, 'both');
    return $this->db->get('lc_user_types')->result_array();
}

What I my trying to do is to load data form database using ajax but it's response is no properties but data is already there in table, please anyone help me for get rid of this.

Sudhir · Accepted Answer · 2016-02-11 05:50:45Z

1

First of all check this function it will return result or not

public function GetRow($keyword) {       
    $this->db->like('user_type', $keyword, 'both');
   return $this->db->get('lc_user_types')->result_array();


}

If it returning change the function

$(function() {
   $( "#user_role" ).autocomplete({ 
    source: function( request, response ) {
        $.ajax({
            url: "ajax/search_username",
            dataType: "json",
            data: request,
            success: function(data){
                response($.map(data, function (value, key) {
                        return {
                            id:key,
                            label: value,
                            value: value
                        };
                    }));
            }
        });
    },
    minLength: 1,
    select: function( event, ui ) {
        //Do something extra on select... Perhaps add user id to hidden input    
    },

});
}());

edited Feb 11, 2016 at 5:50

answered Feb 11, 2016 at 5:42

Sudhir

83312 silver badges33 bronze badges

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

4 Comments

Sudhir Over a year ago

Have you change javascript function. Manage the result array as key value. Ie array([0]=>'sudhir',[1]=>'prasanga')

Sudhir Over a year ago

In response($.map(data, function (value, key) { console.log(value); // check what returns }));

Prasanga Over a year ago

Thanks a lot sudhir.. it's getting

Prasanga Over a year ago

[{"user_type":"Admin","user_type_id":"1"},{"user_type":"Agent","user_type_id":"2"}]

Collectives™ on Stack Overflow

How to load data from database using autocomplete?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related