[PHP-DEV] Bug #1860: fopen/fclose cannot be called before making a mysql query From: aljs <email protected>
Date: 07/24/99

From: aljs <email protected>
Operating system: FreeBSD, Linux RedHat
PHP version: 3.0.11
PHP Bug Type: MySQL related
Bug description: fopen/fclose cannot be called before making a mysql query

This bug occurs in PHP 3.0.6, 3.0.7 and 3.0.11

Calling fopen, then flcose, then trying to create a link to a mysql query confuses mysql. It thinks the file handle created in fopen is not closed. To illustrate this as simply as possible, I have created the following examples:

I have put an example of the bug at: http://proxy.rapidnet.net.au/esol/mysql_bug.php3

The php that causes this bug can be viewed at http://proxy.rapidnet.net.au/esol/mysql_bug.txt

Proof that this is the bug can be found by viewing http://proxy.rapidnet.net.au/esol/mysql_bug_ok.php3

Source of the proof can be found at http://proxy.rapidnet.net.au/esol/mysql_bug_ok.txt

There is a partial workaround. That is to make file calls after opening the connection to mysql. However, this workaround fails when trying to upload a file via php. In that case, the file handle is established before any php code is executed. This confuses mysql as before whether fopen/fclose is called or not. 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>