laravel - 不能用雄辩的方式从其他表中调用值
问题描述
@foreach($sudah as $sudah)
<tr>
<td class=" font-size-sm">{{$sudah->nama}}</td>
<td class="text-center font-size-sm">{{$sudah->nik}}</td>
<td class="text-center font-size-sm">{{$sudah->nkk}}</td>
<td class="text-center font-size-sm">
<em >{{ date('d-M-Y H:i:s', strtotime($sudah->created_at))}}</em>
</td>
<td class="text-center d-none d-sm-table-cell">
<span class="badge badge-success">{{$sudah->validasi_pbu->user->name}}</span>
</td>
<td class="text-center font-size-sm">
<a href="javascript:void(0)" data-toggle="tooltip" data-placement="top" title="Detail">
<i class="fa fa-fw fa-list-alt"></i>
</a>
<a href="javascript:void(0)" data-toggle="tooltip" data-placement="top" title="Edit">
<i class="fa fa-fw fa-edit"></i>
</a>
<a href="javascript:void(0)" data-toggle="tooltip" data-placement="top" title="Delete">
<i class="fa fa-fw fa-trash-alt"></i>
</a>
</td>
</tr>
@endforeach
public function index(){
$belum = DB::table('datapemilihbaru')->where('validasi','0')->get();
$sudah= datapemilihbaru::where('validasi','1')->get();
return view('/pages/admin/validasi',compact('sudah','belum'));
}
class datapemilihbaru extends Model
{
protected $primaryKey = 'id';
protected $table = 'datapemilihbaru';
protected $fillable = ['email','nama_lembaga','KEC','Desa_Kel','nkk', 'nik','nama','tempat_lahir','tanggal_lahir','kawin','jenis_kelamin','alamat','rt','rw','difabel','status_ktp','keterangan','foto_ktp','foto_ktpfp','foto_kk','foto_kkfp','validasi'];
public function User(){
return $this->belongToMany('App\User','validasi_pbu','datapemilihbaru_id','users_id')->withTimeStamps();
}
}
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use App\datapemilihbaru;
use App\User;
class validasi_pbu extends Model
{
protected $table = 'validasi_pbu';
protected $fillable = ['users_id','datapemilihbaru_id'];
protected $primaryKey = 'id';
}
<?php
namespace App;
use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;
use Illuminate\Database\Eloquent\Model;
use App\datapemilihbaru;
class User extends Authenticatable
{
use Notifiable;
protected $table = 'users';
protected $primaryKey = 'id';
public function datapemilihbaru(){
return $this->belongsToMany('App\datapemilihbaru','validasi_pbu','users_id','datapemilihbaru_id')->withTimeStamps();
}
/**
* The attributes that are mass assignable.
*
* @var array
*/
protected $fillable = [
'name', 'email', 'password',
];
/**
* The attributes that should be hidden for arrays.
*
* @var array
*/
protected $hidden = [
'password', 'remember_token',
];
/**
* The attributes that should be cast to native types.
*
* @var array
*/
protected $casts = [
'email_verified_at' => 'datetime',
];
}
这是我尝试从用户那里调用名称时的结果在 此处输入图像描述
但是,当我尝试调用 validasi_pbu 值时,结果只是空值,即使 validation_pbu 表包含内容
这是结果(在divalidasi oleh列下)
请有人帮助我:(我是新手
解决方案
推荐阅读
- r - R在绘图上编程以标记轴
- mongodb - Mongoose.populate() 不会在模型中产生任何变化
- python - Python Spark Dataframe:将字符串列转换为时间戳
- python - 在python中对两个或多个数字求和
- javascript - 如何从托管在不同环境中的文件中执行 Heroku 托管的 node.js 文件中的函数?
- android - Ionic 4:您需要使用不同的包名称,因为 Google Play 中已经存在“io.ionic.starter”
- jquery - 使用 query.serializeJSON 序列化表单数据
- testing - 如何在 Testcafe 上调整屏幕截图的浏览器窗口大小
- javascript - 如果我使用 ajax 向 dom 添加新元素,我如何使用 url 查询字符串来做同样的事情?
- http - 在互联网上,当服务器处于最大容量时,请求会发生什么