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

相关文章推荐

奔跑的骆驼 · 结合使用 Oracle Database ...· 3 天前 ·

快乐的卤蛋 · Array.prototype.slice( ...· 1 年前 ·

飘逸的荔枝 · 如何在Pandas中筛选具有多级列头的列？· 2 年前 ·

道上混的西红柿 · java - 为 FileWriter ...· 2 年前 ·

愉快的黄豆 · C++实现string存取二进制数据的方法_ ...· 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用户