set up way of getting mysite.$domain

Question

Hi

I have several domains, only one website and one databse table for each domain.

example: wbesite.us - data from USA goes to database table main_usa wbesite.co.uk - data form UK goes to database table main_uk

Only have one database with name of the website.

Having only one website structured, and having variables like

$sql="select * from main_".$countrycode." where bla..bla..., and many other variables to catch the domain extension, and so on...

Now, instead of having one full website for each domain, how can set a script and wher do I put it in order to detect the domain that the user uses.

In my server root do I create something like website.$domain ?

Something like website OLX but for different purposes.

I hope I made myself clear.

Thank you.

Answer 1

You could use the $_SERVER['SERVER_NAME'] global and somehow parse it, to get the country code.

I didn't try it, but something like this should work:

$servername_array = explode('.', $_SERVER['SERVER_NAME']);
$country_code = array_pop($servername_array);

That way, $country_code will be com, uk, or whatever is after the last dot in the domain name.