問題描述

我在數據庫中有 3 個表(用戶、區域、區域用戶)，

用戶表:ID名稱用戶名密碼

區域表:ID姓名

area_user 表:ID用戶身份area_id

我正在嘗試創建一個(列出用戶頁面)，它將顯示所有用戶表列以及用戶分配的區域.

User.php 模型文件

 belongsToMany('AppArea','area_user');}

Area.php 模型文件:

belongsToMany('AppUser','area_user','area_id','user_id');}}

UserController@index 文件:

middleware('auth');}/*** 顯示資源列表.** @return IlluminateHttpResponse*/公共函數索引(){$users = User::get();return view('users._list',['用戶'=>$用戶]);}

最后是表格視圖文件:-

@foreach($users as $u)<tr role="row" class="odd"><td class="sorting_1">{{$u->name}}</td><td></td><td>{{$u->areas]}}</td><td>{{route('show_user', ['id' => $u->id])}}</td></tr></tbody>@endforeach

如果我只使用區域屬性 ($u->areas) 在用戶表視圖(指定區域)中輸入，它將顯示所有區域列:-

<小時>

 @foreach($users as $u)<tr role="row" class="odd"><td class="sorting_1">{{$u->name}}</td><td></td><td>{{$u->areas->name]}}</td><td>{{route('show_user', ['id' => $u->id])}}</td></tr></tbody>@endforeach

請注意，如果我在上面的視圖 ($u->areas->name) 中指定區域關系中的列名，則顯示錯誤:-

此集合實例上不存在屬性 [名稱].(查看:C:xampphtdocs

如何在視圖文件中只顯示(areas.name)列

因為 areas 是一個集合，所以你應該像這樣循環:

@foreach($users as $u)<tr role="row" class="odd"><td class="sorting_1">{{$u->name}}</td><td></td><td>@foreach($u->areas as $area){{$area->name}},@endforeach</td><td>{{route('show_user', ['id' => $u->id])}}</td></tr></tbody>@endforeach

如果你想用逗號分隔它們，你可以這樣做而無需循環:

 @foreach($users as $u)<tr role="row" class="odd"><td class="sorting_1">{{$u->name}}</td><td></td><td>{{ $u->areas->pluck('name')->implode(', ') }}</td><td>{{route('show_user', ['id' => $u->id])}}</td></tr></tbody>@endforeach

I have 3 tables in DB (users , areas , area_user),

Users table: id name username password

areas table: id name

area_user table: id user_id area_id

I am trying to create a (List users page) which will show all user table column with user assigned areas.

User.php Model file

  <?php

namespace App;

use IlluminateNotificationsNotifiable;
use IlluminateFoundationAuthUser as Authenticatable;

class User extends Authenticatable{
    use Notifiable;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = ['name', 'email', 'password','role_id',];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = ['password', 'remember_token',];

    public function areas(){
        return $this->belongsToMany('AppArea','area_user');
    }

Area.php Model file:

<?php

namespace App;

use IlluminateDatabaseEloquentModel;

class Area extends Model{
    protected $fillable = ['name'];

    public function users(){
        return $this->belongsToMany('AppUser','area_user','area_id','user_id');
    }
}

UserController@index file :

<?php

namespace AppHttpControllers;

use AppAreas;
use AppRoles;
use AppUser;
use IlluminateHttpRequest;

class UserController extends Controller{

    public function __construct(){
        // $this->middleware('auth');
    }

    /**
     * Display a listing of the resource.
     *
     * @return IlluminateHttpResponse
     */
    public function index(){
        $users = User::get();
        return view('users._list',
        ['users'=> $users]
    );
    }

Finally the table view file:-

@foreach($users as $u)
            <tr role="row" class="odd">
                <td class="sorting_1">{{$u->name}}</td>
                <td></td>
                <td>{{$u->areas]}}</td>
                <td>{{route('show_user', ['id' => $u->id])}}</td>
            </tr></tbody>
@endforeach

If i typed in user table view (assigned areas) with only using the areas property ($u->areas), it will show all the areas column:-

[
  {
    "id": 3,
    "name": "C",
    "location_id": 1,
    "created_at": null,
    "updated_at": null,
    "pivot": {
      "user_id": 4,
      "area_id": 3
    }
  },
  {
    "id": 4,
    "name": "D",
    "location_id": 2,
    "created_at": null,
    "updated_at": null,
    "pivot": {
      "user_id": 4,
      "area_id": 4
    }
  }
]

 @foreach($users as $u)
                <tr role="row" class="odd">
                    <td class="sorting_1">{{$u->name}}</td>
                    <td></td>
                    <td>{{$u->areas->name]}}</td>
                    <td>{{route('show_user', ['id' => $u->id])}}</td>
                </tr></tbody>
    @endforeach

Notice that if i specify the column name in Areas relationship in the above view ($u->areas->name) , error showing:-

Property [name] does not exist on this collection instance. (View: C:xampphtdocs

How can i show only the (areas.name) column in view file

Because the areas is a collection so you should loop over it like this :

@foreach($users as $u)
    <tr role="row" class="odd">
        <td class="sorting_1">{{$u->name}}</td>
        <td></td>
        <td>
        @foreach($u->areas as $area)
            {{$area->name}}, 
        @endforeach
        </td>
        <td>{{route('show_user', ['id' => $u->id])}}</td>
    </tr></tbody>
@endforeach

And if you want to separate them whith comma for example you can do it like that without looping :

    @foreach($users as $u)
    <tr role="row" class="odd">
        <td class="sorting_1">{{$u->name}}</td>
        <td></td>
        <td>
            {{ $u->areas->pluck('name')->implode(', ') }}
        </td>
        <td>{{route('show_user', ['id' => $u->id])}}</td>
    </tr></tbody>
@endforeach

這篇關于此集合實例上不存在屬性 [名稱]的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！