首页 > 解决方案 > 如何使用 Laravel 显示与用户相关的记录 int 配置文件?

问题描述

我想在与用户相关的用户个人资料中显示记录。不幸的是,我正在尝试这样做,它没有显示与用户相关的记录。这个怎么做?

数据库

        digitizing_orders table has user_id      

数字化订单

                    class Digitizingorder extends Model
                    {
                          protected $table="digitizing_orders";

                          public function user()
                          {
                          return $this->belongsTo('App\User');
                          }
                    }

用户模型

                     class User extends Authenticatable
                     {
                        public function digitizing()
                        {
                        return $this->hasMany('App\Digitizingorder','user_id');
                        }
                      }

控制器

                 public function index()
                 {
                 $data=
                  [
                 'digitizings'=>Digitizingorder::with('user')->where('id','=',Auth::id())->get()
                   ];
                   return view('front_end.Customerprofile.digitizing_view_order',$data);
                 }
                       

                       @foreach($digitizings  as   $digitizing)
                          <tr>
                          <td>1</td>
                          <td>DPO-{{$digitizing->id}}</td>
                          <td>{{$digitizing->order_name}}</td>
                          <td>{{$digitizing->created_at}}</td>
                          <td>-</td>
                          <td>$0.00</td>           
                          </tr>
                          @endforeach

标签: laravel

解决方案


由于您有hasMany关系,因此您可以像这样进行数字化:

  public function index()
             {
             $data=
              [
             'digitizings'=>Auth::user()->digitizing()->get()
               ];
               return view('front_end.Customerprofile.digitizing_view_order',$data);
             }

这将获得经过身份验证的用户的订单。


推荐阅读