Breaking News: Grepper is joining You.com. Read the official announcement!

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'garden' cannot be null (SQL: insert into `legacies` (`garden`, `invoice`, `qty`, `grade`, `package`, `updated_at`, `created_at`) values (, , , , , 2023-06-18 12:10:34, 2023-06-18 12:10:34))

Ian Okonu answered on June 18, 2023 Popularity 2/10 Helpfulness 1/10

answer SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'garden' cannot be null (SQL: insert into `legacies` (`garden`, `invoice`, `qty`, `grade`, `package`, `updated_at`, `created_at`) values (, , , , , 2023-06-18 12:10:34, 2023-06-18 12:10:34))

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'garden' cannot be null (SQL: insert into `legacies` (`garden`, `invoice`, `qty`, `grade`, `package`, `updated_at`, `created_at`) values (, , , , , 2023-06-18 12:10:34, 2023-06-18 12:10:34))

Comment

private function parseInvoiceData($file)
{
    $rows = Excel::toArray(new LegaciesImport(), $file);
    $parsedData = [];

    foreach ($rows as $row) {
        $garden = $row['Garden'] ?? null;
        $invoice = $row['Invoice'] ?? null;
        $balanceQty = $row['Balance Qty'] ?? null;
        $grade = $row['Grade'] ?? null;
        $packageType = $row['Package Type'] ?? null;

        // Skip the row if any of the required fields is empty
        if (empty($garden) || empty($invoice) || empty($balanceQty) || empty($grade) || empty($packageType)) {
            continue;
        }

        $parsedData[] = [
            'Garden' => $garden,
            'Invoice' => $invoice,
            'Balance Qty' => $balanceQty,
            'Grade' => $grade,
            'Package Type' => $packageType,
        ];
    }

    return $parsedData;
}

Popularity 2/10 Helpfulness 1/10 Language php

Source: chat.openai.com

Tags: insert-into integrity null php

Link to this answer
Share Copy Link

Contributed on Jun 18 2023

Ian Okonu

0 Answers Avg Quality 2/10

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'garden' cannot be null (SQL: insert into `legacies` (`garden`, `invoice`, `qty`, `grade`, `package`, `updated_at`, `created_at`) values (, , , , , 2023-06-18 12:10:34, 2023-06-18 12:10:34))

Contents

More Related Answers

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'garden' cannot be null (SQL: insert into `legacies` (`garden`, `invoice`, `qty`, `grade`, `package`, `updated_at`, `created_at`) values (, , , , , 2023-06-18 12:10:34, 2023-06-18 12:10:34))

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.