connecting to remote database

[tolkienarda]

hi all

i would like to connect to a database on a different domain. and i was wondering what i have to change on the regular database connection code to make it work.
example i need to print info stored on my company's server on several of our client's pages.

[PHP]
$host="localhost";
$db_user="username";
$db_password="password";
$database="databasename";
$var = mysql_pconnect($host, $db_user, $db_password) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database, $cms);
[/PHP]

thanks for any input

[Motoma]

You will need to change your host to a fully qualified domain name or IP address.
You will also need to make sure your database is accessible from the internet.

[tolkienarda]

is having my database accessable a php setting i can change in php.ini or is it somthing on the mysql side.

and will the domain like is shown below work

[PHP]
$host="http://www.nextstep-designsolutions.com";
$db_user="username";
$db_password="password";
$database="databasename";
$var = mysql_pconnect($host, $db_user, $db_password) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database, $cms);
[/PHP]

thanks for your help

eric

[Motoma]

is having my database accessable a php setting i can change in php.ini or is it somthing on the mysql side.

and will the domain like is shown below work

[PHP]
$host="http://www.nextstep-designsolutions.com";
$db_user="username";
$db_password="password";
$database="databasename";
$var = mysql_pconnect($host, $db_user, $db_password) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database, $cms);
[/PHP]

thanks for your help

eric

Having it accessible to the outside means having firewall and port forwarding set up correctly.
The host is fine except for the http://

[tolkienarda]

ok thanks

eric