Skip empty rows in reading csv excel file in php

Question

I have a code where a csv file is uploaded ,the data is extracted from it and uploaded to database.Everything works fine,but how can i skip the empty rows and continue reading the rows with data in it.

This is the code where i extract data from csv file

if (($source = fopen( $csv_file, "r")) !== FALSE)
{
//read data from excel
while (($data = fgetcsv($source, 1000, ",")) !== FALSE)
{
    $question=$data[0];
    $point=$data[1];
    $header=$data[2];
    $footer=$data[3];
    $type_value=$data[4];
    $group_name=$data[5];
        echo $question;

}// while end

}

if (empty($data[0])) { continue; } something like this at the start of the while loop? — Bojan Radaković
– Bojan Radaković, Commented Feb 14, 2017 at 14:16

Mark Baker · Accepted Answer · 2017-02-14 14:23:35Z

1

If you use PHP's SplFileObject instead of the basic fgetcsv() function, it has built-in options to skip empty lines:

$file = new SplFileObject($csv_file);
$file->setFlags(SplFileObject::READ_CSV SplFileObject::SKIP_EMPTY | SplFileObject::DROP_NEW_LINE);
foreach ($file as $data) {
    ...
}

answered Feb 14, 2017 at 14:23

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

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

1 Comment

coder Over a year ago

Thats nice..Let me try that

Vega · Accepted Answer · 2017-11-04 17:30:15Z

1

if ($data[0] == NULL)
         continue;

This is because fgetcsv returns a non-empty array with a null element inside.

edited Nov 4, 2017 at 17:30

Vega

28.8k28 gold badges121 silver badges151 bronze badges

answered Nov 4, 2017 at 16:50

rubydio

1152 silver badges7 bronze badges

1 Comment

Shahroq Over a year ago

With this, if the first elemnt is empty, it skips the line altogether. (e.g: [, 1, 2]). Better line would be: if (count($data)<=1 & !$data[0]) continue;

Sascha A. · Accepted Answer · 2017-02-14 14:20:38Z

0

Try it with

if ($data === null) continue;

I didn't test it, but I sthink it should work.

answered Feb 14, 2017 at 14:20

Sascha A.

4,6463 gold badges17 silver badges34 bronze badges

Comments

Abdullah Mallik · Accepted Answer · 2017-02-14 14:20:49Z

0

Try this

if (($source = fopen( $csv_file, "r")) !== FALSE)
{
// read data from excel
    while (($data = fgetcsv($source, 1000, ",")) !== FALSE)
    {
        if ((string) $data[0] != '0' and empty($data[0]))
        {
            continue;
        }

        $question   = $data[0];
        $point      = $data[1];
        $header     = $data[2];
        $footer     = $data[3];
        $type_value = $data[4];
        $group_name = $data[5];

        echo $question;
    }
}

answered Feb 14, 2017 at 14:20

Abdullah Mallik

81110 silver badges21 bronze badges

2 Comments

coder Over a year ago

As there are many columns,a large set of conditions will be required right?

Abdullah Mallik Over a year ago

i minimized the condition. the reason i put (string) $data[0] != '0' in condition because empty() function treats 0 as empty value also

Collectives™ on Stack Overflow

Skip empty rows in reading csv excel file in php

4 Answers 4

1 Comment

1 Comment

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related