ahmadajah03 Wed Feb 2021 1 year ago

Upload Content CSV ke Database di Laravel

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