Sorting a PHP Object array without keys?

Question

I am generating a list of cuisines like this:

$lists='';
$stmt="SELECT cuisine_id, cuisine_name, cuisine_name_trans FROM db_cuisine";

if ( $res=$DbExt->rst($stmt)){
    if ($list){
        foreach ($res as $val) {    

            $cuisine_json['cuisine_name_trans']=!empty($val['cuisine_name_trans'])?
            json_decode($val['cuisine_name_trans'],true):'';

            $lists[$val['cuisine_id']]="".qTranslate($val['cuisine_name'],'cuisine_name',$cuisine_json);
        }
        return $lists;
    }
    return $res;
}       
return false;

The list is then returned as:

1: "American"
5: "Sandwiches"
6: "Barbeque"
8: "Italian"
9: "Mexican"
10: "Sushi"
11: "Burgers"
13: "Japanese"

(The IDs are according to the database ID). I am trying to sort them now descending by name but I can't seem to get it done with sort as it needs a key name. How do I do that?

What are $list, $cuisine_json and $lists? Where are they defined? What does qTranslate() do? — Phil
– Phil, Commented Mar 6, 2019 at 5:48
Sorry, I forgot to include that. $list is just a true/false. $lists is defined with $lists=''; and $cuisine_json comes from cuisine_name_trans. — moo moo
– moo moo, Commented Mar 6, 2019 at 5:50
This question need significant improvement if you are to get it to a state where it contains a MCVE. — gview
– gview, Commented Mar 6, 2019 at 5:51
instead of converting the row data to output string directly, store it as array key=>value first. after the loop is exited, do an asort() and then json_encode() to convert it as json string. — sabkaraja
– sabkaraja, Commented Mar 6, 2019 at 5:51
If $lists is a string, you're going to run in to problems with that $lists[$val['cuisine_id']] bit. I'd recommend an array instead, ie $lists = []; — Phil
– Phil, Commented Mar 6, 2019 at 5:51

prasanth · Accepted Answer · 2019-03-06 05:45:25Z

2

Do Sorting with sql instead of php

$stmt="SELECT cuisine_id, cuisine_name, cuisine_name_trans FROM db_cuisine WHERE 1 ORDER BY cuisine_name DESC ";

answered Mar 6, 2019 at 5:45

prasanth

22.6k4 gold badges33 silver badges57 bronze badges

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

5 Comments

moo moo Over a year ago

I tried that but somehow it's not working. As to why, that's beyond me. So I'm trying to get it done with PHP...

moo moo Over a year ago

And since I use translations after retrieving it, the sorting may differ.

prasanth Over a year ago

in your code you are sorting the array before translate.So i think its not affect the translate function

prasanth Over a year ago

And if($list) is always false.So its not passing to the statment

moo moo Over a year ago

Looks like I will need to rewrite the whole code there and take a different approach. Thanks a lot for your help :)

v.orujov · Accepted Answer · 2019-03-06 05:56:12Z

0

You can use PHP's arsort function. It sorts an array by value in the descending order. Your final code should be like:

if ( $res=$DbExt->rst($stmt)){
    if ($list){
        foreach ($res as $val) {    

            $cuisine_json['cuisine_name_trans']=!empty($val['cuisine_name_trans'])?
            json_decode($val['cuisine_name_trans'],true):'';

            $lists[$val['cuisine_id']]="".qTranslate($val['cuisine_name'],'cuisine_name',$cuisine_json);
        }
        arsort($lists);
        return $lists;
    }
    return $res;
}       
return false;

I also recommend to check this page to get more info about the PHP array sort functions.

answered Mar 6, 2019 at 5:56

v.orujov

561 silver badge5 bronze badges

Collectives™ on Stack Overflow

Sorting a PHP Object array without keys?

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related