We have a mobile website with 3 core pages-
1. Index Page
2. Business Results Page
3. Business Profile Page
The website is graphically designed and the layout is 90% fixed already.
Where we require help is with
a) Extracting data correctly from MySQL to each page.
(e.g The website is in 13 different languages so we need different tables referenced for different pieces of information)
b) inputting IF functions etc so specific pieces of information are displayed for certain results.
At present a user can sort business results by name, area, rating and open/closed. We would like to have sorting results based on the type of business - e.g Hotels would display filters for Name, area, rating while restaurants would display filters for Name, area, cuisine etc
c) Adding in data input options where the user can select a range of values for fields and this data is then saved on the server and used to return later results. The users i.p would also be tracked so they could not enter duplicate results in that field again.
For example - A user can go into a HOTELS profile and rate it 4 out of 5 stars. The users selection would then be taken into account for the overall score of the hotel when the database was next updated. But the users i.p would be logged and stop them from rating that particular hotel again.
We would also require the script to update the websites results data which would be run off the server at our discretion (most likely once a day)
d) Inputting a photo gallery page with thumbnail previews initially.
e) A google map sync using gps locations of users mobile devices to show businesses located near the user, with a filter included so the user can show only certain business types (we have longitude and latitude information for all our businesses in a mysql table already)
f) a form for users to submit data to the website (including pictures) and/or contact the website admins.
g) a few other small bits and pieces of coding of already existing code on the site.
There is already php involved on the site, but some of it is broken and it was never suitable for our requirements with a) multiple languages and b) data input by users.
The site so far can be viewed presently at the below address to give you an idea of what it is about
[url removed, login to view]
This is a mobile only site which will be converted to an app using appypie so CSS layouts already in place are important.
We have all the data already in place on our mysql database and the site is already somewhat functional. We really just need someone to finish off the final coding for us.