Explore our sites

Stack Exchange
tour help careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I have found a lot of threads here on StackOverflow that talk about parsing json arrays but I can't seem to figure out how to get back some of the data. Here is what I have...

    $('#keyword_form').submit(function(e){  
        var gj = $.post('employee_search.php',$('#keyword_form').serialize(),function(data){                
            if(!data || data.status !=1 )
            {
                alert(data.message);
                return false;
            }
            else
            {
                alert(data.message);
            }
        },'json');  
        e.preventDefault();

    });

The json data being sent to it looks like this...

{
    "status":1,
    "message":"Query executed in 9.946837 seconds.",
    "usernames_count":{
        "gjrowe":5,
        "alisonrowe":4,
        "bob":"1"
    }
}

As my function shows I can do alert(data.message); but how can I access the usernames_count data?

My confusion comes from the fact that the data has no name/label. bob is a username and 1 is the returned count associated with that username

If I do alert(usernames_count); I get back [object Object]

If I do alert(usernames_count[0]); I get back undefined

I am sure I should be doing something with JSON.parse(); but I haven't gotten it right yet

share|improve this question
 
Do you have the possibility to change the returned data? usernames_count should really be a number and a new users field should be an array holding users. Don't you think? –  Jonas G. Drange Apr 13 '13 at 13:49
 
One thing that may be confusing you is that usernames_count is not an array, it is a JSON object. –  elevine Apr 13 '13 at 13:52
 
It's a JavaScript object, therefore you can iterate the keys – with a for…in or Object.keys. In ES6 you have also for…of. –  ZER0 Apr 13 '13 at 13:55
add comment

3 Answers

up vote 4 down vote

Try this:

$.each(data.usernames_count, function(username, val) {
    alert(username+" has a value of "+val);
});
share|improve this answer
 
Yep... That did the trick - 100% –  G-J Apr 13 '13 at 13:59
add comment
up vote 3 down vote

You can use Object.keys or a for…in loop – remember in that case to use hasOwnProperty:

var users = data.usernames_count;
Object.keys(users).forEach(function(user) {
    console.log(user, users[user]);
});
share|improve this answer
 
Remember that this is not supported in all older browsers. There's a guide on how to add backwards capability here. –  Hannes Johansson Apr 13 '13 at 13:58
 
@HannesJohansson If it is not supported on older browsers, am I safer to use the other answer that uses jquery? –  G-J Apr 13 '13 at 14:01
 
If you have no problem on relying on jQuery, sure. And it seems you are using jQuery anyway, so I'd pick that solution. If you want code that doesn't depend on jQuery, though, you could patch Object like in the Mozilla guide. –  Hannes Johansson Apr 13 '13 at 14:04
add comment
up vote 0 down vote

It sounds like your question is how to iterate over the entries in the usernames_count object. You can do that like so:

var key = '';
for(key in data.usernames_count) {

    //check that this key isn't added from the prototype
    if(data.usernames_count.hasOwnProperty(key) {
        var value = data.usernames_count[key];

        //do something with the key and value
    }
}
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.