By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,303 Members | 1,245 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,303 IT Pros & Developers. It's quick & easy.

persistent MySQL connection?

P: n/a
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
Feb 16 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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

Feb 16 '07 #2

P: n/a

"Erwin Moller"
<si******************************************@spam yourself.comwrote in
message news:45*********************@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
Feb 17 '07 #3

P: n/a

"ernie.bornheimer" <er**************@gmail.comwrote in message
news:BO*******************@newsfe15.phx...
>
"Erwin Moller"
<si******************************************@spam yourself.comwrote in
message news:45*********************@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
Feb 18 '07 #4

P: n/a
ernie.bornheimer wrote:
>
"ernie.bornheimer" <er**************@gmail.comwrote in message
news:BO*******************@newsfe15.phx...
>>
"Erwin Moller"
<si******************************************@spa myourself.comwrote in
message news:45*********************@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
Feb 18 '07 #5

P: n/a
Thanks again, Erwin!

"Erwin Moller"
<si******************************************@spam yourself.comwrote in
message news:45*********************@news.xs4all.nl...
ernie.bornheimer wrote:
>>
"ernie.bornheimer" <er**************@gmail.comwrote in message
news:BO*******************@newsfe15.phx...
>>>
"Erwin Moller"
<si******************************************@sp amyourself.comwrote in
message news:45*********************@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

Feb 18 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.