I only want to connect to database once?

[pouncer]

I've got this code at the to of my index.php

 

<?
require_once("database.php");
require_once("functions.php");
   
   	$db = new Database();
   	$db->Connect();
?>

 

The Connect() method is just the mysql_connect(...) stuff.

 

So everytime I refresh my index.php, is my web app always executing the mysql_connect?? is there a better way to do it so it just connects once when i open the index.php and not again and again...

[Mark Baker]

Use pconnect rather than connect?

[wildteen88]

Yes everytime you refresh the page mysql_connect will be called. However mysql_connect will not establish a new connection if there is an existing one.

[pouncer]

Ah, I never knew about pconnect!!

[PFMaBiSmAd]

pconnect only works for a server module version of PHP. Most hosting runs php as a CGI application and pconnect does not work.

[revraz]

I wouldn't worry too much about it, because when the page is finished executing, it closes the connection anyways.

[redarrow]

just use, require_once("database_page.php");