How to get data with sorting from controller?

Question

I have the following query. I want to get data from the database sorted alphabetically:

$states = State::where('status', 1)->sortBy('name')->get();

It may be helpful for you stackoverflow.com/questions/47246772/… — Nadeem Riaz
– Nadeem Riaz, Commented Feb 12, 2020 at 6:49

Marmik Patel · Accepted Answer · 2020-02-12 06:49:51Z

2

Which framework are you using If laravel then write below syntax

$states = State::where('status', 1)->orderBy('name', 'ASC')->get();

answered Feb 12, 2020 at 6:49

Marmik Patel

1922 silver badges13 bronze badges

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

Comments

Anuj Shrestha · Accepted Answer · 2020-02-12 06:50:08Z

2

You need to use order by SQL keywords to get it alphabetically ordered data as ascending or descending order. For laravel use check Ordering, Grouping, Limit, & Offset from laravel docs.

For your use case it is simple as

 $states = State::where('status', 1)->orderBy('name', 'ASC')->get();

for ascending order

answered Feb 12, 2020 at 6:50

Anuj Shrestha

1,00110 silver badges22 bronze badges