import/sync MYSQL DB to SQLite DB using PHP

Question

Im new to android and Im still confused.

I have this project that whenever I update my mysql DB in the server (Im using a website in updating) my android app (I used sqlite here) informations must also be updated.. Is this possible? If yes, can you send me some links I can use?

PS: Im using lots of tables so its kinda bit problem for me to find over the internet since most of the examples are focusing on one table. A bit confusing to my part cause Im still fresh to this.

Kailas Bhakade · Accepted Answer · 2016-10-24 12:29:06Z

3

In your scenario, If you are using My Sql database at server side using php then you need to write sync code for each table using different techniques availables like Async Task, Retrofit , Volly etc. There may any other way to directly import data into android application. But as per my knowledge, we need to write sync logic for each table. After written sync logic for each table then we can mantain syncStatus column having values 0 and 1 for checking sync complete or not for a particular row. After complete this we can call sync method on CLICK Listener on any button or you can also called android side sync method by sending trigger to android app using push notification or gcm techniques from PHP side also. So This is the one solution as per my knowledge. You can try this. If any issue doing this. We can ask me any time. You can find out any better solution also. All the best.

edited Oct 24, 2016 at 12:29

answered Oct 24, 2016 at 12:23

Kailas Bhakade

1,92223 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

import/sync MYSQL DB to SQLite DB using PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related