You can host the application locally and access it through your browser as localhost/myapp
Take a look at WAMP. It should set you up with the things you need to host locally.
Once you come online, you can run a script that will diff your local mySQL database with your remote and sync changes.
Let me know if you need any other info, or if something wasn’t clear.
0
solved php / mysql application to work offline when network is lost