拉拉维尔 5.2 雄辩关系返回多维数组 - Laravel 5.2 Eloquent relationship return Multidimensional Array

Laravel 5.2 Eloquent relationship return Multidimensional Array

本文关键字：返回数组关系 | 更新日期: 2023-09-27

这是可能的路由代码

Route::get('/dashboard',['middleware' => 'auth', function () {
    $links = App'Website_links::where('website_id',1)->get();
    return view('user.dashboard',['links_data'=>$links]);
}]);

website_link模型代码是

class Website_links extends Model
{
   public $timestamps = false;
   protected $table = 'website_links';
    public function project()
    {
        return $this->belongsTo('App'Website','website_id')
                    ->select('project_name','project_status');
    }
 }

和查看代码

@foreach($links_data as $links)
         <tr>
         <td><a href="">{{$links['page_url']}}</a></td>
         <td>{{$links['project']}}</td>// here i want to display project_name from website table
         </tr>
    @endforeach

数据库模式：

  website : id,project_name,project_status
  website_links: id, page_url, website_id   //here website_id is forign key.

现在它显示正确page_url但是

{{$links['project']}} display {"project_name":"Project1","id":45}

我想显示像 project1 这样的project_name值而不是整个数组

  {"project_name":"Project1","id":45}

更改

$links['project'] to $link->project->project_name
@foreach($links_data as $links) 
     <tr>
         <td>
             <a href="">{{$links['page_url']}}</a>
         </td> 
        <td>
             {{$links->project->project_name}}
        </td>// here i want to display project_name from website table
     </tr> 
@endforeach

并将查询更改为以下内容以防止 N+1 查询问题

$links = App'Website_links::with('project')->where('website_id',1)->get();