PHP - check if csv line is empty

Question

In my code I'm reading csv file with fgetcsv function

while($line = fgetcsv($handle, 4096)){
    .....
}

How can check when the $line is empty, I mean $line = ',,,,,,,,' ?
note: I'm not always know the number of columns.

I've linked a very similar question that was asked a few days ago, the accepted answer will easily handle your problem with some edits — sjagr, Feb 03 '14 at 17:01
You can simply check if(!empty($line[0])){ //your logic } $line[0] for first column, $line[1] for second column same for other — Ajay Gadhavana, Feb 11 '22 at 15:24

score 1 · Answer 1 · answered Feb 03 '14 at 16:57

1

One way to do it would be:

if (str_replace(array(',', ' '), '', $line) != '') {
  // do something
}

Basically, it will compare the line after you remove all comma's and spaces from the string.

answered Feb 03 '14 at 16:57

Nick

6,316
2
29
47

score 0 · Answer 2 · edited Feb 03 '14 at 17:07

0

You can take the contents of file in an array and check which index has empty value. like this -

$handle = fopen("file.csv","r");
$data = fgetcsv($handle,",");
while($data = fgetcsv($handle)) 
{
$array = explode(",",$data[0]);
print_r($array);
}
fclose($handle);

edited Feb 03 '14 at 17:07

analyticalpicasso

1,993
8
26
45

answered Feb 03 '14 at 16:57

Avneesh

149
1
1
7

PHP - check if csv line is empty

2 Answers2