dsafew1231 2018-10-04 05:43
浏览 319

Laravel Excel导入Maatwebsite

I found the code form this website http://itsolutionstuff.com/post/laravel-56-import-export-to-excel-and-csv-exampleexample.html

This is my route after editing:

Route::post('barang', 'BarangController@importExcel')->name('barang');

This is their Controller, and I just Adding on foreach :

public function importExcel(Request $request)
    {
        $request->validate([
            'import_file' => 'required'
        ]);

        $path = $request->file('import_file')->getRealPath();
        $data = Excel::load($path)->get();

        if($data->count()){
            foreach ($data as $key => $value) {
                $arr[] = [
                    'kode_barang' => $value->kode_barang, 
                    'nama_barang' => $value->nama_barang, 
                    'kategori_id' => $value->kategori_id, 
                    'jumlah_barang' => $value->jumlah_barang, 
                    'harga_satuan' => $value->harga_satuan, 
                    'tanggal_inputan' => $value->tanggal_inputan, 
                    'deskripsi' => $value->deskripsi, 
                    'status' => $value->status,

                ];
            }

            if(!empty($arr)){
                Item::insert($arr);
            }
        }

        return back()->with('success', 'Insert Record successfully.');
    }

And I Just Adding this on my View :

<form action="{{ route('barang') }}" class="form-horizontal" method="post" enctype="multipart/form-data">
@csrf

@if ($errors->any())
<div class="alert alert-danger">
<a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>
<ul>
@foreach ($errors->all() as $error)
<li>{{ $error }}</li>
@endforeach
</ul>
</div>
@endif

@if (Session::has('success'))
<div class="alert alert-success">
<a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>
<p>{{ Session::get('success') }}</p>
</div>
@endif
<input type="file" name="import_file" />
<button class="btn btn-primary">Import File</button>
</form>

The result show data has insert successfully, but nothing data has insert to my table.

Here my excel CSV format :

R4B6,MONITOR LENOVO,ELEKTRONIK,1,-,10/4/2018,-,Aktif

So, how to make the code right for insert into DB ?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 unity第一人称射击小游戏,有demo,在原脚本的基础上进行修改以达到要求
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
    • ¥15 关于#Java#的问题,如何解决?
    • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算
    • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
    • ¥15 cmd cl 0x000007b
    • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line