Project Detail
AJAX star rating script and some php/MySQL integration
AJAX star rating script and some php/MySQL integration is project number 65108
posted at Freelancer.com. Click here to post your own project.
Bid Count: 13
Average Bid:
$ 246
07/07/2006 at 10:19 EDT
Project Creator:
lavag
Employer Rating: (No Feedback Yet)
Description
I’m looking to get a quote for some AJAX and PHP scripting. Basically I’m trying to get a review site up and running where people who have registered can vote on restaurants, bars, etc. in a local community in the UK.So far I have the basic MySQL database structure in place with some normalization (see database layout), and I have a freely distributed log-in/authorisation script that the ajax SQL query’s should integrate into (notably session.php, database.php and constants.php).
I want to allow users who have registered to be able to vote on various aspects of a service (such as a restaurant’s service, ambience, value for money). The user can either rate a service and place a review, or just rate. A review button needs to be coded to take the user to a url where they can rate and review the service. When just rating, AJAX should make it so it can be done without leaving the page or refreshing.
The user should be able to update their ratings for a particular service at any time (similar in functionality to Windows media player). (see attached jpeg which should make things clearer). So they can mouseover and click to change their ratings near the header of the particular service and when the stars appear next to a review they have written. A timestamp should also be inserted/updated into the database whenever they vote/revote. I’m not sure how best to draw the static stars (ie. those in the reviews of other users) – whatever you think most elegant/efficient.
The ‘sub’ ratings should be linked to an average for the user’s ratings displayed in larger stars with a figure, and a series of other stars detailing the average of all user’s ratings. A rounded average of the users total, and updated (after user voted) rounded average of all users from however many votes (Sorry if this sounds really confusing – the jpeg should help).
A function should be included to test the type of service from the service table, to ensure that the sub ratings text matches up ie. for restaurant – value for money, service, and ambience, for gym – value for money, equipment, service. The function should also test how many sub-ratings there are, so that it could display just one or up to, say, five different ratings in the rating matrix.
The key variable for updating the ratings table is $upk (user primary key) or $_SESSION[‘upk’]. This identifies the user from the registration details that are entered in the user table. Also the service id can be identified by the variable $spk (service primary key) in the service table.
Non-registered users will be able to see all of the site, but obviously have no mouseover rating and review functionality. The ‘if($session->logged_in){’ checks for login. (see your rating example, within the authorisation script by running main.php, attached).
Linking on from this I was hoping you could integrate this code properly into the OOP login script
In the attached files I have a non-integrated freely-distributed AJAX rating script, but without any of the functionality I need. You could use this as a starting point or start form scratch.
As well as the site there are two word files attached, one detailing the current preliminary layout of the tables, and the other detailing the user, rating, and service fields and how they interact.
The Java scripting should be made as secure as possible, and some annotation would be appreciated.
That’s it really. Obviously with this coding complete I’ll be a big step forward toward completion, but with some way to go. In an ideal world I’d leave all of the coding and design to a professional, but I’m balancing this project with other commitments. Doubtless though, I will need more work doing further down the line in terms of design, compliance, debugging, security, back end content management, etc.
Additional files submitted:
reviewsite.zip
|
Job Type |
|
Provider Rating
WHAT IS FREELANCER.COM?
Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!
We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started!
Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.
- Plendo Sweden AB © 2004-2009
- PRIVACY POLICY
- TERMS
- AFFILIATES
- API
- QUOTES
- CONTACT
Freelancer™ is a trademark of Ignition Networks Pty Limited (ACN 134 845 748)
Newly Outsourced Projects fed by 
Follow our Freelance Jobs on Twitter 
Add to your
Google search results