Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

Ngozistephen's avatar

Date Range Picker in laravel 8

pls i new to laravel, i have tried sending my request to my database but is giving me this response message "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'end_data' in 'field list' (SQL: insert into porfolios (job_title, project_name, user_id, content, end_data, start_data, featured_img, published_at, updated_at, created_at)

this is my porfolio controller public function store(StorePorfolioRequest $request){

    $porfolio = new Porfolio;

    $porfolio->job_title = $request->job_title;
    $porfolio->project_name = $request->project_name;
    $porfolio->user_id = Auth::user()->id;
    $porfolio->content = $request->content;
    $porfolio->end_data = $request->end_date;
    $porfolio->start_data = $request->start_date;
    $porfolio->featured_img = $this->upload_image($request);
    $porfolio->published_at = $request->filled('published') ? Carbon::now() : null;
    
    $porfolio->save();

    return response()->json('ok', 201); 
}

my script in the view const dates = $('input[name="dates"]').val().split('-'); const startdate = dates[0].trim(); const enddate = dates[1].trim();

      var content = $('#compose-textarea').summernote('code');

      formData.delete('dates');
 
      formData.append('content', content);
      formData.append('endDate', enddate);
      formData.append('startDate', startdate);
0 likes
2 replies
vybeauregard's avatar

Looks like a typo: $portfolio->end_data vs $request->end_date, same with start_date

Please or to participate in this conversation.