How to get db connection available on every page?

eclipsevtb

Hi,

I'm using the function below on every page to get db connected. Is it possible to make connection available for the whole session without calling the function on every page? I tried storing $link in session variable but it didn't work. My website works very slow because of numerous unnecessary connection.

function connect()   {
   if (!$link = mysql_connect($host, $db_user, $db_pw))   {
      die('cannot connect to db');
   }
   return $link;
}

Thanks in advance

thorpe

My website works very slow because of numerous unnessary connection

That is not likely the reason and in fact, trying to persist a connection accross multiple pages would cause you more trouble.

You could use mysql_pconnect(), but I wouldn't recommend it unless you know how it works and why you need it.

Database connections are closed by the garbage collection at the end of every script.

MarkR

You can't store a database connection in the session.

Moreover, connecting to the database on every page will NOT make your site very slow. Connecting to the database is a fast operation and only needs to be done once per page, no more times.

Normally the techique is to create one connection initially for each page, then reuse the connection during page generation. Typically this is done by putting the connection in a global variable which you set up in some file which is require()'d at the top of each page.

Mark

Staggy11

I advise that you save the code as, say, 'connect.php', then include it in each page with

<? include 'connect.php'; ?>

. Its all I can think of.

eclipsevtb

Staggy11 wrote:
I advise that you save the code as, say, 'connect.php', then include it in each page with
<? include 'connect.php'; ?>
. Its all I can think of.

i "require" connection.php on almost every page and use $db_link directly.
it works for me but i just wonder if i use global variable properly?

// connection.php
global $db_link;

$host = "host";
$db_user = "user";
$db_pw = "pw";

if (!$db_link = mysql_connect($host, $db_user, $db_pw))	{
   die("Unable to connect to host<br>");
}