PHP 4.0 Bug #9839: opendir() before mysql_fetch_assoc() returns non-associative array
| From: | marshall at myself dot com | Date: | Mon, 19 Mar 2001 16:16:30 +0000 |
| Subject: | PHP 4.0 Bug #9839: opendir() before mysql_fetch_assoc() returns non-associative array | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-49352@lists.php.net to get a copy of this message | ||
From: marshall@myself.com
Operating system: Linux 6.2 on Alpha
PHP version: 4.0.4pl1
PHP Bug Type: Directory function related
Bug description: opendir() before mysql_fetch_assoc() returns non-associative array
<?php
// If the opendir call is before the connect, an associative array
// is NOT returned from mysql_fetch_assoc() - the closedir does not
// seem to have any effect on this phenomena.
//
// It does NOT matter if the code is contained within the if() or
// not. If the opendir() call occurs before the mysql_connect()
// call, I get a farkled array from mysql_fetch_assoc().
//
// Changing the database and/or tables queried does not seem to
// make a difference to the bug.
// Change the 0 to 1 below to see this bug
if (1) {
$bizarrevar = opendir("/etc/");
closedir($bizarrevar);
unset($bizarrevar);
}
$dblink = mysql_connect("localhost","user","password");
mysql_select_db("dbname", $dblink);
$qresult = mysql_query("SELECT * FROM comment", $dblink);
while ($rx = mysql_fetch_assoc($qresult, $dblink)) {
while (list($k,$v) = each($rx)) {
print(" $k = $v<BR>\n");
}
}
?>
------------- End Script ------------
Data from phpinfo():
PHP was copmpiled with './configure' '--with-mysql'
'--with-apache=../apache' '--enable-track-vars'
Virtual dir support is disabled
Apache Info:
Apache Version Apache/1.3.19
Apache Release 10319100
Apache API Version 19990320
Loaded Modules mod_php4, mod_setenvif, mod_auth, mod_access, mod_alias, mod_userdir, mod_actions,
mod_imap, mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_status, mod_negotiation,
mod_mime, mod_log_config, mod_env, http_core
MySQL Info:
Active Persistent Links 0
Active Links 0
Client API version 3.23.22-beta
MYSQL_INCLUDE
MYSQL_LFLAGS
MYSQL_LIBS
mysql.allow_persistent On On
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
If you need additional information, please feel free to contact me via email at marshall@myself.com
:)
Thanks
--
Edit Bug report at: http://bugs.php.net/?id=9839&edit=1