346819 iPhone song Request App & site

Two developments 1. Simple website interface & database. 2. iPhone application This iPhone application will allow "requester" users to use their phone to request music selections when visiting a dance club. The "dance club" user can look at requests for only their club. a. The "requester" will create a profile through the iPhone application or webite. b. The "requester" user will select a club from a list found on our online database, enter a "club code #" if they know it, or using current GPS location. c. The "requester" user will then search for and select a song name by title, artist, or album. The phone will perform searches from data on our server. d. When the "requester" user presses submit, the iPhone application will add the request to the website database. e. Each request will store the requestor information, time & date. f. The iphone application will remember the user's favorite clubs and favorite songs so the application does not have to access the database everytime the user wants to make a request. Website Development 1."Dance club" user will create a profile on the website. Including, adderss location information, gps location and contact information. 2."Dance club" user can see the list of all requests. 3. Requests will be organized by day. Only one day will be shown per results page. 4. Requests will be deleted from the server database automatically after they are 30 days old. 5. If multiple "requestors" request the same song, then it is listed once with the number of times requested that day. "Dance club" user can click on this song and the users will be listed under. 6. Website will give the "dance club" user a club code # that they can share with customers (as above). 7. Develop PHP website pages to give the same operation as iPhone application to a "requester" user who wants to use the website instead of the iPhone. 8. Allow website to show a list of clubs and their "club codes". Sort by country, state/region, city. We will provide programmer with a PostgreSQL database with sample data and a simple PHP CMS website on our server they can modify. Programmer is required to program web pages using PHP Smarty templating method.