Laravel 如何制作处理对象数组的 POST？

Question

这是我要插入的表的模型：

  protected $table ="final_schedule";

  public $timestamps = false;

  protected $fillable = [

    'CWID', //varchar

    'CRN', //int

    'Date_Registered'//date

  ];

这是我现在拥有的插入功能：

<?php

namespace App\Http\Controllers\Student;

use App\Http\Controllers\Controller;

use Illuminate\Http\Request;

use App\Models\finalScheduleModel;

class finalScheduleController extends Controller

{

    public function insert(Request $request){

      $finalSchedule = new finalScheduleModel;

      $finalSchedule->CWID=$request->input('CWID');

      $finalSchedule->CRN=$request->input('CRN');

      $finalSchedule->Date_Registered=$request->input('Date_Registered');

      $finalSchedule->save();

    }

}

路线： Route::post('insert/', 'Student\finalScheduleController@insert');

这是我希望它处理的数据：

[

    {

    "CWID":"C38475920",

    "CRN":345627,

    "Date_Registered":"2020-04-02"

    },

    {

    "CWID":"C38475920",

    "CRN":678595,

    "Date_Registered":"2020-04-02"

    },

    {

    "CWID":"C38475920",

    "CRN":473876,

    "Date_Registered":"2020-04-02"

    }

]

至少我认为是。上面的数据结构方式和这个一样吗？

(3) [{…}, {…}, {…}]

0: {…}

1: {…}

2: {…}

Answer 1

您甚至可以通过一次 insert 调用将多条记录插入表中$items = $request->all();$items = [&nbsp; &nbsp; [&nbsp; &nbsp; &nbsp; &nbsp;"CWID"=>"C38475920",&nbsp; &nbsp; &nbsp; &nbsp;"CRN"=>345627,&nbsp; &nbsp; &nbsp; &nbsp;"Date_Registered"=>"2020-04-02"&nbsp; &nbsp; ],&nbsp; &nbsp; [&nbsp; &nbsp; &nbsp; &nbsp;"CWID"=>"C38475920",&nbsp; &nbsp; &nbsp; &nbsp;"CRN"=>678595,&nbsp; &nbsp; &nbsp; &nbsp;"Date_Registered"=>"2020-04-02"&nbsp; &nbsp; ],&nbsp; &nbsp; [&nbsp; &nbsp; &nbsp; &nbsp;"CWID"=>"C38475920",&nbsp; &nbsp; &nbsp; &nbsp;"CRN"=>473876,&nbsp; &nbsp; &nbsp; &nbsp;"Date_Registered"=>"2020-04-02"&nbsp; &nbsp; ]]finalScheduleModel::insert($items);或者DB::table('final_schedule')->insert($items);