Posted by ernie.bornheimer on 02/18/07 06:09

"ernie.bornheimer" <ernie.bornheimer@gmail.com> wrote in message
news:BOxBh.43274$0u1.24479@newsfe15.phx...
>
> "Erwin Moller"
> <since_humans_read_this_I_am_spammed_too_much@spamyourself.com> wrote in
> message news:45d5bf08$0$326$e4fe514c@news.xs4all.nl...
>> ernie.bornheimer wrote:
>>
>>> Hello
>>>
>>> I have a script that works but it shouldn't, and I would like to know
>>> why.
>>>
>>> I originally wrote it with a statement to connect to the database, then
>>> there's a part to select the database, then I get some records and print
>>> them to the browser. It all works fine. A couple of months ago, I
>>> commented out the connection part (I can't remember why), and it still
>>> works. I had thought that there must be a connection statement. Is the
>>> current version of the code using the same connection from way back
>>> when?
>>> I'm confused.
>>>
>>> I know this is a newbie question. If someone could just point me in the
>>> right direction, I'd be very grateful.
>>>
>>> Thank you!
>>>
>>> Ernie
>>
>> Hi,
>>
>> PHP/MySQL also has a real 'persistent connection', so your question is
>> kind
>> of confusing. :-)
>>
>> But, really, I think you must overlook something.
>> If you do not deliver the resource-identifier to the database to PHP, it
>> will use the last connection, but that only works in 1 script, not the
>> next
>> invocation of the same script.
>> Is it possible you have some includefile you overlooked that actually
>> DOES
>> connect?
>> Or you have in php.ini configured some defaultconnection?
>>
>> Regards,
>> Erwin Moller
>
> Erwin
>
> Sorry about the improper use of "persistent." I checked my code again,
> including the includes. There is no database connection code. I'll ask my
> ISP about php.ini and post again.
>
> Thank you very much!
>
> Ernie
>
And here's the word from my hosting company:
"At LAMP Host the default db for each virtualhost is configured in the
Apache
config. So, as you experienced, you don't neccessarily need to set the
connection string. Note that this is an unofficial feature and might not
always work, so you shouldn't depend on it."

Mystery solved. But strange. Is this common practice in the industry?

Thank you!

Ernie

[Back to original message]