strange mysqli error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Good afternoon. I'm getting a weird mysqli error in my object destructor. Here's an example:

<?php

$db = new mysqli('localhost', USERNAME, PASSWORD, DATABASE);

class Test
{
	function __construct()
	{
		global $db;
		
		$db->query("SELECT 'test'");
		print_r($db->error);
	}

	function __destruct()
	{
		global $db;
		
		$db->query("SELECT 'test'");  // line 20
		print_r($db->error);  // line 21
	}
}

$test = new Test();

?>


A. On my dev machine (Mac OS X + PHP 5.1.4 + MySQL 5.0.19) I get the following errors EVERY time: Warning: mysqli::query() [function.mysqli-query]: Couldn't fetch mysqli in /Users/richard/Projects/data/private/mgftest.php on line 20 Warning: Test::__destruct() [function.Test---destruct]: Couldn't fetch mysqli in /Users/richard/Projects/data/private/mgftest.php on line 21

B. On my production server (FreeBSD + PHP 5.1.2 + MySQL 5.0.19) I SOMETIMES get the following error: (If I refresh the page repeatedly, sometimes there's an error, sometimes not.) Warning: mysqli::query() [function.query]: Couldn't fetch mysqli in / usr/local/www/data/private/mgftest.php on line 20

C. On a commercial web host (PHP 5.0.4 + MySQL 5.0.22) I NEVER get any errors.

There's nothing else in my error logs, $db-errno is 0, and $db->error is empty. Interestingly, I never get any errors from the constructor.

Any ideas?

Richard


---
Richard K. Miller
www.richardkmiller.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux