php - 无法连接另一个表中的值（使用 laravel 5.5）

Question

我面临着关于存储 id 并从两个不同的表中显示它们的值的问题我有 1 个表 business_master 和另一个表是 page_master 我已经将 business_name 列与 page_url 列结合起来，如果我第一次成功添加我的业务和页面，它们在 page_master 表上可用将这两个值结合起来，因为一个企业可以有很多页面，如果我只第二次添加页面，我将无法看到带有 page_url 列的 business_url：

我的页面模型：

        class PageList extends Model
  {
 protected $table = 'page_master';


  protected $fillable = ['business_id', 'page_url', 'page_name'];


 public function business()
  {
   return $this->hasOne('App\Business','business_id');
  }

 }

在我看来：

<td>{{optional($value->business)->business_url}}.spikesales.io/{{$value->page_url}}</td>

如果我添加 business_url 和 page_url 这是我的第一次

   hussain.spikesales.io/house

然后如果我只添加页面输出是这样的

   .spikesales.io/hello

我的控制器看起来像：

 public function pageListHere()
{
    $list = PageList::wherehas('business')->get();
    return view('page-list',compact('list'));
}

您的直升机将不胜感激！

  class PageList extends Model
  {
protected $table = 'page_master';


protected $fillable = ['business_id', 'page_url', 'page_name'];



public function business()
{
    return $this->hasOne('App\Business','business_id');
}

  }

和我的全貌：

                                           @foreach($list as $value)
                                <tr>
                                    <input type="hidden" id="rwid" value="{{$value->id}}"/>
                                    <td>
                                        <input id="{{$value->id}}" class="checkbox-custom" name="{{$value->id}}" type="checkbox"
                                               value="{{$value->id}}">
                                        <label for="{{$value->id}}" class="checkbox-custom-label"></label>
                                    </td>
                                    <td><p data-placement="top" data-toggle="tooltip" title=""
                                           data-original-title="Tolltip">{{$value->page_name}}</p></td>
                                    <td>{{optional($value->business)->business_url}}.spikesales.io/{{$value->page_url}}</td>

                                    <td> {{$value->created_at}}</td>
                                    <td>

                                        <p>{{$value->coupon()->where('is_ordered','N')->count()}}/{{optional($value->particulars)->coupon_count}}</p>
                                    <div class="progress-bar">
                                        <span class="yello-proges" style="width:{{$value->coupon()->where('is_ordered','N')->count()}}%"></span>
                                    </div>
                                </td>
                                <td>
                                    <button type="button" class="ply-btn playpause">
                                        @if($value->is_live === 1)
                                            <span class="pause" style="display: none;"><i class="fa fa-pause"></i></span>
                                            <span class="play"><i class="fa fa-play"></i></span>
                                            <span class="spinner" style="display: none;"><i class="fa fa-spinner fa-spin"></i></span>
                                        @endif
                                        @if($value->is_live === 0)
                                            <span class="pause"><i class="fa fa-pause"></i></span>
                                            <span class="play" style="display: none;"><i class="fa fa-play"></i></span>
                                            <span class="spinner" style="display: none;"><i class="fa fa-spinner fa-spin"></i></span>
                                        @endif

                                            @if($value->is_live === Null)
                                                <span class="pause"><i class="fa fa-pause"></i></span>
                                                <span class="play" style="display: none;"><i class="fa fa-play"></i></span>
                                                <span class="spinner" style="display: none;"><i class="fa fa-spinner fa-spin"></i></span>
                                            @endif

                                    </button>
                                    {{--<a data-page-id="{{$value->id}}" class="ply-btn" id="playpause">--}}
                                        {{--<span class="pause"><i class="fa fa-pause"></i></span>--}}
                                        {{--<span class="play" style="display: none;"><i class="fa fa-play"></i></span>--}}
                                        {{--<span class="spinner" style="display: none;"><i class="fa fa-spinner fa-spin"></i></span>--}}
                                    {{--</a>--}}
                                    <div class="btn-group" data-placement="top" data-toggle="tooltip" title="" data-original-title="Action">
                                        <button type="button" class="dropdown-toggle actinbtn" data-toggle="dropdown" aria-expanded="false"><i class="fa fa-cog"></i></button>
                                        <ul class="dropdown-menu">
                                            <li><a href="{{url('edit-List/'.$value->id)}}"><i class="fa fa-pencil-square-o"></i> Edit Page</a></li>
                                            <li><a href="{{url('template/'.($value->particulars1)->id)}}" class="viewpage" target="_blank"><i class="fa fa-eye"></i> View Page</a></li>
                                            <li><a class="dangrclr"><i class="fa fa-trash-o"></i>Delete</a></li>
                                            {{--<li><a href="{{url('delete-list/'.$value->id)}}" class="dangrclr"><i class="fa fa-trash-o"></i>Delete</a></li>--}}
                                        </ul>
                                    </div>
                                </td>
                            </tr>
                            @endforeach     

标签： phplaravelforeign-keys