4 replies to this topic

[Hayden]

I've been tweaking this class I have been using to work better with PHP5 so it doesn't get any warnings or notices in the error log file. I've gotten pretty much all of them except for one.

Quote

PHP Warning: mysql_ping(): 7 is not a valid MySQL-Link resource in ****/public_html/test/mysql.php on line 69

Source


Line 69 is the "IF"

	function __destruct() {
		//----------------------------------------------
		// check for a connection to mysql and close it
		//----------------------------------------------
		if (mysql_ping($this->connection)) { mysql_close($this->connection); }
		return true;
	}

Edited by SpatialVisionary, 06 May 2007 - 05:26 PM.

[Demonslay]

Ugh, I've had a similar problem and I can't remember how I fixed it!

All I know, is that I simply check whether the connection ID exists before I close it. I don't see why a ping wouldn't work though. =\

I like your class though, has a completely different implication than I've seen, lol.

[Hayden]

Demonslay, on May 6 2007, 04:26 PM, said:

Ugh, I've had a similar problem and I can't remember how I fixed it!

All I know, is that I simply check whether the connection ID exists before I close it. I don't see why a ping wouldn't work though. =\

I like your class though, has a completely different implication than I've seen, lol.

yeah, i found it through a tutorial here. didn't really care for it as it was and tweaked it.

was working great in PHP4 then I decided to switch to PHP5 and started getting notices and warnings.


btw. i get the same error if i remove the mysql_ping and just have it immediately do the mysql_close.

except for the fact 'mysql_ping' is replaced with 'mysql_close'

Edited by SpatialVisionary, 06 May 2007 - 04:30 PM.

[Pixel Prestige]

SpatialVisionary,
You said PHP5 yes? Perhaps this quote I found would be a little help.

Quote

if mysql server is 5.0.13 and later, mysql client MUST set option
"MYSQL_OPT_RECONNECT" to TRUE, then mysql_ping will work.
http://dev.mysql.com...ql-options.html

Good Luck

[Hayden]

Pixel Prestige, on May 6 2007, 06:37 PM, said:

SpatialVisionary,
You said PHP5 yes? Perhaps this quote I found would be a little help.

Quote

if mysql server is 5.0.13 and later, mysql client MUST set option
"MYSQL_OPT_RECONNECT" to TRUE, then mysql_ping will work.
http://dev.mysql.com...ql-options.html

Good Luck

thanks. i think you hit nail on the head.

got to thinking, so i ran a phpinfo() and noticed the mysql reconnect setting.
[attachment=2774:mysql.jpg]