laravel DB existence check

Question

i want to make website which has 'like' and 'dislike'

i made controller

public function addLike($id)
{
    $feeling = new Feeling();
    $feeling->post_id = $id;
    $feeling->user_id = Auth::user()->id;

    $feeling->like = 1;

    $feeling->check = 1;

    if ($dd = DB::table('feelings')->where('post_id',  $feeling->post_id)->where('user_id',  Auth::user()->id)->get()) {
        dd($dd);
        return redirect()->route('post.show', ['feeling' => $feeling, 'id' => $id]);
    } else {
        $feeling->save();
        return redirect()->route('post.show', ['feeling' => $feeling, 'id' => $id]);
    }
}

i thought if(feeling is $feeling = new Feeling, and Feeling is my like,dislike model) when feeling's post number and user number exist on feelings table, i just return redirect

else, if post number and user number both doesn't exist together i want to save and direct

but i have problem ->>> when post number and user number both doesn't exist together, i checked my web doesn't work properly so i put dd($dd), and saw

Illuminate\Support\Collection {#360 ▼
  #items: []
}
$dd = DB::table('feelings')->where('post_id',  $feeling->post_id)->where('user_id',  Auth::user()->id)
dd($dd)

had made this kind of empty array.

how can i check feeling's post number and user number's existence?

an empty collection would still be evaluated to true so you need another mechanism to check if the collection is empty or not. One is to use isNotEmpty method, as in: ..->id)->get()->isNotEmpty() Or use exists method Refer here: laravel.com/docs/8.x/collections#method-isnotempty — user3532758
– user3532758, Commented Aug 15, 2021 at 4:14

user3532758 · Accepted Answer · 2021-08-15 06:22:46Z

1

An empty collection would still be evaluated as true inside the if statement. There are different ways to check for the existence of records in Larave.

One is exists()

$exists = DB::table('feelings')->where('post_id',  $feeling->post_id)->where('user_id',  Auth::user()->id)->exists();
//$exists returns true is record exists, otherwise false

Check if record collections is empty or not using isEmpty() or isNotEmpty():

$empty = DB::table('feelings')->where('post_id',  $feeling->post_id)->where('user_id',  Auth::user()->id)->get()->isEmpty();
//$empty returns true if no result

Refer here to check available methods: https://laravel.com/docs/8.x/collections

edited Aug 15, 2021 at 6:22

answered Aug 15, 2021 at 4:24

user3532758

2,2811 gold badge14 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3532758 Over a year ago

@lagbox my bad it was supposed to be calling isEmpty() after calling get(). Thanks.

Collectives™ on Stack Overflow

laravel DB existence check

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related