laravel 4组集合/结果

Question

我试图在我的循环中通过'alpha‘对一个术语表页面进行一个简单的group，但不确定如何实现这一点。我的数据是

alpha glossary_title

A苹果B香蕉A另一个苹果！

GlossaryController.php

public function index() {

  $glossary = Glossary::groupBy('alpha')->orderBy('glossary_title', 'asc')->get();
  return View::make('glossary')->with('glossary', $glossary);

}

迁移

Schema::create('glossary', function(Blueprint $table)
        {
             // columns
            $table->increments('id');
            $table->string('glossary_title');
            $table->text('glossary_desc')->nullable();
            $table->char('alpha', 1);
            $table->timestamps();
        });

glossary.blade.php

@foreach($glossary as $glossary)
        <li>{{ $glossary->glossary_title}} <br /> {{ $glossary->glossary_desc}}</li>
@endforeach

Answer 1

这将返回一个按$glossary->alpha分组的新集合

$glossary = Glossary::orderBy('glossary_title', 'asc')->get();
$glossary = $glossary->groupBy('alpha');

// same as this:
$glossary = $glossary->groupBy(function ($entry) {
  return $entry->alpha;
});

然后在视图中需要2个循环，第一个循环用于组，第二个循环用于每个组中的条目。