below this link i have a ratting thing. in this its working but here update and disply part.
http://www.namshimoga.com/searchdetails.php?idval=399&maincatid=147&maincateg=Testingmp#details
in another page http://www.namshimoga.com/searchbycat.php?catagory=Testingmp&maincateg=Testingmp&maincatid=147 i want to display only final rating without updation.
its my display part
<div class='headstar'>
Rate It !
<ul class='star-rating'>
<li class='current-rating' id='current-rating'><!-- will show current rating --></li>
<span id='ratelinks'>
<li><a href='javascript:void(0)' title='1 star out of 5 Poor' class='one-star'>1</a></li>
<li><a href='javascript:void(0)' title='2 stars out of 5 Average' class='two-stars'>2</a></li>
<li><a href='javascript:void(0)' title='3 stars out of 5 Good' class='three-stars'>3</a></li>
<li><a href='javascript:void(0)' title='4 stars out of 5 Very Good' class='four-stars'>4</a></li>
<li><a href='javascript:void(0)' title='5 stars out of 5 Excellent' class='five-stars'>5</a></li>
</span>
<input type='hidden' name='id' id='id' value=' $id '>
<input type='hidden' name='mainid' id='mainid' value=' $maincatid '>
</ul>
</div>
starratting.js
// JavaScript Document
$(document).ready(function() {
// get current rating
var value = $("#id").val();
var main = $("#mainid").val();
getRating();
// get rating function
function getRating(){
$.ajax({
type: "GET",
url: "update.php",
data: "do=getrate&id="+value,
cache: false,
async: false,
success: function(result) {
// apply star rating to element
$("#current-rating").css({ width: "" + result + "%" });
},
error: function(result) {
alert("some error occured, please try again later");
}
});
}
// link handler
$('#ratelinks li a').click(function(){
$.ajax({
type: "GET",
url: "update.php",
data: "rating="+$(this).text()+"&do=rate&id="+value,
cache: false,
async: false,
success: function(result) {
// remove #ratelinks element to prevent another rate
$("#ratelinks").remove();
// get rating after click
getRating();
},
error: function(result) {
alert("some error occured, please try again later");
}
});
});
});
update.php
<?php
// connect to database
session_start();
/*$dbh=mysql_connect ("localhost", "root", "") or die ('Cannot connect to the database');
mysql_select_db ("beauty_spa",$dbh);*/
include("db.php");
//$id=$_GET['id'];
//echo "id".$id;
if($_GET['do']=='rate'){
// do rate
rate();
}else if($_GET['do']=='getrate'){
// get rating
getRating();
}
// function to retrieve
function getRating(){
$id = strip_tags($_GET['id']);
$mainid = strip_tags($_GET['mainid']);
$sql= "select * from vote where spaid='$id' and mainCatagoryid='$mainid'";
$result=@mysql_query($sql);
$rs=@mysql_fetch_array($result);
// set width of star
$rating = (@round($rs[value] / $rs[counter],1)) * 20;
echo $rating;
}
// function to insert rating
function rate(){
$text = strip_tags($_GET['rating']);
$id = strip_tags($_GET['id']);
$mainid = strip_tags($_GET['mainid']);
$update = "update vote set counter = counter + 1, value = value + ".$_GET['rating']." where spaid='$id'";
$result = @mysql_query($update);
if(@mysql_affected_rows() == 0){
$insert = "insert into vote (counter,value,spaid) values ('1','".$_GET['rating']."','$id')";
$result = @mysql_query($insert);
}
}
?>