Re: [PHP-DB] MySQLi not closing connections

2008-11-27 Thread Jonathan Langevin
I was thinking the same bug, except that I'm not using real_connect (pass login params when initializing the class), and also the issue only occurs when logging is enabled. I'm really at a loss here :-\ -- Jonathan Langevin PHP Site Solutions http://www.phpsitesolutions.com On Wed, Nov 26, 200

Fwd: [PHP-DB] MySQLi not closing connections

2008-11-26 Thread Fergus Gibson
-- Forwarded message -- From: Fergus Gibson <[EMAIL PROTECTED]> Date: Wed, Nov 26, 2008 at 11:50 AM Subject: Re: [PHP-DB] MySQLi not closing connections To: Jonathan Langevin <[EMAIL PROTECTED]> On Wed, Nov 26, 2008 at 10:36 AM, Jonathan Langevin <[EMAIL PROTECT

Fwd: Fwd: [PHP-DB] MySQLi not closing connections

2008-11-26 Thread Fergus Gibson
-- Forwarded message -- From: Fergus Gibson <[EMAIL PROTECTED]> Date: Wed, Nov 26, 2008 at 11:34 AM Subject: Re: Fwd: [PHP-DB] MySQLi not closing connections To: Chris <[EMAIL PROTECTED]> On Tue, Nov 25, 2008 at 1:39 PM, Chris <[EMAIL PROTECTED]> wrote:

Re: [PHP-DB] MySQLi not closing connections

2008-11-26 Thread Jonathan Langevin
Hi Fergus, you're correct, the original code was developed in a hasty fashion by the developer that I am now working alongside. It's a situation where he's been rushed for a year, and hadn't had the time to get more organized. I've been going through the code, and cleaning up where possible, while

Re: Fwd: [PHP-DB] MySQLi not closing connections

2008-11-25 Thread Chris
I have never written an application using persistent connections, but I did get hired at a company where the other programmers describe the same problem you're having (a proliferation of connections that overwhelmed the server). They blamed mysql_pconnect() and the lead programmer said that aft

Re: [PHP-DB] MySQLi not closing connections

2008-11-25 Thread Fergus Gibson
On Tue, Nov 25, 2008 at 10:27 AM, Jack Mays <[EMAIL PROTECTED]> wrote: > I'm not sure why the connections are staying open, but I would suggest using > mysqli_real_connect with the flag to timout connections. [...] > If this is way off base, let me know. Jack, I think Jon shouldn't implement this

Fwd: [PHP-DB] MySQLi not closing connections

2008-11-25 Thread Fergus Gibson
Darn it. Didn't change the e-mail recipient to be the list. -- Forwarded message -- From: Fergus Gibson <[EMAIL PROTECTED]> Date: Tue, Nov 25, 2008 at 12:02 PM Subject: Re: [PHP-DB] MySQLi not closing connections To: Jonathan Langevin <[EMAIL PROTECTED]> On

Re: [PHP-DB] MySQLi not closing connections

2008-11-25 Thread Jack Mays
Jonathan Langevin wrote: Hoping someone may have some insight. I'm a PHP developer for my current employer. Recently, a coworker and myself started revamping our PHP-based intranet to add more OO functionality and replace some of the repetitive procedural code that was in place. In this revamp,

[PHP-DB] MySQLi not closing connections

2008-11-25 Thread Jonathan Langevin
Hoping someone may have some insight. I'm a PHP developer for my current employer. Recently, a coworker and myself started revamping our PHP-based intranet to add more OO functionality and replace some of the repetitive procedural code that was in place. In this revamp, we also converted the majo