Data base connections

i need some advise

[guzzi]

i just want to know what is safer when developing a site, opening and closing a connection to a database only when it is needed or leaving the connection open for the duration of the usage to improve the speed of the site. if it is better to open and close the database connection all the time is safe to put the code into a include page as an object that can be created everytime the connection is used, with methods to open and close the connection?

[m_shroom]

Use an include page for you db conection script and make it a php script (a php script with no print or echo statments will never be displayed by a browser).

Connecting to the db involoves opening a socket (which is more or less a secure connection).

But even with pconnect your connection is droped when the script page ends.

[guzzi]

thanx for the advise :)