Help with Database Connections

smitty77

I am fairly new to coding in PHP, and have recently been working on our intranet writing an application that connects to a Sybase database.

My question is: Can you carry a remote Sybase connection across multiple pages?

I know about Persistent connections, but they don't seem to be working, I am still seeing it create multiple connections when I refresh or traverse through pages that are creating new persistent connections.

I have tried serializing the connection object and storing it and then unserializing it on another page using sessions, but I get a link index error.

Any help would be greatly appreciated!

drew010

unfortunately not.
from php.net, "The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling sybase_close()."
is there a reason you want to carry the same resource across multiple pages? it should be just fine to reconnect at the beginning of each file.

smitty77

Drew,
Thanks for the reply! That is what I suspected.

The reason for not wanting to create a connection on every page is that the Sybase DB Administator thinks that our web apps are bringing Sybase down because of quick, repetitive opening and closing of connections.  I don't know enough about Sybase and the error logs that he gets the information from, but he really thinks that the web apps are causing the problem.

Our web apps are running PHP in Apache on Linux OS.

drew010

I dont see why they would bring it down unless the database server is really old and slow and isn't configured to handle many connections. The host the some of my sites are on now use mysql and I occasionally look at the processlist and see hundreds of connections at a time coming from scripts and the server is just fine, low cpu usage, and no hangups.
I guess if he is the boss you will need to work on persistent connections, although having it reconnect every time shouldn't be very bad for it.
This is just my feeling but if the administrator of the db can't get it to stay up with a few simple php scripts connecting to it, then he needs to brush up on his db management. I mean, i used to be on a site all the time that last time i checked, had over 60 million members, and 50,000 people on at any given time and the site was about 90% database driven. and it was alllways up unless they were updating the program or something.