Upload Content CSV ke Database di Laravel - Tambahkan kode di bawah ini di tag formulir HTML Anda.
<form action="/csvfileupload" method="post" enctype="multipart/form-data">
Code Controller:
public function csvfileupload(Request $req)
{
if ($request->hasFile('csvfile')) {
$path = $request->file('csvfile')->getRealPath();
$data = \Excel::load($path)->get();
if ($data->count()) {
foreach ($data as $key => $value) {
$arr[] = ['title' => $value->title,
'address' => $value->address,
'Date' => $value->Date,
'intro' => $value->intro,
'mainbody' => $value->mainbody,
'paragraph' => $value->paragraph,
'footer' => $value->footer,
];
}
if (!empty($arr)) {
DB::table('template')->insert($arr);
return "Success";
}
}
}
}
Catatan: Pastikan Anda memperbarui file .env dengan pengaturan database seperti
Misalnya
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=your_database_name
DB_USERNAME=root
DB_PASSWORD=
upload csv laravel
laravel
import csv laravel