PHP sorted associate numeric key array passing to ajax not work

Question

I have a function return an associate numeric key array:

public static function getSortedFruits()
{
$fruits = array('100' => 'lemon', '102' => 'orange', '103' => 'apple', '204' => 'banana');
asort($fruits);
print_r($fruits); // return sorted array('103' => 'apple', '204' => 'banana', '100' => 'lemon', '102' => 'orange')
return $fruits;
}

i call this function from PHP code, the array is sorted

$fruits = getSortedFruits(); // sorted array

when I call this function from ajax, the array is the same as before, isn't sorted

$('#fruits').bind('change', function() {
        $.ajax({
            type: 'POST',
            url: '/ajax/getFruits', // route to getFruits function
            dataType: 'json',
            success: function(result) {
               console.log(result); // the array isn't sorted
            });
});

If the key of the $fruits is not numeric, such as a, b, c, the result is sorted as normally both function call and ajax request.

How is ajax getting generated ?

Jayesh Chandrapal
– Jayesh Chandrapal

2014-04-12 02:21:06 +00:00
Commented Apr 12, 2014 at 2:21 — Jayesh Chandrapal
– Jayesh Chandrapal, Commented Apr 12, 2014 at 2:21
I think you should use echo json_encode($fruits);.

Suman Bogati
– Suman Bogati

2014-04-12 02:23:07 +00:00
Commented Apr 12, 2014 at 2:23 — Suman Bogati
– Suman Bogati, Commented Apr 12, 2014 at 2:23

Jayesh Chandrapal · Accepted Answer · 2014-04-12 02:38:48Z

1

asort method sorts based on array values. There is no difference in order from outputs from print_r and json_encode.

$fruits = array('1' => 'lemon', '2' => 'orange', '3' => 'apple', '4' => 'banana');
asort($fruits);

print_r($fruits);
// Above outputs:Array ( [3] => apple [4] => banana [1] => lemon [2] => orange )

echo json_encode($fruits);
// Above outputs: {"3":"apple","4":"banana","1":"lemon","2":"orange"}

edited Apr 12, 2014 at 2:38

answered Apr 12, 2014 at 2:27

Jayesh Chandrapal

6847 silver badges11 bronze badges

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

5 Comments

shrmn Over a year ago

I believe the poster wants to sort by array values as asort does.

Jayesh Chandrapal Over a year ago

With asort I am getting correct result in print_r and json_encode. So what exactly is the problem?

Jayesh Chandrapal Over a year ago

Updated answer, with outputs. Please remove downvote!

metylbk Over a year ago

if I return json_encode, the javascript get sorted array but when I parse the result to javascript object, the array is autosorted by key. success: function(result) { console.log(result); // sorted by value var result2 = JSON.parse(result); console.log(result2); // sorted by key AUTOMACTICALLY. }

Jayesh Chandrapal Over a year ago

If you need sorting based on value, you already have it through first method. If using jQuery, no need to use JSON.parse, as data is already parsed in json object. Makes sense ?

Suman Bogati · Accepted Answer · 2014-04-12 05:07:17Z

0

I have tested your code on my local pc with xampp, you will have to use

print_r($fruits)

Or

echo json_encode($fruits);

Instead of

return $fruits

UPDATED

encode the array after returned function getSortedFruits(), something like

$fruits = getSortedFruits(); // sorted array
json_encode($fruits)

edited Apr 12, 2014 at 5:07

answered Apr 12, 2014 at 2:46

Suman Bogati

6,3612 gold badges25 silver badges38 bronze badges

3 Comments

metylbk Over a year ago

This function is used in both ajax request and call from other function. so I can't return json_encode

metylbk Over a year ago

I've updated my code. Sorry if it wasn't clear for u all

metylbk Over a year ago

the error is: when i pass a json array with numeric key to javascript, it automatically convert all key to integer and automatically sort array by key. So the sorted array is sorted again. json: {"5":"apple", "3":"lemon"} is automatically converted to {3: "lemon", 5: "apple"}. It's not my expectation.

Collectives™ on Stack Overflow

PHP sorted associate numeric key array passing to ajax not work

2 Answers 2

5 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related