這里是一個示例，如果您想在db中上傳csv文件，請>public function upload(Request $request){ //upload csv

$file = $request->file('file');

$csvData = file_get_contents($file);

$rows = array_map("str_getcsv", explode("\n", $csvData));

//CSV headers

$header = array_shift($rows);

$d = new Department;

$escapedHeader=[];

//to converting lowercase and remove spaces

foreach ($header as $key => $value) {

$lheader=strtolower($value);

$escapedItem=preg_replace('/[^a-z]/', '', $lheader);

array_push($escapedHeader, $escapedItem);

}

//storing data to database

foreach($rows as $row) {

if (count($header) != count($row)) {

continue;

}

//This will generate a associate array with headers.

$row = array_combine($escapedHeader, $row);//dd($row);

// if there are 3 tables named - student, course, grade

Student::create([

'fname' => $row['firstname'],

'lname' => $row['lastname'],

]);

Course::create([

'course' => $row['course'],

]);

Grade::create([

'grade' => $row['score'],

]);

}

Session::flash('message', 'CSV file imported!');

return response()->json('success');

}

總結

以上是生活随笔為你收集整理的php 多个 csv 文件,php - 如何将CSV文件上传到多个数据库目录中？ - SO中文参考 - www.soinside.com...的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內容還不錯，歡迎將生活随笔推薦給好友。