如何上传和保存数据从excel到数据库?

vddsk6oq  于 2021-06-19  发布在  Mysql
关注(0)|答案(0)|浏览(174)

我有一个excel文件,我想上传和保存数据到数据库。如果第一行的头,我下面的代码工作得很好,

但是如果标题像下面的pict,我的代码是错误的,如果我有下面的表格,如何读取标题

if($request->hasFile('file')){
   $extension = File::extension($request->file->getClientOriginalName());

    if ($extension == "xlsx" || $extension == "xls" || $extension == "csv") {

        $path = $request->file->getRealPath();
        $data = Excel::load($path, function($reader) {
        })->get();

        if(!empty($data) && $data->count()){

            foreach ($data as $value) {
                $insert['data'] = [
                'no'  => $value->no,
                'name'  => $value->name,
                'ic_no' => $value->ic_no,
                'disburse_date' => $value->disburse_date,
                'product_type_description' => $value->product_type_description,
                'amount_release' => $value->amount_release,
                'amount' => $value->amount,
                'date_disburse' => $value->date_disburse,
                'net_disbursement' => $value->net_disbursement,
                ];

                Loandisburse::where('ic', $value['ic_no'])
                   ->where('stage','W11')
                   ->update(array('status_upload'=>'1',
                   'amount_release' => $value['amount_release'],
                   'amount' => $value['amount'],
                   'date_disburse' => $value['date_disburse'], 
                   'net_disbursement' => $value['net_disbursement'],
                   'disburse_date' => $value['disburse_date'],
                   'product_type_description' => $value['product_type_description'],
                   'hash'=> $hash,
                   'month'=> $month,
                   'year'=>$nyear
                  ));
                  }
                }
                 return redirect('/upload/amount');
                }
            }

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题