$conn as session variable

[patl]

I would like to put my my_sql connection as a session variable so i can just reference it throughout the site rather than having to open a new connection for every function, or on every page.

Does this make sense? Are there any security issues with it? Will it cause too many concurrent db connections? Right now my code has way too many calls to db_connect() so i'm looking for an alternative. Any thoughts are greatly appreciated. Thanks a lot.

[ClarkF1]

Could you just put in a separate file and "include" it in each page.

[leatherback]

patl wrote:

Right now my code has way too many calls to db_connect() so i'm looking for an alternative. Any thoughts are greatly appreciated. Thanks a lot.

In principle, you would want to close the db connection after using it to query it. I have just two simple funtions, one to connect, and on to disconnect, which are in the base include file for each page.

Then you just:

$DBH = db_connect();

// query

db_disconnect($DBH);

function db_connect()
  {
  global $db_host, $db_user, $db_password, $db_name;

  $db_link = mysql_connect($db_host, $db_user, $db_password)
       or handle_errors("GEN", 1, 1, -1);
       mysql_select_db($db_name);
  return $db_link;
  }

function db_disconnect($db_link)
  {
  mysql_close($db_link);
  }