0

I am developing a inventory management web application using php and mysql. This application will runs on different locations. while any one place disconnect the internet at the time data will be land in local database and when active internet that data automatically synchronizing the remote database. is there way pls let me know.

thanks and advance.

6
Contributors
6
Replies
45
Views
3 Years
Discussion Span
Last Post by ActingRude
1

This application will runs on different locations

What language is this application written in?

any one place disconnect the internet at the time data will be land in local database and when active internet that data automatically synchronizing the remote database

What are the rules for syncing? Have you thought about that?

1

I had developed such type of solutions few months ago.

For the sync you can create the server side code which will get the data and the local server end which will put the data.

Now at local end you will mark a time and after that time you can get the data in json format of SQL query. Now send this data to remote server and put/sync this information on the remote server.

From local server you will need to havr curl as with this you can call the remote script after putting the data by any way like FTP from php.

Good luck.

0

Keeping a que of the changes made and just submitting them to the main database once connection is re-established really is your best bet here.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.