[SOLVED] IF Function for db connection

[andrewgarn]

Right so I signed up to web hosting with mysql server, but they dont allow access to the database from outside their server.

 

I wish to test pages offline using my local mysql server but dont want to have to change the connection details every time I upload the page.

 

So I figured an IF function for the db connect, however I dont know what the constraint would be, ie. how it would identify where the page would be accessed from.

 

I use 3 web urls: localhost, a no-ip domain and the hosting service (freehostia)

 

//Database Information
$dbhost = "*";
$dbname = "*";
$dbuser = "*";
$dbpass = "*";

 

Any suggestions? This is probably simple I just dont know syntax for the if function

[rhodesa]

Even easier, have an included file (like dbconnect.php) with the connection info specific for that server. Then, have your pages include that file.

[andrewgarn]

But that wouldnt solve the problem of which mysql server to connect to?

[rhodesa]

yes it would...so on your webserver, your copy of dbconnect.php has your local mysql info. and on the hosted service, the dbconnect.php file has the info for the hosted mysql server.

[andrewgarn]

oh of course.

 

so simple, stupid me

 

Thanks