Posted by Erwin Moller on 02/18/07 11:53

ernie.bornheimer wrote:

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

No, I have seen preconfigured databaseaccess before (they make sure a
database exists and that you have a connectstring to it), but not this
(preconfigured connections).
But at least you found out why it happens now. :-)

Regards,
Erwin Moller

>
> Thank you!
>
> Ernie

[Back to original message]