[RESOLVED] connecting to a mysql database in another host (apart frm d host wer my php page are)

[onairric]

Hi guys! need help here

Is it possible for my php page that is uploaded into one host be connected and retrieve information/data from a MySql Database which is being hosted in another host?

If yes... pls help! here the code i use to connect the database:

<?php 
// This file contains the database access information. This file also establishes a connection to MySQL and selects the database.

// Set the database access information as constants.
DEFINE ('DB_USER', 'domain_erickes');
DEFINE ('DB_PASSWORD', 'MyPassword');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'domain_makatimedicalcenter');

if ($dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD)) { // Make the connnection.

if (!mysql_select_db (DB_NAME)) { // If it can't select the database.

	// Handle the error.
	my_error_handler (mysql_errno(), 'Could not select the database: ' . mysql_error());	

	// Print a message to the user, include the footer, and kill the script.
	echo '<p><font color="red">The site is currently experiencing technical difficulties. We apologize for any inconvenience.</font></p>';
	include_once ('public_html/themedicalcity/includes/footer.html');
	exit();

} // End of mysql_select_db IF.

} else { // If it couldn't connect to MySQL.

// Print a message to the user, include the footer, and kill the script.
my_error_handler (mysql_errno(), 'Could not connect to the database: ' . mysql_error());
echo '<p><font color="red">The site is currently experiencing technical difficulties. We apologize for any inconvenience.</font></p>';
include_once ('public_html/website/includes/footer.html');
exit();

} // End of $dbc IF.

// Function for escaping and trimming form data.
function escape_data ($data) { 
	global $dbc;
	if (ini_get('magic_quotes_gpc')) {
		$data = stripslashes($data);
	}
	return mysql_real_escape_string (trim ($data), $dbc);
} // End of escape_data() function.?>

Please help! tnx! 🙂

[thorpe]

Yes... Change localhost to the address (usually an ip) of the database server.

[Drakla]

You might have to set permissions for mysql to allow access from your host. If you're using cpanel then you can allow access from '%' to let any old sod use it as long as you've got the right username and password, but you can limit it to a single IP if you want. You might have to look into the GRANT command if you don't have cpanel and don't already know it. Some servers are firewalled and won't let anybody access mysql through anything other than localhost. Just letting you know in case you get into one of those hair tearing situations where you're looking for bugs in perfect code.

[onairric]

yep, ive got a cpanel and i did see this form where its allowing me to add a Host (% wildcard is allowed) for the Access Hosts.

Sorry, but what exactly should i put in that form?
btw, im referring to a cpanel for the host where the mysql database is hosted.

and once i fill up the form, i believe i should i change the

DEFINE ('DB_HOST', 'localhost'); 

in my php code from localhost to something else. what should i cahnge it to?

thanks for all the help!

[onairric]

okay....

sorry.. i just re-read your posts guys, tried it and its now working!

im so so so happy! hehehe

thanks for all the help!

😃