Re: strange mysqli error

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

 



how do you know which object is destroyed first?

also you are using 3 different versions of php - not something that will
help narrow down the problem.

Richard K Miller wrote:
> 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();

what happens if you add the following line:

unset($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
> 

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