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

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 {
    ...
}

Answer 2

Use inRandomOrder() instead:

$physician = SelectOption::where('select_option_group_id', 1)->inRandomOrder()->first();
$name = is_null($physician) ? 'No data available' : $physician->name;