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.

Backend:

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
https://api.domain.com/new_venue_rating/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
https://api.domain.com/new_venue_checkin/UNIQUE_VENUE_ID
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
https://api.domain.com/custom_venue_info/UNIQUE_VENUE_ID
Return: Average rating and Total Check-in count

- Add a comment
Required parameters: UNIQUE_VENUE_ID, USERNAME
https://api.domain.com/new_venue_comments/UNIQUE_VENUE_ID
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
https://api.domain.com/venue_comments/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
https://api.domain.com/new_user
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
https://api.domain.com/users/USERNAME
Return Name, Email, Gender, Photo

- Edit user photo profile:
Required parameters: username, password, photo
https://api.domain.com/add_user_photo/USERNAME
Return Success or Fail
Result update user table, photo key

- Change user password:
Required parameters: username, password
https://api.domain.com/change_user_password/USERNAME
Return Success or Fail
Result update user table, password key

- Edit user Name(not username):
Required parameters: username, password
https://api.domain.com/change_user_name/USERNAME
Return Success or Fail
Result update user table, name key

- Add user favourite:
Required parameters: username, UNIQUE_VENUE_ID
https://api.domain.com/add_user_favourite/USERNAME
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
https://api.domain.com/user_favourites/USERNAME
Return Venue_Unique_ID in an array

Færdigheder: 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:

pytho

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 Mere

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

22 freelancere byder i gennemsnit $1457 for dette job

USAGraphicPR0

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 Mere

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

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 Mere

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

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 Mere

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

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 Mere

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

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)
6.3
Lavlu

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.. [url removed, login to view] We are a team of 14 ful Mere

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

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 Mere

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

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)
6.2
Accenza1

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 Mere

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

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 Mere

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

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 Mere

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

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 Mere

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

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 Mere

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

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 [url removed, login to view] to learn more about us and Mere

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

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

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

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

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

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 Mere

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

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 Mere

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

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)
2.8
LynchpinTech

A proposal has not yet been provided

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