为MySQL数据库创建API [关闭]

Question

I have two websites which I'm going to call here mywebsite1.com which has a MySQL Database and mywebsite2.com which does not have a MySQL Database and both with PHP.

I need a database in mywebsite2.com, so I wanted to use the database from mywebsite1.com. My problem is "how do I do that?". It's easy to save data to the database, just send it as $_GET[] data and do a query.

The problem is to read data from the database. What are my solutions? Is there any API already made? Should I output the data has an XML file ? I'd like to hear some solutions with pros and cons.

I have no possibility of buying an MySQL service for mywebsite2.com, so please don't suggest that. This are the resources I have, so only use this in your answers OR other free solutions.

Answer 1

You can have access to your MySQL database from your second site. Easily.

If it has cPanel you have to enable Remote MySQL option and add the IP of your second site so that connections from it will be trusted!

Then you can access it directly from the second site.

http://docs.cpanel.net/twiki/bin/view/11_30/CpanelDocs/RemoteMySQL

In your case that you have a free host, You can use Xeround which provides free mysql databases in the cloud!