I am using a PHP/MySQL backend and need help developing several web-apps.
To start with, it will specifically be accessed over mobile and will require offline storage of photos and data and synchronization once internet is available. Planning on using the IndexedDB browser API to store as blob. Will require interoperability with Android and iPhone. To be "installed" as a desktop app (manifest).
User will be prompted to log in (requires network connection for initial setup) and once authenticated against the database, the device will remain authenticated long-term. User then enters some data in a basic form, including some dropdown/select items and some fill-in-the-blank items, and takes some photos with the camera built into the device. All this data is first stored locally (app must request persistent storage as this data is critical) and then an attempt to post it to the server is made. If the data is not successfully posted, it remains in "draft" mode until it is successfully uploaded. Once uploaded and confirmed, the local content can be purged to free up space for another project.
A basic backend interface will also be developed (in PHP) to lookup/display the submitted projects and related content.
Two other projects may follow if this one is successful (one relates to scheduling/tracking and the other to accounting). Possibly opportunity for public website facelift too.