I need an iPhone UI app developed that would integrate with a MySQL database.
The MySQL database will be available on pc on a local network which has web services.
You can use an Objective-C library for accessing MySQL (attached)
for development and testing purposes, the database has been made available for access on the internet.
The iPhone app is required to run MySQL string/command when connected to the database.
Example of the string/commands can be found in the following link:
<[login to view URL]>
For the 'operation login and password' in the link above, you can use the following username and password.
Username: development
password: develop
The application will be used to do stock take, confirm new stock and report maintenance.
I have attached example screenshots of my requirement.
I am willing to accept suggestions for changes to the iPhone UI app if necessary.
How it works:
1. The iPhone app. would run the string/command in the database (for example of string/command, please visit the link provided above)
2. The database is updated
3. A different application running on a server in the same network polls/reads the database every few seconds and processes the information further.
(Note: Requirement for this project is only point 1. above)