Sorting array in alphabetical order in php

Question

I have a set of data in DB and I am sending it to my Android App using an API function.

I have written this in PHP.

I want to sort JSON array in alphabetical order and then send it in JSON array format.

Here is the code I have, I am not sure how or where to sort this out?

        $response["categorydetails"] = array();
      
        while ($categoryrow = mysqli_fetch_array($categorylist))
        {
            // temp user array
            $categorydetail = array();
            $categorydetail["sno"] = $categoryrow["sno"];
            $categorydetail["category"] = $categoryrow["category"];     
          
            // push single product into final response array
            array_push($response["categorydetails"], $categorydetail);
        }

        $response["success"] = 1;
        $response["message"] = "Login Successful";


        echo json_encode($response);

Can someone help me figure this out?

Thanks!

By which column you want to sort?

Robert
– Robert

2021-10-28 06:56:25 +00:00
Commented Oct 28, 2021 at 6:56 — Robert
– Robert, Commented Oct 28, 2021 at 6:56

ADyson · Accepted Answer · 2021-10-28 07:08:47Z

2

Since you're getting the data from a database, it would make most sense to sort the data using an ORDER BY clause in the SQL query. This will be much more efficient than trying to sort it in PHP.

I don't know your real query or table name, but this is the general idea:

SELECT * FROM someTable ORDER BY someColumn

You didn't say which column you want to sort by, but I'd guess it's the category? In that case, ORDER BY category would be what you need to add to your SQL.

Documentation: MySQL Reference Manual - Sorting Rows

answered Oct 28, 2021 at 7:08

ADyson

62.9k16 gold badges86 silver badges100 bronze badges

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

Collectives™ on Stack Overflow

Sorting array in alphabetical order in php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related