PHP null question?

Question

I have this php statement in my login script...

else if ($_POST['email'] === $details['email'] &&
         $_POST['password'] === $details['password'] &&
         is_null($details['logcount'])) {
    echo 'Account not active!';
}

In my mysql table the logcount by default is NULL, when a user activates their account the logcount turns to 0 then increments every time they login.

On my login script I am having trouble with PHP testing it to see if it is NULL or not. I have pulled all the users data via an associative array using PDO.

Thanks in advance.

Storing plain-text passwords in the database is bad. You should be hashing them at the very least. — Phil
– Phil, Commented Aug 22, 2011 at 5:18
Good idea, thanks Haim, I am testing Phil, just trying to get the mechanics working first! thanks. — carlgcoder
– carlgcoder, Commented Aug 22, 2011 at 5:20
@carlgcoder What does var_dump($details['logcount']) display? I only ask as is_null() returns true for null and false for 0 and "0" so your code should work as expected. — Phil
– Phil, Commented Aug 22, 2011 at 5:22
Try doing a var_dump($details); to see what's actually in there. While your at it, do a var_dump($_POST) to make sure that everything is as expected. You can also break down each of the three comparisons to see which one is failing. — Doug Kress
– Doug Kress, Commented Aug 22, 2011 at 5:28

Community · Accepted Answer · 2017-05-23 09:59:05Z

1

Try using the isset() function. If not, then you may have to tell PDO how to handle nulls for your db server. Look at the accepted solution here:

PHP PDO fetch null

and setattribute docs here:

http://php.net/manual/en/pdo.setattribute.php

edited May 23, 2017 at 9:59

CommunityBot

11 silver badge

answered Aug 22, 2011 at 5:24

Daniel Pereira

1,78312 silver badges10 bronze badges

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

4 Comments

Doug Kress Over a year ago

The problem lies somewhere else. is_null() is the right function to use for the purpose. If there's some way to tell PDO how to handle nulls, give an example of that.

Phil Over a year ago

@Doug See php.net/manual/en/pdo.setattribute.php however the default is to return nulls as NULL

Doug Kress Over a year ago

Cool. Can you modify your answer with that info?

Daniel Pereira Over a year ago

Ok, I edited this answer to be more descriptive. I think result from isset() vs is_null() depends on how PDO is handling nulls.

Collectives™ on Stack Overflow

PHP null question?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related