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]

Zeeshan Rasool is the founder and editor of this blog. Beside this, he is an experienced PHP web developer and freelancer. He loves to create best and interactive web apps. You can follow him at twitter @99_Points 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

Categories

Popular post

Friends

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

Table Structure:

Javascript Code:

PHP Code

Few More Brilliant Posts !

Categories

Popular post

Friends