這是我要插入的表的模型： protected $table ="final_schedule"; public $timestamps = false; protected $fillable = [ 'CWID', //varchar 'CRN', //int 'Date_Registered'//date ];這是我現在擁有的插入功能：<?phpnamespace 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: {…}
1 回答
喵喵時光機
TA貢獻1846條經驗 獲得超7個贊
您甚至可以通過一次 insert 調用將多條記錄插入表中
$items = $request->all();
$items = [
[
"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"
]
]
finalScheduleModel::insert($items);
或者
DB::table('final_schedule')->insert($items);
- 1 回答
- 0 關注
- 137 瀏覽
添加回答
舉報
0/150
提交
取消