Ajax Rating System: Create Simple Ajax Rating System using jQuery AJAX and PHP.

Author: Zeeshan Rasool | May 23, 2010

AJAX, JQuery, PHP, Web Development

Simply programmed, CSS based stylish Ajax rating system which you can use any where to put a stylish jquery effect based rating system.

[ad#ad-4]

Table Structure:

CREATE TABLE `ajax_ratings` (
  `id` int(11) NOT NULL auto_increment,
  `image_id` int(11) NOT NULL default '0',
  `rating` int(11) NOT NULL default '0',
  `users_ip` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id`)
)

CREATE TABLE `ajax_ratings` (

`id` int(11) NOT NULL auto_increment,

`image_id` int(11) NOT NULL default '0',

`rating` int(11) NOT NULL default '0',

`users_ip` varchar(200) NOT NULL default '',

PRIMARY KEY (`id`)

)

Javascript Code:

$(document).ready(function(){	
	$('#loader').hide(); 
	$('#inner').children().click(function(){
		var a = $(this).attr("id");
		$.post("rating.php?value="+a, {
		}, function(response){
			$('#inner').fadeOut();
			$('#inner').html(unescape(response));
			$('#inner').fadeIn();
			setTimeout("hideMesg();", 2000);
		});
	});	
});	
	
function hideMesg(){

	$('.rating_message').fadeOut();
	$.post("rating.php?show=1", {
	}, function(response){
		$('#inner').html(unescape(response));
		$('#inner').fadeIn('slow');
	});
}

$(document).ready(function(){

$('#loader').hide();

$('#inner').children().click(function(){

var a = $(this).attr("id");

$.post("rating.php?value="+a, {

}, function(response){

$('#inner').fadeOut();

$('#inner').html(unescape(response));

$('#inner').fadeIn();

setTimeout("hideMesg();", 2000);

});

function hideMesg(){

$('.rating_message').fadeOut();

$.post("rating.php?show=1", {

}, function(response){

$('#inner').html(unescape(response));

$('#inner').fadeIn('slow');

});

}

[ad#co-2]

PHP Code

include("dbcon.php");
$users_ip = $_SERVER['REMOTE_ADDR'];
if($_REQUEST['value'])
{
	$id = $_REQUEST['value'];
	$result = mysql_query("select users_ip from ratings where users_ip='$users_ip'");
	$num = mysql_num_rows($result);
	
	if($num==0)
	{
		$query = "insert into ratings (rating,users_ip) values ('$id','$users_ip')";
		mysql_query( $query);
		
		$result=mysql_query("select sum(rating) as rating from ratings");
		$row=mysql_fetch_array($result);
		
		$rating=$row['rating'];
		
		$quer = mysql_query("select rating from ratings");
		$all_result = mysql_fetch_assoc($quer);
		$rows_num = mysql_num_rows($quer);
		if($rows_num > 0){
		$get_rating = floor($rating/$rows_num);
		$rem =  5 - $get_rating;
		}
      }
}

include("dbcon.php");

$users_ip = $_SERVER['REMOTE_ADDR'];

if($_REQUEST['value'])

{

$id = $_REQUEST['value'];

$result = mysql_query("select users_ip from ratings where users_ip='$users_ip'");

$num = mysql_num_rows($result);

if($num==0)

{

$query = "insert into ratings (rating,users_ip) values ('$id','$users_ip')";

mysql_query( $query);

$result=mysql_query("select sum(rating) as rating from ratings");

$row=mysql_fetch_array($result);

$rating=$row['rating'];

$quer = mysql_query("select rating from ratings");

$all_result = mysql_fetch_assoc($quer);

$rows_num = mysql_num_rows($quer);

if($rows_num > 0){

$get_rating = floor($rating/$rows_num);

$rem = 5 - $get_rating;

}

[ad#co-3]

Recommended WordPress Themes Stores

If you enjoyed this post, please consider leaving a comment below or subscribing to the RSS feed to have future articles delivered to your feed reader. You can also follow us on Facebook or Twitter @99Points

This awesome post has been created by 99Points editor's team. You can follow our updates on Twitter and facebook, OR drop an email at 99points.info@gmail.com

Author of 99Points
Zeeshan Rasool is an experienced PHP Web Developer and founder at 99Points. Expert in Codeigniter (MVC), WordPress, JSON, jQuery & HTML5

Ajax Rating System: Create Simple Ajax Rating System using jQuery AJAX and PHP.

Table Structure:

Javascript Code:

PHP Code

Recommended WordPress Themes Stores

Categories

Popular post

Ajax Rating System: Create Simple Ajax Rating System using jQuery AJAX and PHP.

Table Structure:

Javascript Code:

PHP Code

Few More Brilliant Posts !

Recommended WordPress Themes Stores

Categories

Popular post