I gang

User database with comment, rating, favourite for foursquare venue with API access

I have an iOS application uses Foursquare API to query venues. I would like to have a user database, user can register an account, post comment, rate venue, check-in venue, and save venue as favourite.


User Info: ID, Name, Email, Photo, Gender

User Favourite: Foursquare unique venue ID, User ID ("ID" from User table)

Venue Comment: Foursquare unique venue ID, Poster Name ("Name" from User table), Poster Photo ("Photo" from User table), Posted Timestamp(YYYY-MM-DD), Message

Venue Rating: Foursquare unique venue ID, Rating (value range 1 to 5)

Venue Check-in: Foursquare unique venue ID, total number of check-ins, User ID (one user can only check-in a venue one time)

Frontend (admin panel):

Manage user, user favourite tables

Manage venue comment, rating, check-in tables

API access (return in JSON format):

Create new user with ID, Name, Email, Photo, Gender

Return ID, Name, Email, Photo, Gender

Change User Photo

Post comment (by Foursquare unique venue ID)

Send Foursquare unique venue ID to return comment Poster Name ("Name" from User table), Poster Photo ("Photo" from User table), Posted Timestamp, Message. Each of the comment post (poster name, timestamp, message) is in an array.

Send Foursquare unique venue ID to return Rating

Send Foursquare unique venue ID to return Check-in total count

Send ID to return Favourites (Foursquare unique venue ID)

You can take a look my website [url removed, login to view] about this iOS app, hopefully can give you some ideas of what the app looks like and how I would like to achieve, I am currently using Disqus comment system, and I would like to have similar basic features.

More clarification: The iOS app already displays restaurants with Foursquare API, and I can provide unique venue ID when calling a custom API(post/load comment, set/load rating, set/load check-in). I would like to integrate my own user database (not from foursquare). The users can register an account through the iOS app, and start to post comment, give rating or check-in to a restaurant or add a restaurant to user's favourite list. (this user account has no relationship to foursquare API)

It looks my previous project description wasn’t clear and even seem confusing to some bidders, I will try to explain again.
The iOS app is already in Apple Appstore, that’s using Foursquare API (https://developer.foursquare.com/docs/venues/explore) to retrieve a list of venues, when a venue is selected, the iOS app navigate to the detail page of the venue, within the detail view, I would have captured the venue’s unique venue ID (e.g 4ef0e7cf7beb5932d5bdeb4e ) and assign it to a variable(NSString). I am using these venue data (address, phone, name, cuisine, photos) from Foursquare API and that’s already managed by the iOS application, and that’s all the data I want to use from Foursquare API. What I need is my own user database, my users can register an account(not a foursquare account) and post comment(not from foursquare), rating(not from foursquare), check-in(not from foursquare), add favourite(not from foursquare), all these action are done through APIs calls within the iOS application.
Front-end (admin panel only) there will be no front-end user web interface:

- Manage user, user favourite tables

- Manage venue comment, rating, check-in tables

PHP only please, no asp.net. Use API token to establish a session for all API calls:

API Example:

- Add rating
Required parameters: UNIQUE_VENUE_ID
Return Success or Error
Result create an entry in venue table, rating key

- Add check-in
Required parameters: UNIQUE_VENUE_ID, USERNAME
Return Success or Error if username already exist in the table
Result create an entry in venue table, checkin key

- Retrieve custom rating and check-in count
Required parameters: UNIQUE_VENUE_ID
Return: Average rating and Total Check-in count

- Add a comment
Required parameters: UNIQUE_VENUE_ID, USERNAME
Return: Success or Fail if exact same comment has been posted in less than 1 min
Result create an entry in comment table, unique_venue_ID, username keys

- Retrieve comments
Required parameters: UNIQUE_VENUE_ID
Return: list of comment in array, inside the array, it includes (Poster name, poster profile photo, comment created timestamp (YYYY-MM-DD)

- New user registration:
Required parameters: username, name, password, email, photo, gender
Return Success or Error
Result create an entry in user table, username, name, password, email, photo_url, gender keys

- Retrieve user profile:
Required parameters: username, password
Return Name, Email, Gender, Photo

- Edit user photo profile:
Required parameters: username, password, photo
Return Success or Fail
Result update user table, photo key

- Change user password:
Required parameters: username, password
Return Success or Fail
Result update user table, password key

- Edit user Name(not username):
Required parameters: username, password
Return Success or Fail
Result update user table, name key

- Add user favourite:
Required parameters: username, UNIQUE_VENUE_ID
Return Success or Fail if UNIQUE_VENUE_ID already exists
Result add an entry in user favourite table, favourite key

- Retrieve user favourites:
Required parameters: username
Return Venue_Unique_ID in an array

Evner: HTML, MySQL, PHP, Web Design

Se mere: how design a poster, comment system in php, how to design a database, how to design a poster, venue, unique user, poster app, new venue, my rating, iOS database, ios app for database, disqus, create similar access, backend php ios, api access access database, create venue, php table array, access database api, access query table, photo send email app, php backend ios app, design rating system, value json php, ins app, ios json

Om arbejdsgiveren:
( 1 bedømmelse ) Burnaby, Canada

Projekt ID: #6001430

Tildelt til:


Hi, I have reviewed your project description and I am confident I can complete your website with all the customization you want to have integrated in the back-end. I am an experienced web developer for more than 5 year Flere

$1272 CAD in 26 dage
(50 bedømmelser)

22 freelancere byder i gennemsnit $1457 på dette job


GET IT DONE RIGHT THE FIRST TIME! My clients are first and communication is very important. Hello Sir/Ma'am, yes indeed I read descriptions however, I have 1 chance to make a first impression. I want to ensure you tha Flere

$1600 CAD in 15 dage
(130 bedømmelser)

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No sub Flere

$1391 CAD in 20 dage
(89 bedømmelser)

1. Vollks Australian Online Store In these days we are complete re-designing and reimplementing an online store for our Australian client in which we are using X-Cart latest stable release to implement his all require Flere

$1500 CAD in 30 dage
(97 bedømmelser)

Hi, I have gone through your project description and could assure you the best of the solution. I am taking it as an opportunity and ready to deliver my best. We will be using open source LAMP technology to dev Flere

$1894 CAD in 40 dage
(166 bedømmelser)

Hi, I have extensive experience working on custom CMS/web applications in PHP/MySQL. I'll be happy to help you out. Cheers.

$1333 CAD in 20 dage
(24 bedømmelser)

Hello, Saw your job posting and your requirement seems perfect for me as per My skills. Here you can see my work portfolio with some samples of my work.. [login to view URL] We are a team of 14 ful Flere

$2105 CAD in 20 dage
(13 bedømmelser)

I can develop it and can start soon. A brief about me: My name is Mainuddin and I am a Senior Software Engineer from Dhaka, Bangladesh. I have over 7 years of experience in applications development and worked in v Flere

$1473 CAD in 40 dage
(85 bedømmelser)

Hi, I can provide the required solution. I assure you the best service. If any one can do, I can do better. Please let me know when to start. Regards.

$1052 CAD in 20 dage
(22 bedømmelser)

Greetings! We are the fastest growing software development and digital media solutions group in India. Led by a team of FORMER GOOGLE AND GROUPON EMPLOYEES, we are the answer to the primary issue associated with tec Flere

$1915 CAD in 40 dage
(11 bedømmelser)

Greetings, Thank you for giving us a chance to bid on your project. We have looked at your project specs and we are confident that we can deliver you robust and reliable solution. We have successfully completed more th Flere

$1300 CAD in 25 dage
(24 bedømmelser)

have gone through with the requirement and we can start this project now. I want to introduce our self, we are a group of freelancers we have 11 year of experience in web application development and design, we w Flere

$1100 CAD in 25 dage
(24 bedømmelser)

Dear Sir, Can i use asp.net to implement this project? Currently i have an asp.net application which running as service to query all foursquare data and save to my database, so i just add an admin panel for your pr Flere

$1222 CAD in 15 dage
(43 bedømmelser)

Dear sir, hope you are doing good We welcome the opportunity to build a cutting-edge mobile application and website and deploy to develop mobile apps for that will increase sales and customer retention. Offenderste Flere

$1500 CAD in 30 dage
(5 bedømmelser)

My team is really interested in this project as it is exactly within our scope of expertise: We are WEB application design & development experts. Please kindly visit our website [login to view URL] to learn more about us and Flere

$2444 CAD in 60 dage
(13 bedømmelser)

Hello. I am a web developer with 11+-year experience . I work remotely on DigitalRay company - [login to view URL] - LA (USA). Technical knowledges: 1PHP JavaScript Ruby RoR ASP.Net C#, Java, Python, Zend, CakePHP, Symph Flere

$750 CAD in 20 dage
(35 bedømmelser)

Hello! Here are some websites I have finalized - [login to view URL], [login to view URL] And here is a site I am working on - [login to view URL] (on private domain). I am also working on two major project to replicate Flere

$2000 CAD in 30 dage
(2 bedømmelser)

Hi there, We are a packaged dynamic team of iOS & Android programmers, We have created both utility as well as gaming apps & are responsible for the design, development and deployment. Willing to start work ASAP & f Flere

$1546 CAD in 15 dage
(2 bedømmelser)

Hi, We are keyed up to turn this opportunity into a long term business relationship with you and will be glad to assist on any element, whenever needed. We are ready to start immediately and provide 3 months free bu Flere

$1250 CAD in 20 dage
(4 bedømmelser)

Hi. I can definitely give you a php script and set up mySQL to handle both admin and api access. Let me know if you are interested and we can discuss the project in more detail. Thanks for considering my bid!

$888 CAD in 7 dage
(3 bedømmelser)

A proposal has not yet been provided

$1263 CAD in 35 dage
(0 bedømmelser)