Issue removing a NULL value from MySQL using PHP

Question

I've tried the following to remove the null values from a resultset.

if((is_null($value)) || ('NULL' === $value) || (null === $value))

none seem to be working.

Here's my full code:

// remove null values from contact details
$contactData[$key] = removeEmptyDataFromArray($contact);    
print "<pre>".print_r($contactData[$key],true)."</pre">;

// remove empty data function
function removeEmptyDataFromArray(array $filledData)
{
    foreach ($filledData as $key => $value )
    {
        if ((is_null($value)) || (strlen ( $value ) === 0) || ('NULL' == $value) || (NULL === $value))
        {
            unset ( $filledData [$key] );
        }
    }
    return $filledData;
}

And here are the results from my print_r:

firstname :
lastname :
middlename :
primary_emailaddress : [email protected]

Yes, do a var_dump/print_r to see what exactly is the data you are getting from your query. Then look into empty, is_null to see what serves your purpose. — user216084
– user216084, Commented Jul 28, 2013 at 19:41
Also, 'NULL' === $value is not the way to check for NULL. Also, make sure you are checking against the correct value, like do you need to use an array index for the particular value, rather than the complete response from query? — user216084
– user216084, Commented Jul 28, 2013 at 19:44

echo_Me · Accepted Answer · 2013-07-28 19:46:33Z

1

why not remove Null values from your query without php ?

 WHERE your_column is not null

or

WHERE your_column <> ''

depends on how is your column. you have used the whole function just to remove the null values while in sql is just 5 words

answered Jul 28, 2013 at 19:46

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

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

2 Comments

user216084 Over a year ago

Yes, why did it not strike me? :)

somejkuser Over a year ago

i cannot exclude rows where one of the columns is null. I need to make sure that i still get the results despite the null value

user216084 · Accepted Answer · 2013-07-28 19:55:16Z

0

In your code, instead of

if ((is_null($value)) || (strlen ( $value ) === 0) || ('NULL' == $value) || (NULL === $value))

try

if (empty($value))

answered Jul 28, 2013 at 19:55

user216084

2 Comments

user216084 Over a year ago

Yes, and this is no trick :) just clarity of basic concepts of PHP and clarity of requirements. At the risk of offending you, I suggest a read of programming by accident :)

somejkuser Over a year ago

No offense taken. Thanks for the help.

Collectives™ on Stack Overflow

Issue removing a NULL value from MySQL using PHP

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related