Skip to content
Advertisement

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

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.

Advertisement

Answer

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 {
    ...
}
User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement