iOS-APP with GCDWebServer and SQLITE

$30-250 USD

Lezárt

Kiadva ekkor:

majdnem 10 évvel ezelőtt

$30-250 USD

Teljesítéskor fizetve

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

iOS-APP with GCDWebServer and SQLITE

$30-250 USD

$30-250 USD

A projektről

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Az ügyfélről

Ügyfél-hitelesítés

További munkák ettől az ügyféltől

Hasonló munkák