如何检查Eloquent查询结果中的特定列？

Question

I have free bonus system on my web. In this system. There are 2 tables 1 "deposit " and other is plan. In deposit there is column "plan_id" I want if user has record with plan_d 8 then he should alert message ." You already subscribe free bonus"

I tried following.

$sit = Deposit::where('plan_id', Plan::id)->first();

if ($sit == 8) {
    session()->flash('message', 'Please Add fund at least once to withdraw life time.');
    Session::flash('type', 'warning');
    Session::flash('title', 'warning');
    return redirect()->back();
} 

Answer 1

You're basically checking that a model instance equals 8.

The following will return an instance of Deposit or null;

$sit = Deposit::where('plan_id', Plan::id)->first();

So your if statement should be;

if ($sit && $sit->plan_id == 8) {
    ...
}