I have a json object as follows:
[{"Id":"1","Item":"Apples","PricePerKilo":"10.00"},
{"Id":"3","Item":"Oranges","PricePerKilo":"12.00"}]
I wish to get the PricePerKilo where the Id is 3.
var fruits = jQuery("#products").data('productData');
fruits holds the json object by the way...
I will explain what I want to do in SQL, because I find it easier to explain this way
SELECT PricePerKilo From fruits WHERE Id = 3 LIMIT 1
You must loop! (Also, if fruits holds the JSON and not the array [it can’t hold both] then you should use jQuery.parseJSON on it first.)
var i, fruit;
for(i = 0; fruit = fruits[i]; i++) {
if(fruit.Id == 3)
break;
}
fruit will contain either the fruit with the Id of 3 or undefined if it didn’t exist.
fruit hold the last fruit object if the id didn't exist?
i < fruits.length, the condition is fruit = fruits[i]. So it exits when fruit becomes undefined.Id of undefined? Shouldn't it be if (fruit && fruit.Id ==3)?while(fruit = fruits[i]) { … }.
You would have to loop through your array and select the id that matches:
$.each(fruits, function(i, val){
if (val.Id == 3) {
// val is now the single fruit object with the id of 3
}
});
