lol just use CSS, HTML, PHP and mySQL.
I have a rating system I made ages ago when I was going to make a video site.
In the database make a table with 3 columns, VideoID, TotalR (Total Rating) & TimeR (times rated)
For a simple one, Then make a simple php page like.
PHP Code:
<?php
$videoID = "Pron";
$database_user = "user";
$database_pass = "pass";
$database = "Test";
$database_table = "Video";
$rated = $_GET['rating'];
mysql_connect("localhost", $database_user, $database_pass) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());
if(isset($_GET['rating'])){
if($rated == 1 || $rated == 2 || $rated == 3 || $rated == 4 || $rated == 5){
$sql = mysql_query("SELECT * FROM '".$database_table."' WHERE videoID = '".$videoID."'") or die(mysql_error());
$data = mysql_fetch_array($sql);
$TotalR = $data['TotalR'] + $rated;
$TimeR = $data['TimeR'] + 1;
mysql_query("UPDATE '".$database_table."' SET TotalR = '".$TotalR."' WHERE videoID = '".$videoID."'");
mysql_query("UPDATE '".$database_table."' SET TimeR = '".$TimeR."' WHERE videoID = '".$videoID."'");
echo "Average Rating For This Video Is ".$TotalR / 5;
echo "<br> This Video has been rated on ".$TimeR;
}else{
echo "Sorry That Rating is not avaiable";
}
}
else{
echo "<a href=\"page.php?rating=1\">Rating 1</a>";
echo "<a href=\"page.php?rating=2\">Rating 2</a>";
echo "<a href=\"page.php?rating=3\">Rating 3 </a>";
echo "<a href=\"page.php?rating=4\">Rating 4</a>";
echo "<a href=\"page.php?rating=5\">Rating 5</a>";
}
?>
That should work I haven't Tested it. Just change the DB details accordingly.
You can Add Pictures etc.
But I don't think you should be writing a video wiki site if you are having trouble with a rating system xD.
