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