Currently I am using ajax to update SQLServer table with a PHP script on the server.
This works fine as long as the user has got an internet connection.
I want to experiment with SQLite on the device to write user capture on device to SQLite on device and then update SQLServer on demand (upload button, etc.)
It would be ok to still use PHP for the actual SQLServer updates but I need some help reading the device SQLite data and then sending the records read to the PHP script.
If there is a better method, please share.
Are there any such examples or similar?
The usual way to do this is with Ajax. You’ll need to write some code on the device to figure out which records need to be synched, then use Ajax to send to your PHP script on the server.