0

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?

Yura Lons
  • 71
  • 7

0 Answers0