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

link之家

链接快照平台

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

相关文章推荐

愉快的匕首 · linux - Install ...· 1 年前 ·

儒雅的炒饭 · 浅谈逻辑选择器 -- 父选择器它来了！ - ...· 2 年前 ·

纯真的骆驼 · vue中展示3D模型 -- ...· 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();

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

回答 1

Stack Overflow用户