we need an ipad software which has a webserver running and answers to links in htmlpages. all local on the ipad.
Webserver: use of the library GCDWebServer
Database: use of the SQLITE database
1) make a db named apollo. create a table products(idproduct=serial, productnumber=text10, producttext=text250)), fill in some data
2) write a class db_cursor where we can give a sqlstring and return a cursor-like object for looping through the dataset. i dont know if there is similar functionality of a cursor in ios. i want to have it like my example, because then its compatible with my vb.net application. of course the if statement is different...
i want to program like this:
db_cursor("SELECT * FROM products, crsdb)
If [login to view URL] Then
While [login to view URL]
x=crsdb("message")))
End While
End If
3)write a function db_execute(“my insert or update statement”) which executes the sqlstatement
4) APP Starts with empedded browser (fullscreen) and calls the starturl
starturl: [[localWebserver]]/apollo?METHODE=HOME
the webserver produces as output a html page (<html><head>....</html>) which shows the actual time and the http url from the webserver and a link to [[localWebserver]]/apollo?METHODE=PRODUCTS
5) when the user click on the link for the products the httpserver should return a html page with a list of the products. you should use the db_cursor function for reading the data from database and prepare the html output
6) when the user clicks in the productspage the link ADDPRODUCT=[[localWebserver]]/apollo?METHODE=ADDPRODUCT then a form should be shown where the user can input data and submit it to the database. use the db_execute-function for writing to the database. when the user submits the form then the app should bring up the productslist and we can see the added data.
7) when the user clicks in the productspage the link EDITPRODUCT=[[localWebserver]]/apollo?METHODE=EDITPRODUCT&PRODUCTID=<idproduct> beside a productrow, then a form should be shown where the user can input data and submit it to the database. when the user submits the form then the app should bring up the productslist and we can see the added data.
8) the user should not see anything from the browser in the application, so that he feels it as a native app
9) we need the sourcecode and all rights
you find gcdwebserver on
[login to view URL]
thanks