PHP connecting to MySQL over internet?

Anon

Hi,

Has anyone had any experience using PHP to connect to a database over the internet? (example: PHP on a web server connecting to a MySQL database on the other side of the world)

Is this possible to do?

Thanks,
Adam

[deleted]

"Is this possible to do?"

Ofcourse, just fill in the correct hostname and userdata in the mysql_connect() function, and make sure the database server is configured to allow your host and user to connect to it, just like with your local databases.

Anon

Its very easy to connect PHP to a mysql database

Ude the following

mysql_connect("Your Host name" ,"User name " , Pass");

replace host name with the host nme that is provided by the ISP
Also uname and Password in the same way

To go one step forward create a file like config.php or something and enter connection parameter code and selection of DB code and then include this file in all the files required to have the function

Pradeep

Pr. Aspbyte Creations.com)

Anon

The answer is... maybe. If the way described in the two answers above doesn't work, your MySQL server host has a restriction on IPs querying the database. This way the hoster ensures you only use the domains booked with them, instead of running one domain there with the MySQL feature and the others with a less expensive hoster.

I came across that nasty 'feature' when I tried to synchronize my local IDE from Firepages with my online db hosted at one of those 'inexpensive' ones. The script ran locally, sending queries to the online db, but was declined access. The workaround was to query MY db from a script running on the online host, using $REMOTE_ADDR to figure out who I am (IP changes with every dialup). Putting the $REMOTE_ADDR in the 'host' var for connection worked fine, as did the script. If you need it, drop me a fast line.

Joerg
www.surfspot-magazine.com