Different domain names pointing to same folder but retrieving different data from DB

[bladx]

Hi,

It's been a while since I've posted on here... but I have an Apache/PHP/MySQL-related question.

I am working on a project to consolidate a number of separate websites into one directory and one database. All of the sites have the same structure and that is all taken care of by PHP and MySQL. Each site at the moment has its own domain name and all of the sites are hosted on the same server.

My question is, when connecting to a single site (www.example.com) is it possible to direct that request to the corresponding site's information that is located in the single database?

It's hard for me to phrase the question of what I'm trying to do, but if anyone knows of a way to do this, please let me know!

Andy

[mjax]

Use something like this:

switch($_SERVER['SERVER_NAME']) {
   case 'www.example.com':
      $server = 'localhost';
      $username = 'myuser1';
      $password = 'mypass1';
      $db = 'database1';
      break;

   case 'www.otherone.com':
      $server = 'localhost';
      $username = 'myuser2';
      $password = 'mypass2';
      $db = 'database2';
      break;

   default
      $server = 'localhost';
      $username = 'defaultuser';
      $password = 'defaultpass';
      $db = 'defaultdatabase';
      break;
}
mysql_connect($server, $username, $password) or die('Error connecting: '.mysql_error());
mysql_select_db($db);

[bladx]

Thanks, mjax!