douyao1856
2014-06-09 23:14
浏览 152
已采纳

Eloquent列按键列出数组作为值?

So I can do this with Eloquent:

$roles = DB::table('roles')->lists('title', 'name');

But is there a way to make Eloquent fetch an array of values for each distinct key instead of just one column?

For instance, something like the following:

$roles = DB::table('roles')->lists(['*', DB:raw('COALESCE(value, default_value)')], 'name');
  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

3条回答 默认 最新

  • dsyct08008 2014-06-10 01:06
    已采纳

    You can use the keyBy method:

    $roles = Role::all()->keyBy('name');
    

    If you're not using Eloquent, you can create a collection on your own:

    $roles = collect(DB::table('roles')->get())->keyBy('name');
    

    If you're using Laravel 5.3+, the query builder now actually returns a collection, so there's no need to manually wrap it in a collection again:

    $roles = DB::table('roles')->get()->keyBy('name');
    
    评论
    解决 无用
    打赏 举报
  • 查看更多回答(2条)

相关推荐 更多相似问题