@extends('layouts.app')

@section('content')
        <h1>Accomodation</h1>
        <p>This is the accomodation page.</p>

    {!! Form::open(['action' => ['UserController@update', Auth::id()], 'method' => 'POST']) !!}
            <div class="form-group">
                    {{Form::label('ConsiderForAccommodation', 'Consider Me For Accommodation')}}
                    {{Form::checkbox('ConsiderForAccommodation', 'Consider Me For Accommodation', false)}}
            </div>
            {!! Form::token() !!}
            {{Form::hidden('_method', 'PUT')}}
            {{Form::submit('Submit', ['class' => 'btn btn-primary'])}}
    {!! Form::close() !!}
@endsection

/**
 * Update the specified resource in storage.
 *
 * @param  IlluminateHttpRequest  $request
 * @return IlluminateHttpResponse
 */
public function update(Request $request)
{
    // Update the given user
    $user = auth()->user();

    $user->ConsiderForAccommodation = $request->input('ConsiderForAccommodation');

    $user->save();

    return redirect('/accommodation');
}

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'Consider Me For Accommodation' for column 'ConsiderForAccommodation' at row 1 (SQL: update `users` set `updated_at` = 2019-03-18 20:44:37, `ConsiderForAccommodation` = Consider Me For Accommodation where `id` = 1)