douren0558 2018-08-31 14:56
浏览 47

如何在laravel上将数据保存到数据库时更改单元名称的内容

data excel like image below:

enter image description here

i want to change value when upload data from Excel to MySQL

if the cell has the name 'UNSIL' then when stored in the database will change to number '1'

i have code for uploading data from Excel to MySQL on laravel

public function importExcel(Request $request) {
        if($request->hasFile('import_file')) {
            $path = $request->file('import_file')->getRealPath();
            $data = Excel::load($path, function($reader) {})->get();
            if(!empty($data) && $data->count()) {
                foreach($data as $key => $value) {
                    $insert[] = ['nama_fakultas'=>$value->nama_fakultas,
                                 'nama_universitas'=>$value->nama_universitas,
                                 'keterangan'=>$value->keterangan
                                ];
                                if($value->nama_universitas = 'UNSIL') {
                                    $value->nama_universitas = '1';
                                }
                }
                if(!empty($insert)) {
                    DB::table('fakultas')->truncate($insert);
                    DB::table('fakultas')->insert($insert);

                    return redirect('fakultas');
                }

            }
        }
        return back();
    }

in the code above contains the data upload command from excel to mysql, and when I want to change the value of the name 'UNSIL' to number 1 nothing happens

can anyone help me for solve this case?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
    • ¥20 软件测试决策法疑问求解答
    • ¥15 win11 23H2删除推荐的项目,支持注册表等
    • ¥15 matlab 用yalmip搭建模型,cplex求解,线性化处理的方法
    • ¥15 qt6.6.3 基于百度云的语音识别 不会改
    • ¥15 关于#目标检测#的问题:大概就是类似后台自动检测某下架商品的库存,在他监测到该商品上架并且可以购买的瞬间点击立即购买下单
    • ¥15 神经网络怎么把隐含层变量融合到损失函数中?
    • ¥15 lingo18勾选global solver求解使用的算法
    • ¥15 全部备份安卓app数据包括密码,可以复制到另一手机上运行
    • ¥20 测距传感器数据手册i2c