How to ignore/skip empty rows/lines in CSV file using php?

Question

I have a column of email addresses in a CSV file. I want to check if the email domain exist. I read the file using array as follow:

$domain = substr($arr[$line][$column], strpos($arr[$line][$column], '@') + 1);   
if  (checkdnsrr($domain) !== FALSE){
    echo $arr[$line][$column]. "    -->    Domain valid <br>";
}

The code works but how to ignore those lines which are empty in between? I get this line printed :

Warning: checkdnsrr(): Host cannot be empty in C:\xampp\htdocs\Trials\exist.php on line 18

How do you read the file?

Hanky Panky
– Hanky Panky

2014-06-02 03:50:55 +00:00
Commented Jun 2, 2014 at 3:50 — Hanky Panky
– Hanky Panky, Commented Jun 2, 2014 at 3:50

Devon Bessemer · Accepted Answer · 2014-06-02 03:47:51Z

1

 if (!empty($domain) and checkdnsrr($domain) !== FALSE) {

 }

answered Jun 2, 2014 at 3:47

Devon Bessemer

35.6k10 gold badges77 silver badges102 bronze badges

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

2 Comments

user3651085 Over a year ago

Now i am getting an error on the first line of my code: Notice: Undefined offset: 2 on line ...

Devon Bessemer Over a year ago

Whats the line in question? It may be best to employ both this method and the method Hanky Panky suggested in the initial reading of the file.

Janaka R Rajapaksha · Accepted Answer · 2014-06-02 03:52:54Z

1

you can use array_filter() to remove empty elements from the array:

array_filter($arr[$line]);

note: it should be an array inside of this array_filter function.

answered Jun 2, 2014 at 3:52

Janaka R Rajapaksha

3,7741 gold badge29 silver badges29 bronze badges

Collectives™ on Stack Overflow

How to ignore/skip empty rows/lines in CSV file using php?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related