J
J
John2019-10-14 20:17:16
PHP
John, 2019-10-14 20:17:16

How to connect an Android application to a MySQL database that is updated via CRUD operations from a PHP/JS site?

There is a PHP / JS site, a MySQL database and an android application on java.
If the android application is connected to the same MySQL database as the website made with html/php/js. Will the info be displayed in real time in the Android application when performing CRUD operations on the site?
What steps do I need to take to solve such a problem but in the easiest way?
I understand PHP, JS, MySQL, but I don’t really understand anything about Android. I just want the list of tasks in the Android application to be displayed after updating the SQL table in the data bank through CRUD operations on a third-party site.
Experts help with advice please :)
Regards
Daniels

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
AndroidRS, 2019-10-14
@Daniels93

You need to implement the API, it's actually very easy if you understand php. The application requests the selected method and transfers various parameters (or does not transfer) using GET or POST, the script processes the received data and returns an array of data in the form of json, after which this data is parsed and parsed by the client part of the software (Android application)
https://www. google.com/search?q=how+to+write+api&o...
https://www.google.com/search?client=ms-android-sa...

D
Dmitry, 2019-10-14
@Compolomus

You can write an api for an android application, or even connect to a database, but it’s more difficult here, perhaps the database is local, and it doesn’t stick out, which in some places makes it difficult to get access. Especially if it's hosting. Well, pulling the api through the application is even easier than connecting the base. The data will be visible

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question