Thas my controller file
public function myFriends()
{
Logged user
$uid = Auth::user()->id;
Getting result from friendships table
$friends1 = DB::table('friendships')
->leftJoin('users', 'users.id','=', 'friendships.user_requested') // whos is not loogged in but send the request
->where('status', 1)
->join('profiles', 'profiles.user_id', '=', 'friendships.requester')
->where('requester', $uid)
->get();
I have one more array friends2 i just skip that
$friends = array_merge($friends1->toArray(), $friends2->toArray());
return view('profile.friends', compact('friends'));
My view page
@foreach($friends as $uList)
*if in there column value has NULL then don't show follwers*
@if($uList->followingeach == NULL )
{
<?php echo Auth::user()->name .'You dont have follwers' ?>
}
@else
{
<?php echo Auth::user()->name .'Yes You have follwers' ?>
}
@endif
My DB columns
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire