|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2012-01-05 14:56 UTC] denaje at gmail dot com
Description: ------------ > PHP 5.3.8 (on both Ubuntu Linux and Windows 7) > ./configure --with-pdo-mysql > No changes to php.ini When fetching rows from a MySQL database using PDO with the default fetch method FETCH_LAZY, the empty() function returns false on NULL values in the database. This behavior does not exist when using other fetch methods (such as FETCH_OBJ or FETCH_ASSOC). Test script: --------------- $row = $stmt->fetch(PDO::FETCH_LAZY); echo $row->Address2."\n"; // RIGHT: outputs '' var_dump($row->Address2); // RIGHT: outputs 'NULL' var_dump(!$row->Address2); // RIGHT: outputs 'bool(true)' var_dump(!!$row->Address2); // RIGHT: outputs 'bool(false)' echo empty($row->Address2)."\n"; // WRONG: outputs '' var_dump(empty($row->Address2)); // WRONG: outputs 'bool(false)' var_dump(empty($row['Address2'])); // WRONG: outputs 'bool(false)' $var = $row['Address2']; var_dump($var); // RIGHT: outputs 'NULL' var_dump(empty($var)); // RIGHT: outputs 'bool(true)' Expected result: ---------------- NULL bool(true) bool(false) 1 bool(true) bool(true) NULL bool(true) Actual result: -------------- NULL bool(true) bool(false) bool(false) bool(false) NULL bool(true) PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Oct 26 09:00:01 2025 UTC |
This is not MySQL specific. Can be reproduced with SQLite. $pdo = new PDO('sqlite::memory'); $statement = $pdo->prepare("SELECT NULL AS _something"); $statement->execute(); var_dump($row = $statement->fetch(PDO::FETCH_LAZY)); var_dump($row->_something); var_dump(empty($row->_something)); $statement = $pdo->prepare("SELECT NULL"); $statement->execute(); var_dump($row = $statement->fetch(PDO::FETCH_ASSOC)); var_dump($row['_something']); var_dump(empty($row['_something']));