[RESOLVED] ISP has a different hostname than my "Localhost". How do you get around this?

[Phrank]

I use a file - dbconection.php - to open my database. If I am running on my pc I want to set $HostName = "Localhost". If I am running on the ISP I have to set $HostName to there hostname. I use a variable to decide if I am running on local or the ISP. Problem is ole Dreamweaver automatically sends the dbconnection file up since several pages have it as an include even if I have told Dreamweaver to cloak the file.

How do you get around this problem? How do you code the file you use to open databases?

Is there a function in Php that will tell me if I am running locally vs on the net?

I looked on the forum but could not find anything on this.

TIA Frank:queasy:

[bpat1434]

Theoretically every "server" is on the net (whether intra- or inter-). The only way I could say for you to figure out if you're "live" or not is to use $SERVER['HTTP_HOST']. If you reach your localhost server via "localhost/something" then $SERVER['HTTP_HOST'] will be "localhost". Then when you access it via the internet, the $_SERVER['HTTP_HOST'] would be populated with something like "mysite.com" or "www.mysite.com".

So in your dbconnection.php file you could simply do:

<?php

$dbhost = ($_SERVER['HTTP_HOST'] == 'localhost' ? 'localhost' : 'mysql-1031.domain.net');

I'm guessing that you're probably hosted with Servage or some other cluster type of service where their MySQL servers are connected to like above.

[Phrank]

Worked perfectly.

Thank You.