laravel where if get a single value

onur 0
Viewed 23

enter image description here

Hello there I want to write a query. I want to select the status id 1, but if there is no 1, the last 0 will be selected. I just want to get meter value

laravel
1 Answers
//get latest row with status = 1
    $unitMeter = DB::table('unit_meters')->where('status','=',1)->latest()->first();
    if (!$unitMeter){// if is null
        $unitMeter = DB::table('unit_meters')->where('status','=',0)->latest()->first();
    }
    if ($unitMeter){// if isn't null ( mean it's object )
        $meter = $unitMeter->meter;
    }

Also, add this in top of your controller:

use Illuminate\Support\Facades\DB;

I hope it helps!

Royal_MGH0
Related