检索值是在laravel

Question

一对多的关系我有应与其他三个表，活动，捐赠&机会显示所选专案编号的详细信息，也该特定IDS DATAS刀片页面。但我只能检索项目表值而不是其他3个表。没有错误信息。请帮助使用laravel查询单个页面中的所有4个表格。

我ProjectController文件：

public function getDetailedProject() 
{ 
    $data=Project::all()->where('pid', 35); 
    $eve=Event::all()->where('pro_id', 35); 
    $don=Donation::all()->where('pro_id', 35); 
    $opp=Opportunity::all()->where('pro_id', 35); 
    return view('other.detailedProject')->with('data',$data); 
} 

我DetailedProject.blade.php文件代码：

@extends('templates.default') 

@section('content') 

    @foreach($data as $row) 
    <ul> 
<h2>Project Details</h2> 
<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Project Title </label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$row->ptitle}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Project Description</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$row->pdescription}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Project Duration</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$row->pduration}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Project Start Date</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$row->psdate}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Project End Date</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$row->pedate}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Project Category</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$row->pcategory}} </label> 
</div> 
</div> 
@endforeach 

@foreach($data as $eve) 
<h2>Event Details</h2> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Event Title </label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$eve->etitle}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Event Details</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$eve->edetails}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Event Date</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$eve->edate}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Event Time</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$eve->etime}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Project End Date</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$eve->elocation}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Event Details</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$eve->eimage}}</label> 
</div> 
</div> 
@endforeach 

@foreach($data as $don) 
<h2>Donation</h2> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Total Cost</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label>{{$don->dtotal}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Amount in Hand</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$don->dinhand}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Amount Required</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label>{{$don->dtotal}} - {{$don->dinhand}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Bank Account</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$don->dbankaccount}}</label> 
</div> 
</div> 
@endforeach 

@foreach($data as $opp) 
<h2>Oppertunity</h2> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Position</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$opp->oposition}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Describtion</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$opp->odescription}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Location</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$opp->olocation}}</label> 
</div> 
</div> 

<div class="row"> 
<div class="col-lg-3 col-md-3 col-sm-3"> 
    <label>Deadlinet</label> 
</div> 
    <div class="col-lg-9 col-md-9 col-sm-9"> 
    <label> {{$opp->odeadline}}</label> 
</div> 
</div> 
@endforeach 

</ul> 
@stop 

请帮我找出的错误。进出口新的laravel

Answer 1

试试这个代码，希望工程！

$data=Project::where('pid', 35)->get(); 
$eve=Event::where('pro_id', 35)->get(); 
$don=Donation::where('pro_id', 35)->get(); 
$opp=Opportunity::where('pro_id', 35)->get(); 
return view('other.detailedProject', compact('data', 'eve', 'don', 'opp'));