how to synchronization to sqlite to online server

[AC Question]

I'm making an app where we can save the user details such as name,contacts...etc these all the thing we are storing in sqlite first then we want that all the thing which are stored in sqlite are directly goes to the server when user connected to the server...if the user is offline then user see all his detail which he save.if he want any modification such as add,edit,delete all the thing they can do it in offline mode also...while connecting to the server these thing change in the online server.So how i can make an app like this...how i can synchronise sqlite to the online server

 

[Rukbat]

Either send the .db file to the server or send the data itself to the server. (I usually create a database on the server with the same fields as the one on the program, then add one - the user name, ID or whatever you use to identify the user. Then I copy the local database to the remote database. If you use MySQL on the server, just update the records on the server - use REPLACE INTO - REPLACE INTO table SET id = 42, foo = 'bar'; Loop through the entire recordset.)