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.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: markdave

Budget: $100-300

Created: 06/02/2006 at 10:19 EDT

Bid Count: 13

Average Bid:
$ 246

07/07/2006 at 10:19 EDT

Project Creator: lavag
Employer Rating: (No Feedback Yet)

Bid On This Project
 

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

Messages Posted:1 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

300

12 days

06-03-2006 06:19 EDT

Our bid is for really very high quality work for your AJAX star rating script and some php/MySQL integration that will be made to be upgradable in case you need some upgrades in future. We will always be available for upgrades. Our bid includes six week free technical support. We will offer full assistance in getting the website running on your server. Our job will not be over before that. W WE WILL DELIVER PRODUCT EXACLTY ACCORDING TO YOUR SPECIFICATIONS. We will keep you updated about the progress of your project by hosting it on our web server. Thus you can always view and test your projects progress. This will enable us also to get your timely feedback and thus we will be able to deliver exactly what you need and that too on time!!. Also please let us know if further clarification is due on our part regarding our bid. We will be be more than pleased to hear back from you We have experts in ASP.NET -- VB.NET -- C# -- MS-SQL -- Access -- PHP -- MySQL -- Java -- JSP -- PERL -- Cold Fusion etc. We look forward to a great association with you... Plz give me a chance to show my quality expertise. Regards, ADMIN Seven Applications Plz review our portfolio: You can see our work at www.sevenapps.com Our Clients: www.parkingaccess.www.cvmonkey.com, itishotel.com, ativasativa.com, www.singhvijewels.com www.urbanchat.com www.pettshirt.com www.tshirtsafari.com

help

 

280

15 days

06-03-2006 18:07 EDT

We can provide you quality work.

help

 

300

5 days

06-02-2006 10:39 EDT

Hi, Please Check your PMB for details. Regards, Dave.

help

 

300

10 days

06-12-2006 19:16 EDT

See message board for details.

help

 

240

10 days

06-03-2006 00:00 EDT

Chandusoft is a customer-specific service oriented company has got an Professional and creative team with 6 years experience in Web design and development. We have expertise and experience in ecommerce site development, falsh and animation. Our team can work on HTML, DHTML, JAVA SCRIPT, FLASH , ASP,ASP.NET,PHP, MY SQL, SQL Server, MS SQL. Bid includes development , deployment and testing. we offer 30 days free support. We are ready to start and send daily reports. we communicate through mail,messenger,phone and skype.We have expertise and experience in ecommerce site development, falsh and animation. List of sites we completed in last 2 months ->Ecommerce & PHP , MySQL projects 1. bodyjewels.com/store 2. pmtconline.biz/cart/ 3. imprintproducts.com 5. cybershop.ws 6. audiovisual.co.uk 7. jeunefusion.com 8. aotcsolutions.com/catalog 9. opticalmax.com 10. oxzee.com 11 pricecheaters.com 12. 2axiom.com 13. chandusoft.net/store/ 14. oms.akohosting.com/koala 15. chandusoft.net/ryoku 16. francospizzeria.com/store/ 17. 1001games.com/store/index.php 18. arastore.com ->Web design and flash 1. chandusoft.net/jesuit 2. chandusoft.net/satya/internap 3. chandusoft.net/satya/flash1/ 4. chandusoft.net/satya/flash2/ 5. chandusoft.net/dj/ 6. techmantraonline.com 7. chandusoft.com 8. chaina-ready.com 9. eglownetworks.com 10. e2006hbs.com 11. chandusoft.net/devendra/ 12. chandusoft.net/jesuit 13. chandusoft.net/mobilezone 14. claimconsultant.com

help

 

285

3 days

06-02-2006 17:58 EDT

Hi, have done voting using XAJAX for PHP. Please, see PMB for more info. Dima.

help

 

100

15 days

06-05-2006 13:31 EDT

hi I am manu mehrotra a software eng. student from Inia I have been working on php and ajax lately and have designed a script which might do your job you can see the demo at manu.jetpage.biz/rate please consider my bid, I am starting work on your system from today and would place a demo on my site in a day or two. Pleas PM me for more conversation ragarding bid price etc Thanks a lot Manu Mehrotra

help

 

150

5 days

06-02-2006 13:08 EDT

We are specialized in web design, corporate identity,web development, software development

help

 

300

25 days

06-03-2006 13:21 EDT

We are team of professional’s expertise in developing web based application using PHP/ASP/.NET and in web designing using Photoshop, Dreamweaver MX, Flash MX.After reading your project description, we are highly interested to develop the application for you. Please feel free to contact me through PMB for any clarifications required. Regards, Madhav vyas

help

 

300

3 days

06-02-2006 10:53 EDT

(No Feedback Yet)

Hi, Please see PM. Thanks

help

 

200

14 days

06-02-2006 13:20 EDT

(No Feedback Yet)

I have 5+ years experince in Web Devlopement(JSP/Servlets,Perl,Could Fusion,PHP,MYSQL) and i have completed more than 30 sites in Perl,Could Fusion,PHP,JSP/Servlets. I am 100% certain that I can deliver an excellent site for you . Looking forward to working with you

help

 

200

10 days

06-02-2006 23:05 EDT

(No Feedback Yet)

Instance Software Solutions (ISS) is a product based company which is having rich experience on developing enterprise, distributed and web based applications using PHP/Mysql/Java/HTML/JavaScript/ JSP/Servlets/Struts/EJB/J2EE/Oracle/ASP/.Net technologies. ISS is based out Bangalore, having dedicated professional on various technologies and follows various industry standards to develop and deploy application with in time with good quality and reasonable prices. Thanks, Instance Software Solutions (ISS), Bangalore, India

help

 

240

6 days

06-06-2006 02:16 EDT

(No Feedback Yet)

I have already developed such projects. I am starting work from today and would place a demo on my site.

help


    Bid on this Project