当我尝试使用laravel中的datepicker更新日期字段时，在数据库中更新空白日期

Question

When I try to update my form with date field having jquery datapicker it store empty value on my database so the date field not updated in my form ..I am using date datatype in database for date field..

I added this in html field

<input type="text" id="datepicker" value="{{ old('datetime', $site->datatime) }}" name="datatime">

This is inside my controller

$site->update([
            'name'=>$request['name'],
            'copyright'=> $request['copyright'],
            'is_active'=>$request['status'] == 'true' ? 1 : 0,
            'message'=>$request['message'],
            'datatime'=>$request['datetime'],
            'url'=>$request['url'],
            'metadata'=>$request['metadata']

        ]);

Answer 1

This is most probably due to the wrong date format. Mysql accept YYYY-MM-DD for the date format. you can work around with the date e.x

$site->update([
        'name'=>$request['name'],
        'copyright'=> $request['copyright'],
        'is_active'=>$request['status'] == 'true' ? 1 : 0,
        'message'=>$request['message'],
        'datatime'=> date('Y-m-d', strtotime($request['datetime'])),
        'url'=>$request['url'],
        'metadata'=>$request['metadata']

    ]);