Faced another problem. This time I do not know how to get a list of streets that are already in the database in order to create a house card.
public function create()
{
$streets = street::get();
return view('dashboard.house.created');
}
public function store(Request $request)
{
$this->validate($request, [
'home_number' => 'required',
'passport' => 'required',
'option_1' => 'required',
'street_id" => 'required',
'option_2' => 'required',
'option_3' => 'required',
'garage' => 'required',
'apartments' => 'required',
's_full' => 'required',
's_life' => 'required',
's_nlife' => 'required',
'status' => 'required',
'year_create' => 'required',
]);
$homes = Houses::query()->create([
'home_number' => $request->get('home_number'),
'passport' => $request->get('passport'),
'option_1' => $request->get('option_1'),
'option_2' => $request->get('option_2'),
'street_id' => $request->get('street_id),
'option_3' => $request->get('option_3'),
'garage' => $request->get('garage'),
'apartments' => $request->get('apartments'),
's_full' => $request->get('s_full'),
's_life' => $request->get('s_life'),
's_nlife' => $request->get('s_nlife'),
'status' => $request->get('status'),
'year_create' => $request->get('year_create'),
]
);
if ($request->hasFile('image') && $request->file('image')->isValid()) {
$homes->addMediaFromRequest('image')->toMediaCollection('images');
}
SQLSTATE[HY000]: General error: 1364 Field 'street_id' doesn't have a default value (SQL: insert into `house` (`home_number`, `passport`, `option_1`, `option_2`, `option_3`, `garage`, `apartments`, `s_full`, `s_life`, `s_nlife`, `status`, `year_create`, `updated_at`, `created_at`) values (91, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 1995, 2021-03-18 21:31:45, 2021-03-18 21:31:45))
I got this error, but I managed to get the list of streets as it should. Now how can I fill in this field when creating a house card?