如何使用Web App和Android App访问SQL数据库

Question

What is the best way to have a SQL database that can both be accessed by an android device via java code and by a web app via php code?

In my mind I imagined a MySQL database somewhere on the cloud that is accessed in all the normal ways by the web app using mysqli_connect and then somehow the same database calls are made in Java inside the android app.

But after some research it appears this may not be the way to do it. What is the way to do this correctly?

EDIT: It was suggested my question was too broad. What I want then is a database of some basic financial information which is stored on the cloud which is then able to be accessed via a web app written in the LAMP stack and via an android app (with java code).

It is a really simple problem but I am not sure what the best practice for such a problem is in android (I come from a web dev background)

Answer 1

The standard way to access a database for mobile application is different than a normal web page/application.

Mobile devices should never run queries in the database; What you do is create a web service that does all the queries in the database and then sends back HTTP responses in xml, JSON format to the mobile device for consumption.

At the same time you can create a web client that interacts with the web service the same way your mobile app does. This way if you get erroneous data you can debug the web service without having to recompile the code in the mobile app.

Do a Google search for restful web service