July 5, 2013 at 3:17 pm #46144
pardon me if the title does not matches!
I have developed an WEB based APP on PHP – MySQL for the cable operators to maintain their books of records online and calculate easily which is actually done manually (about 60%).
What i wanted is to design an offline application (or implement the same website offline) to the customers which can sync data to the online database whenever wanted by the user.
Example: Github windows app (I just love it)
the thing is i don’t know how to achieve it at all !!! Hoping for some help! ThanksJuly 6, 2013 at 7:12 am #141716
You could set it up so that it creates a local Apache server when offline which would run PHP and MySQL, so that you can use the exact same app both online and offline.
You would then need to sync both the local and online databases.
I can’t explain any more than that though; it’s just an idea.July 6, 2013 at 8:42 am #141720
@cyneWATCH thanks for replying, Well basically that is one of the two ideas.
I do not know how to sync my offline data to online database and vice versa.July 6, 2013 at 12:12 pm #141739
How about first attempting to UPDATE the online version with the offline version. Then, what doesn’t UPDATE can be INSERTed. This would work in both directions.July 6, 2013 at 1:48 pm #141751
actually i cannot do that manually, it is a book keeping kind of software that will be used by potentially 1000+ clients from all over indiaJuly 7, 2013 at 3:08 pm #141810
What I meant was that when a client goes online, the database looks for something that says what they have changed whilst offline. When it finds that information, the app then sends those changes to their places in the online database. The same thing would then happen from online to offline.
You could do this with some kind of XML file or maybe in a database table with one row per client, which contains the information as to what has been updated.
This technique would sort of be like git or svn, but not as complex. It remembers which values have been changed, but not the new or old values.July 14, 2013 at 2:33 pm #142785July 18, 2013 at 5:45 pm #143539
hi, using PHP for offline apps is not common, you can try other languages for windows and mac applications and for sync data you can provide services for your desktop apps from your main web application which is published online.
You must be logged in to reply to this topic.