Create php file to sync mysql data from some local server

Question

I develop a php application to get input from a technical support field(TSF) laptop (which is not always connected to internet) and from an online server on office. My idea is to create a php file to sync (send and receive) latest data between office PC(online) and TSF laptop(offline).

The rule is that each TSF should sync every end of day to send that day report to office pc and get the latest data from office pc so they can be used even offline.

The problem is I don't know how to create that php file.

Here the structure of my mysql database :

Table `merchant` :

id, name, address, phone, area, lastupdate

Table `item` :

id, merchid, sn, sku, code, lastupdate

Table `visit` :

id, date, merchid, itemid, act, result, lastupdate

TSF only can edit merchant and item table and add visit table, office PC can do anything...

On each table i give lastupdate column so php sync script can compare which is the latest update...but i don't know how to compare it using php...can someone help me?

Arkoudinos · Accepted Answer · 2015-07-21 19:11:54Z

1

It's not something easy, you need to know a bit about PHP programming. Of course you can't expect anyone to do it for you here (you may pay someone to do it for you though).

However, why not trying a less elegant but more simple way:

Use cron jobs and simple MySQL commands to extract the tables you want to an .sql file.
Send this file to the other PC via FTP, SCP or whatever you want
Again, via cron jobs and simple MySQL commands, update the tables in the current database with the file you just received.

answered Jul 21, 2015 at 19:11

Arkoudinos

1,12713 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Create php file to sync mysql data from some local server

Table `merchant` :

Table `item` :

Table `visit` :

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Table merchant :

Table item :

Table visit :

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related

Table `merchant` :

Table `item` :

Table `visit` :