Laravel :如何从excel文件中导入图像并将其存储到数据库中？开发者社区

link之家

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

深情的煎鸡蛋 · docker ...· 1 年前 ·

心软的打火机 · linux ...· 1 年前 ·

谦虚好学的香槟 · Address false ...· 1 年前 ·

愉快的墨镜 · 一个困扰多日的python django ...· 2 年前 ·

帅气的松球 · JNI 中局部引用和全局引用 - 知乎· 2 年前 ·

<?php
namespace App\Imports;
use App\SubmissionDetail;
use Maatwebsite\Excel\Row;
use Maatwebsite\Excel\Concerns\OnEachRow;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
class SubmissionDetailImport implements OnEachRow, WithHeadingRow
    protected $id;
    function __construct($id) {
            $this->id = $id;
    public function onRow(Row $row)
        $row = $row->toArray();
        $submissionDetails = SubmissionDetail::firstOrCreate(
            ['submission_id' => $this->id, 'nama_barang' => $row['nama_barang']],
                'submission_id' => $this->id,
                'nama_barang' => $row['nama_barang'],
                'image_path' => $row['image_path'],
                'jumlah' => $row['jumlah'],
                'harga_satuan' => $row['harga_satuan'],
                'harga_total' => $row['harga_total'],
                'keterangan' => $row['keterangan'],
        if (! $submissionDetails->wasRecentlyCreated) {
            $submissionDetails->update([
                'image_path' => $row['image_path'],
                'jumlah' => $row['jumlah'],
                'harga_satuan' => $row['harga_satuan'],
                'harga_total' => $row['harga_total'],
                'keterangan' => $row['keterangan'],
}

$reader      = new Xls();
$spreadsheet = $reader->load(public_path(''));
$sheet       = $spreadsheet->getActiveSheet();
//getting the data from xls
$array_rows_data    = array();
$highestRow         = $sheet->getHighestRow();
$highestColumn      = $sheet->getHighestColumn();
$highestColumnIndex = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($highestColumn);
for ($row = 2; $row <= $highestRow; ++$row) {
                $array_row = array();
                for ($col = 1; $col <= 56; ++$col) {
                    $value = $sheet->getCellByColumnAndRow($col, $row)->getValue();

推荐文章

深情的煎鸡蛋 · docker 在已经启动的容器中开启端口映射_docker 已运行容器映射端口-CSDN博客

1 年前

心软的打火机 · linux sed命令删除一行/多行_sed删除第一行/linux删除文件某一行_sed 删除匹配行-CSDN博客

1 年前

谦虚好学的香槟 · Address false positives/negatives in Microsoft Defender for Endpoint - Microsoft Defender for Endpoi

1 年前

愉快的墨镜 · 一个困扰多日的python django uwsgi内存泄露排查_django项目内存泄漏的原因_Workings的博客-CSDN博客

2 年前

帅气的松球 · JNI 中局部引用和全局引用 - 知乎

2 年前

问 Laravel :如何从excel文件中导入图像并将其存储到数据库中？

回答 1

Stack Overflow用户