Querying Online Databases from Intranet/localhost

[Blinky001]

Hi Guys,

Firstly, is querying online databases from localhost/intranet servers possible?

Secondly, if it is could someone shed some light on how I would go about it....

Ideally a small part of the intranet system would just contain two sets of db connects:

$db1 = mysql_connect("onlinehostname", "username", "pass");
mysql_select_db("databasename", $db1);

$db2 = mysql_connect("offlinehostname", "username", "pass");
mysql_select_db("databasename", $db2);

but I'm guessing this is simple method is impossible.... is there a way to accomplish something similar? as I would like to be able to take parts of an online database into an offline one if they were approved...

Cheers 🙂

[Iquil]

i do it like that using the ip address of the host and it works fine for me 😃

[Blinky001]

Really? I can't get it to work...

I am just testing it using XAMP defaults though, is there a specific option I need to change (port redirects?) to get it to function?

[Iquil]

This is the code i use to connect to my online database.

// Database Variables

$dbcon[host] = "??.???.???.??";
$dbcon[user] = "????";
$dbcon[pass] = "????";
$dbcon[name] = "????";
$dbtable[trailer] = "????";

$connect = mysql_connect($dbcon[host],$dbcon[user],$dbcon[pass])
	or die(mysql_errno().": ".mysql_error());

mysql_select_db($dbcon[name]);