Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:26739
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain php.net from 140.211.166.39 cause and error)
DomainKey-Status: good
DomainKey-Signature: q=dns; a=rsa-sha1; c=nofws;
	s=mx; d=php.net;
	h=From:Subject:To:Date;
	b=tT+QliYLtJ7yeEaF1I7ewDA6BvXCN6XNFqau3rM2Kp+MuQwnzx6H0KS6S8hYmCOX
	/eXOG1TRyq8TiCRBU2IlCdLfQ3JQrJyNg3e8pcDMZaUEHolaFbWeRfsGUpKxqThs
Message-ID: <456E7D53.90606@php.net>
Date: Wed, 29 Nov 2006 22:42:27 -0800
User-Agent: Thunderbird 1.5.0.8 (Windows/20061025)
MIME-Version: 1.0
To: "Mauro N. Infantino" <mauroi@digbang.com>
CC:  internals@lists.php.net
References: <008601c71245$8681ded0$ec01010a@intranet.db>
In-Reply-To: <008601c71245$8681ded0$ec01010a@intranet.db>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: Cross-extension resource
From: pollita@php.net (Sara Golemon)

> I'm writing an extension in order to achieve better performance in a
> specific module from our application. Right now, I'm trying to use an
> already established mysql connection (with mysql_connect) in our extension,
> so we don't have to connect to the database twice, since that connection is
> used in the PHP code. I don't need PHP's mysql API, since I can do
> everything in C, I just want the connection ID. I've read Sara's (great...
> GREAT) book, but I couldn't find any specific solution to this situation. Is
> this possible? Is there a "best" way?
> 
Surprising how often this question comes up....

/* True global to store local copy of mysql's le_link */
static int local_mysql_le = -1;

PHP_RINIT_FUNCTION(myext)
{
     if (local_mysql_le == -1) {
         local_mysql_le = zend_fetch_list_dtor_id("mysql link");
     }

     return SUCCESS;
}

A few notes about this solution:
(1) I'm doing this in RINIT because, prior to PHP 5.1, there's no way to 
enforce load order for shared extensions, so it's possible that your ext 
will load prior to mysql and therefore the list ID won't have been 
registered during the time of MINIT.  If you know that MySQL will always 
be loaded prior to your extension (either because of local policy or 
because you're only targeting 5.1 or later -- which has module 
dependencies), then you can do it once in MINIT and be done with it.

(2) The name "mysql link" is case sensitive and must match the resource 
type name you're looking for precisely.  There's also no guard against 
the (unlikely) possibility that some other extension registers a 
resource named "mysql link" which isn't actually a MySQL link.

(3) You should guard against the possibility that no matching list id 
will be found for that name (perhaps MySQL isn't loaded), so be sure to 
put some error checking in there...  Hint: This function returns 0 on 
failure.

(4) You'll probably need to fetch "mysql link persistent" as well...

I think this function is covered in Appendix A, but the cat is on my lap 
and I can't reach the bookshelf from here....

-Sara