blocks|key|286636|text|实际上，您可以在查询中执行此操作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|286637|$results+=+Project::orderBy('name')->get();|code-block|syntax|javascript|286638|这将以正确的顺序返回所有结果。|286639|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You can actually do this within the query.

<pre><code>$results = Project::orderBy('name')-&gt;get();
</code></pre>

This will return all results with the proper order.

blocks|key|286819|text|如果您仍然想使用all()，那么您仍然可以使用sortBy+(在集合级别)而不是orderBy+(在查询级别)，因为它返回一个对象集合。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|286820|升序|286821|$results+=+Project::all()->sortBy("name");|code-block|syntax|javascript|286822|降序|286823|$results+=+Project::all()->sortByDesc("name");|286824|有关更多详细信息，请查看有关集合的文档。|286825|https://laravel.com/docs/5.1/collections|offset|length|286826|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|0|0|0|14|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|10|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|11|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|12|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|13|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|14|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|15|8|@]|9|@$Q|16|R|17|1|18]]|A|$]]|$1|S|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|P]]]]

You could still use sortBy (at the collection level) instead of orderBy (at the query level) if you still want to use all() since it returns a collection of objects.

Ascending Order

<pre><code>$results = Project::all()-&gt;sortBy("name");
</code></pre>

Descending Order

<pre><code>$results = Project::all()-&gt;sortByDesc("name");
</code></pre>

Check out the documentation about Collections for more details.

<a href="https://laravel.com/docs/5.1/collections">https://laravel.com/docs/5.1/collections</a>

blocks|key|286757|text|此外，为了支持前面的答案，还可以通过添加desc或asc升序作为第二个参数来对其进行排序。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|286758|$results+=+Project::orderBy('created_at',+'desc')->get();|code-block|syntax|javascript|286759|entityMap^0|K|4|P|3|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

In addition, just to buttress the former answers, it could be sorted as well either in descending <code>desc</code> or ascending <code>asc</code> orders by adding either as the second parameter.

<pre><code>$results = Project::orderBy('created_at', 'desc')-&gt;get();
</code></pre>

blocks|key|286850|text|当你需要描述日期的结果时|type|unstyled|depth|inlineStyleRanges|entityRanges|data|286851|$results+=+Project::latest('created_at')->get();|code-block|syntax|javascript|286852|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

While you need result for date as desc 

<pre><code>$results = Project::latest('created_at')-&gt;get();
</code></pre>

blocks|key|68633|text|查看Eloquent：http://laravel.com/docs/eloquent的sortBy方法|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|68634|entityMap|0|LINK|mutability|MUTABLE|url|http://laravel.com/docs/eloquent^0|18|6|B|W|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@$9|Q|A|R|1|S]]|E|$]]|$1|F|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

Check out the <code>sortBy</code> method for Eloquent: <a href="http://laravel.com/docs/eloquent" rel="noreferrer">http://laravel.com/docs/eloquent</a>

blocks|key|69503|text|注意，您可以执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|69504|$results+=+Project::select('name')->orderBy('name')->get();|code-block|syntax|javascript|69505|这将生成如下查询：|69506|"SELECT+name+FROM+proyect+ORDER+BY+'name'+ASC"|69507|在一些应用程序中，当数据库未优化、查询比较复杂，并且需要在finish+SQL中防止生成ORDER+BY时，您可以这样做：|69508|$result+=+Project::select('name')->get();
$result+=+$result->sortBy('name');
$result+=+$result->values()->all();|69509|现在是php对结果进行排序。|69510|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

Note, you can do:

<pre><code>$results = Project::select('name')-&gt;orderBy('name')-&gt;get();
</code></pre>

This generate a query like:

<pre><code>"SELECT name FROM proyect ORDER BY 'name' ASC"
</code></pre>

In some apps when the DB is not optimized and the query is more complex, and you need prevent generate a ORDER BY in the finish SQL, you can do:

<pre><code>$result = Project::select('name')-&gt;get();
$result = $result-&gt;sortBy('name');
$result = $result-&gt;values()-&gt;all();
</code></pre>

Now is php who order the result.

blocks|key|69542|text|你的指令需要调用get，因为它会带来记录和orderBy目录吗|type|unstyled|depth|inlineStyleRanges|entityRanges|data|69543|$results+=+Project::orderBy('name')
+++++++++++->get();|code-block|syntax|javascript|69544|示例：|69545|$results+=+Result::where+('id',+'>=',+'20')
->orderBy('id',+'desc')
->get();|69546|在该示例中，数据按"where“进行筛选，并按从高到低的顺序提供大于20的记录和orderBy编目。|69547|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

You instruction require call to get, because is it bring the records and orderBy the catalog
<pre><code>$results = Project::orderBy('name')
 -&gt;get();
</code></pre>
Example:
<pre><code>$results = Result::where ('id', '&gt;=', '20')
-&gt;orderBy('id', 'desc')
-&gt;get();
</code></pre>
In the example the data is filtered by &quot;where&quot; and bring records greater than 20 and orderBy catalog by order from high to low.

blocks|key|287007|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|287008|$categories+++++=+++Category::all()->sortByDesc("created_at");|code-block|syntax|javascript|287009|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this:
<pre><code>$categories = Category::all()-&gt;sortByDesc(&quot;created_at&quot;);
</code></pre>

I'm stuck on a simple task. 
I just need to order results coming from this call 

<pre><code>$results = Project::all();
</code></pre>

Where <code>Project</code> is a model. I've tried this

<pre><code>$results = Project::all()-&gt;orderBy("name");
</code></pre>

But it didn't work. Which is the better way to obtain all data from a table and get them ordered?

Laravel Eloquent: Ordering results of all()

数据库

我被一项简单的任务卡住了。我只需要对这次通话的结果进行排序$results = Project::all();其中Project是一个模型。我试过了$results = Project::all()->orderBy("name");但它并没有起作用。从表中获取所有数据并对其进行排序的更好方法是什么？

问Laravel Eloquent:对all()的结果排序
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Laravel Eloquent:对all()的结果排序EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Laravel Eloquent:对all()的结果排序
EN