I want to get the Rating table ID , but in my jason then will give me the attributes table id when we apply this joins, MY QUERY:
$search = \Request::get('q');
$u_id = User::find($id);
$records = DB::table('ratings')->where('user_id' , $id)-
>where('user_id' , $id)->where(function($q) use ($search){
$q->where('attribute' , 'like' , '%' .$search. '%');
$q->orwhere('score' , 'like' , '%' .$search. '%');
$q->orwhere('attrtype' , 'like' , '%' .$search. '%');
})
->join('users','ratings.user_id','=','users.id')->join('attributes'
, 'attributes.id' , '=' ,'ratings.attribute_id' )->Paginate(5);
dd($records);
return view('employee.show',compact('records' , 'u_id' , 'search'));
After this we Get the ID of Attribute table ,
But we get the Rating tables ID , Thanks Developers in advance.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire