[UPHPU] strange mysqli error
Richard K Miller
richardkmiller at gmail.com
Mon Aug 21 13:17:28 MDT 2006
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 Bluehost box (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
More information about the UPHPU
mailing list