Laravel您要求1件物品，但只有0件物品可用

Question

I am getting row's column randomly to seed database, using eloquent :

$physician = SelectOption::where('select_option_group_id', 1)->pluck('name')->random();

it works if data exists in select_options table. But if it does not exists, it gives an error :

You requested 1 items, but there are only 0 items available.

I want to leave it empty, if it's empty.

Answer 1

Check if collection is not empty prior doing random():

$collection = SelectOption::where('select_option_group_id', 1)->pluck('name');
if (!$collection->isEmpty()) {
    $physician = $collection->random();
} else {
    ...
}