From: boriskolev at abv dot bg
Operating system: RedHat 9.1
PHP version: 4.3.8
PHP Bug Type: Arrays related
Bug description: Extract - problem
Description:
------------
When you have array with text index-es(hash) and when you extract this
array to variables if some of array columns have null value variable for
this column do not clears.
For example in code reproduce :
if for example column "keyword" is null for some row variable $keyword
after extracting do not clears.
Reproduce code:
---------------
$query = "SELECT
a.agent_sid,
a.country_sid,
a.region_sid,
a.keyword,
a.agent_frequency_sid,
a.last_email,
u.email,
CONCAT(u.first_name, ' ',
u.last_name) as fullname
FROM
AGENT a INNER JOIN USER u
ON
a.user_sid=u.user_sid INNER
JOIN OBJECT_HISTORY o
ON
u.object_history_sid=o.object_history_sid
WHERE
o.object_status_sid=1
AND
(a.agent_frequency_sid=2 OR
agent_frequency_sid=DAYOFWEEK(DATE_ADD(CURDATE(), INTERVAL -1 DAY))+2)
";
$agent_result = query($query);while ($row =
mysql_fetch_array($agent_result,MYSQL_ASSOC)) {
extract($row);
};
Expected result:
----------------
to fech result into array and then to extract array into variables for
each row and if cell empty or null variable be empty too.
Actual result:
--------------
variable do not clears
--
Edit bug report at http://bugs.php.net/?id=31385&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=31385&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=31385&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=31385&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=31385&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=31385&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=31385&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=31385&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=31385&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=31385&r=support
Expected behavior: http://bugs.php.net/fix.php?id=31385&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=31385&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=31385&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=31385&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=31385&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=31385&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=31385&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=31385&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=31385&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=31385&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=31385&r=mysqlcfg
