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.
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?
Hi pritaeas, am using PHP/MYSQL.
Hello, we will need more info.
What kind of data are you saving etc.
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.
Use apps like Microsoft's SyncToy, SyncBack etc
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.
code please
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.