PHP parse empty data from csv file

Question

I'm trying to get data from a csv file line by line using PHP, and then insert into Mysql.

Some of the values in the rows of the csv file are empty, and need to be loaded as Null values into Mysql. I can't seems to check these values though. I've tried:

        if (strlen($csv[9])==0) {
            $follow_up1 = null;
        } else {
            $follow_up1 = $mysqli->real_escape_string($csv[9]);
        }

or:

    if (empty($csv[9]) {
        $follow_up1 = null;
    } else {
        $follow_up1 = $mysqli->real_escape_string($csv[9]);
    }

or:

    if (is_null($csv[9]) {
        $follow_up1 = null;
    } else {
        $follow_up1 = $mysqli->real_escape_string($csv[9]);
    }

How can I check if the cell value is empty?

How do you parse your data? What exactly marks it as "empty"? — Nico Haase
– Nico Haase, Commented Jul 4, 2018 at 12:55
It seems you are concatenating an sql query from your variable names. Setting a variable to null will then not write a null value to the database, as you would need to put the string NULL without quotes into the query. Instead you should use prepared statements, then you can pass null values, and also get rid of the real_escape_string, and be save(r) against sql injection. — Karsten Koop
– Karsten Koop, Commented Jul 4, 2018 at 13:05

Nicu-Cristian Vlad · Accepted Answer · 2018-07-04 13:06:30Z

1

at the second example you are missing a ")" so this might throw you an error.

if (empty($csv[9])) {
        $follow_up1 = null;
    } else {
        $follow_up1 = $mysqli->real_escape_string($csv[9]);
    }

you could also search :

$follow_up1 = $csv[9] === '' ? null : $mysqli->real_escape_string($csv[9]);

or :

 $follow_up1 = $csv[9] === "NULL" ? null : $mysqli->real_escape_string($csv[9]);

that if what you have there is an empty string .

answered Jul 4, 2018 at 13:06

Nicu-Cristian Vlad

9810 bronze badges

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

Comments

jeromegamez · Accepted Answer · 2018-07-04 13:10:35Z

1

This should do:

if (trim($csv[9]) === '') {
    $follow_up1 = null;
} else {
    $follow_up1 = $mysqli->real_escape_string($csv[9]);
}

answered Jul 4, 2018 at 13:10

jeromegamez

3,5711 gold badge25 silver badges38 bronze badges

Comments

Adder · Accepted Answer · 2018-07-04 15:02:48Z

0

If you need a string to place into an insert query, that can be the string NULL, then you need to add the single quotes at the same time:

if (empty($csv[9]) {
    $follow_up1 = "NULL"; // a string between quotes
} else {
    $follow_up1 = "'" . $mysqli->real_escape_string($csv[9]) . "'";
}

And then use $follow_up1 in the SQL without quotes

edited Jul 4, 2018 at 15:02

answered Jul 4, 2018 at 13:12

Adder

5,8982 gold badges35 silver badges60 bronze badges

2 Comments

warrenfitzhenry Over a year ago

this is correctly inserting empty values as NULL, but valid values ('else') as number 0... any ideas?

Adder Over a year ago

ah i made it wrong. too much java coding .. Need to concatenate string with a dot.

Collectives™ on Stack Overflow

PHP parse empty data from csv file

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related