I have to create some web pages, the web pages are inside an Android Tablet, configurated as a Kiosk (it means we have to install an App inside the Android Tablet that when the tablet turn on, the browser open and it is not possible to close the browser, i already found some useful App).
Another App that we should install inside the Android Tablet is the PHP server because i think the web pages are .php page, if you can create the web page without .php server it is better because we don't need to install the App to create the php web Server.
The web pages are with some textbox , some selectable menu' and a Send button.
When press the Send button we have to send data to a mySql database, i will give you the username and password of the database.
There are 14 pages (all the 14 pages are the same) inside the Android tablet, i can go from a page to another page, if i edit some data on a page and go to another page and i return to previous page i have to find the data previously edited (you can use some cookies to remember the data or save that data inside the tablet)
Inside each page there also must be present a "Start Time" and "End Time" editable by the user.
When i open a page the "Start time" must be filled automatically with current hour and minute but if the user want to edit the start time he can modify it and a button called "Current Time" must be present near the "Start Time" and if i press the "Current Time" button the Start Time is automatically filled with current hour and minute
About the unique id of the database (i mean the database key) i think we can use as unique key database the page from 1 to 14.
When the user press the "Send" button in the page 5, for example, we save the record in the database using id database key the number 5.
If the user modify the page 5 and press again the "Send" button inside the database we have modify previous database record.
When the user press the "Send" button I think we can send an HTTP POST command to the server with the database and create in the server a .php page capable to manage an HTTP POST command.
It is also a good idea that when this .php page receive the POST data send back to the Android page an acknoledgement with something like "Data received" and the label "Data received" disappears in a few seconds.
Another important requirement is: there is only one mySql database but there are ten Android Tablet and we also have to understand from which tablet the command arrive. I think we can configure each tablet saving a .txt file or, if there are no additional cost, we can read the mac-address of the tablet to be sure it is an unique value.
9 freelancers are bidding on average €40 for this job
Hi, you will not be required to install php soon the tablet. I will create a solution where you can add content and update kiosk remotely. message me for further details