[awais]

Hi!
It is possible in PHP to use mySQL database from another hosting account. Let me explain...
My script in abc.com and I want to use database from xyz.com.
is this possible? and how

[mdhall]

Not sure if its possible or not, but I doubt that it would be very efficient, or smart. I imagine your bandwidth would be much higher, having "A" (the database) sending data to "B" (your server) to "C" (the viewer). Theres an increase in potential connection problems. Are both web spaces your own accounts that you alone have control over, or can someone else pull the plug on your DB after its all set up? I would think you're much better off keeping it all on one server.

[Stefan]

the quick answer: yes, it is possible. using

PHP Code:

mysql_connect("xyz.com", "user", "password"); 

I have to support mdhall's remark though. your bandwidth will be used much more since instead of just having the user request a page, and that page being sent to the user, you'd have the user requesting your page, the page requesting data from the database, the data from the database being sent back to the server and then the page being sent back to the user.

also, if the database stores any sensitive information, it'd be a lot less secure since all that information will travel over the Internet when php is talking to the database.

but... it is possible

[mqcarpenter]

Could you do it this way:

$isearch_sql_server = "www.mydomain.com";
$isearch_sql_username = "user_name";
$isearch_sql_password = "password";
$isearch_sql_database = "database_name";

For the server, can I just put in the web address? Like, "www.mydomain.com" and put the DB name, user, etc?

TIA