Jquery matching an element from a JSON array

Question

I currently have a JSON callback containing both an id an a name as below:

[{"id":"1","name":"Wired Motors"},
{"id":"2","name":"pragma innovations"},
{"id":"3","name":"University of Femme Fatales"}]

I am using jQuery UI autocomplete which needs to match the name section of the returned result and display this in the suggest drop down and also be able to drag in the id into a html data element.

So far I am not having much luck in matching the user input to the name section of the callback. I can do this with a clean array but not sure how to do this with a JSON array

did you mean something like this jsfiddle.net/vinodlouis/SaDVm/1 — Vinod Louis
– Vinod Louis, Commented Oct 1, 2013 at 14:38

MackieeE · Accepted Answer · 2013-10-01 14:53:39Z

1

I believe the jQuery Autocomplete uses a standardised Name => Value JSON Array format of:

[{ "label" : "1", "value" : "Wired Motors" },
 { "label" : "2", "value" : "pragma innovations"},
 { "label" : "3", "value" : "University of Femme Fatales"}]

Soruce: jQuery Autocomplete Source API

You can then add them to the Autocomplete Source/Suggestions:

$('#myautocomplete').autocomplete({
    minLength : 2,
    source : function( request, response ) {
       $.ajax({
           url: 'path-to-your-script.php',
           dataType: 'json',
           data: '?variablestodb=somedata',
               success: function( data ) {
               response( $.map( data, function( item ) {
                   return {
                      label: item.label,
                      value: item.value
                     }
                  }));
                }
            });
        },
        select: function( event, ui ) {

        }
    });

edited Oct 1, 2013 at 14:53

answered Oct 1, 2013 at 14:40

MackieeE

11.9k4 gold badges41 silver badges58 bronze badges

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

7 Comments

Sideshow Over a year ago

The array is actually where the autocomplete gets its values. This will be cached due to the size of the database after the initial request. I think I can use your logic though :)

MackieeE Over a year ago

Ahhh sorry! :D So using one of the callbacks of the Autocomplete, you're wishing to re-use the selected option elsewhere? Could you show some code you're attempting to do this with?

Sideshow Over a year ago

It works exactly the same as getting the data from a database - just, doing this on keyup will put a lot of pressure on the db. Therefore on keyup on change request will check the cached results hopefully matching the 'name' values. I would then have to drag in the id - The problem is I don't seem to be matching the name sections :(

MackieeE Over a year ago

Must be a pretty big Db.. How long does it take to get a result after a keypress up? x) Would sound like some Db Optimisation would help more - also, surely after a keypress, the previous cache results would become.. redundant anyway!

Sideshow Over a year ago

The data is unlikely to change and I am probably going to set the cache to timeout after an hour. I am just testing this process at the moment (junior dev) to see which option (if any) will be suitable. I do think the cache method could cause some unwanted problems to the end user though if they need to re-edit a passed record via the search facility. Currently we are only working on the test database which only holds a tiny amount of data. Data migration is the job for next week - not fun 30yr old database schema with much redundant and duplicated data :(

|

Collectives™ on Stack Overflow

Jquery matching an element from a JSON array

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related