[PHP-DEV] PHP 4.0 Bug #6383 Updated: DB Persistent Connection not re-used From: mathieu <email protected>
Date: 10/30/00

ID: 6383
Updated by: mathieu
Reported By: Howard.Cohodas <email protected>
Status: Open
Bug Type: MySQL related
Assigned To:
Comments:

Reopened, sorry.. Misassumption on my behave

Previous Comments:
---------------------------------------------------------------------------

[2000-10-30 13:44:30] mathieu <email protected>
You're using PHP in a CGI environment (php.exe gets ran)
Persistent Database connections are not possible for
obvious reasons.. It even says in the manual.

---------------------------------------------------------------------------

[2000-08-30 09:32:08] Howard.Cohodas <email protected>
Bug persists in PHP4.0.2.

---------------------------------------------------------------------------

[2000-08-27 15:27:25] Howard.Cohodas <email protected>
Configuration...
php-4.0.2-dev-Win32-24-8-2000.zip
WinNT4 SP6a
HTTP Server: WebSitePro/2.5.4
mySQL: 3.23.22-beta
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Refer to Bug id #5807. Seems similar. If so then might be OS relateded, not mySQL or PostgreSQL related.

Script...

<html>
  <head>
    <title>DB Persistant Connection Test</title>
  </head>

  <body>
    <?php
      $db = mysql_pconnect ("localhost", "root")
              or die ("Could not connect");

      if (mysql_create_db ("myXdb")) {
        print ("Database created successfully");
      } else {
        printf ("Error creating database: %s", mysql_error ());
      }
      print "<br>";
        
      if (mysql_drop_db ("myXdb")) {
        print "Database dropped successfully";
      } else {
        printf ("Error dropping database: %s", mysql_error ());
      }
      print "<br>";
        
      mysql_close($db);

      show_source(__FILE__);
      phpinfo();
 
    ?>
  </body>
</html>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Problem..

Running WinMySQLadmin, observing Processes.
Each time the script is run another process is added th the process list. The process goes into Sleep mode.

Rather than re-using the idle persistent connection, another process is created.

---------------------------------------------------------------------------

Full Bug description available at: http://bugs.php.net/?id=6383 

-- 
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>