Undefined offset: 1 Laravel/PHP uploading CSV

Question

I'm using a package > http://csv.thephpleague.com/

But I'm getting a Undefined offset: 1 when uploading, although the CSV does upload and works this error is thrown which obviously I don't the client see or think there's a problem.

Here's the method in question:

public function postUpload()
{
    $file = Input::file('file');
    $name = time() . '-' . $file->getClientOriginalName();
    $moved = $file->move(public_path() . '/uploads/CSV', $name);

    DB::table('wc_program_1')->truncate();

    $csv = new Reader($moved);
    $csv->setOffset(0); //because we don't want to insert the header
    $nbInsert = $csv->each(function ($row) use (&$sth) {
        DB::table('wc_program_1')->insert(
            array(

                'Road' => $row[0],
                'Parish' => $row[1],
                'WorkType' => $row[2],
                'TrafficManagement' => $row[3],
                'Duration' => $row[4],
                'Start' => $row[5]
            )
        );
        return true;
    });

    return Redirect::to('admin/programmes')->with('flash_success', 'Upload completed &amp; new data inserted.');
}

And here the table structure:

enter image description here

MonkeyZeus · Accepted Answer · 2014-04-11 20:20:16Z

2

There must be more to the error? Undefined Offset: 1 in somefile.php on line #4323 or w/e

Anyways it references a missing index from an array.

The only array I see is $row so $row[1] does not exist.

If you just want to quickly patch it then I suggest this:

'Parish' => (isset($row[1]) ? $row[1] : ''),

It would probably be a good idea to do this for all of them such as:

'Road' => (isset($row[0]) ? $row[0] : ''),

answered Apr 11, 2014 at 20:20

MonkeyZeus

20.8k4 gold badges41 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

the_unforgiven_II Over a year ago

This is the line its showing 'Parish' => $row[1],

the_unforgiven_II Over a year ago

Yes I'm going to try that for each of them, i was just answering your question :)

the_unforgiven_II Over a year ago

Yes and that worked so i'm guessing it was an empty field in the CSV somewhere then so now that worked a treat thanks dude!

MonkeyZeus Over a year ago

Yep no problem! If you want then you can suppress errors completely by placing error_reporting(0); at the beginning of the PHP file which I strongly recommend for a production environment and use E_ALL in a development environment.

the_unforgiven_II Over a year ago

Laravel pretty much does that for you anyhow! I just couldn't work why the error was been thrown. But hey thanks all the same for your help/advice.

CreativeNerdSam · Accepted Answer · 2015-04-02 09:43:07Z

0

I also came across this issue however I believe my issue may have been slightly different to yours.

Within my CSV I was uploading I hadn't set the column titles and had left blank fields so despite the offset being set it was still trying to parse the row.

In short, ensure that you don't leave blank cells in the header!

answered Apr 2, 2015 at 9:43

CreativeNerdSam

535 bronze badges

Collectives™ on Stack Overflow

Undefined offset: 1 Laravel/PHP uploading CSV

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related