Tijden veranderen
Rating systeem maken
Nu zou ik graag een rating systeem hebben, die een gemiddelde neemt van stemmen, en tevens het ip adres vastlegt, om mulitple voting tegen te gaan.
Om eerlijk te zijn heb ik er geen idee van hoe eraan te beginnen? bij elke DJ zou er dus gerate moeten kunnen worden mbv van images (sterretjes ofzo)
Alvast bedankt,
en kom aub niet af met links zoals hotscripts etc, want tegen dat je dat verwerkt hebt, ben je er langer aan bezig dan dat je zelf iets samensteld.
http://www.che-lives-clan.com/starcraft/downloads.php?id=1
Maar er zit nog geen beveileging op voor meerdere keren stemmen:
Dit is de mysql table:
CREATE TABLE `rating` (
`id` int(5) NOT NULL auto_increment,
`rating_1` int(4) NOT NULL default '0',
`rating_2` int(4) NOT NULL default '0',
`rating_3` int(4) NOT NULL default '0',
`rating_4` int(4) NOT NULL default '0',
`rating_5` int(4) NOT NULL default '0',
PRIMARY KEY (`id`)
)
//pagina voor te stemmen:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
<?php
if($_POST[rating]!=""){
$sql="SELECT * FROM `rating` where id='$_GET[id]'";
$res=mysql_query($sql);
$row=mysql_fetch_array($res);
$rating="rating_$_POST[rating]";
$row[$rating]++;
$sql="update `downloads` set `$rating`='$row[$rating]' where id='$_GET[id]'";
mysql_query($sql);
}
//--------------------
//Verwerk download id|
//--------------------
if($_GET[id]!=""){
$sql="SELECT * FROM `downloads`where id='$_GET[id]'";
$res=mysql_query($sql);
$count=mysql_num_rows($res);
}
//----------------
//Als id juist is|
//----------------
if($count==1){
$sql="SELECT * FROM `rating` where id='$_GET[id]'";
$res=mysql_query($sql);
$row=mysql_fetch_array($res);
$count=mysql_num_rows($res);
//de rating opvragen:
$rating=($row[rating_1]*1)+($row[rating_2]*2)+($row[rating_3]*3)+($row[rating_4]*4)+($row[rating_5]*5);
$rating_votes=$row[rating_1]+$row[rating_2]+$row[rating_3]+$row[rating_4]+$row[rating_5];
if($rating!=0 && $rating_votes!=0){
$rating=$rating/$rating_votes;}
$rating=round($rating);
if($rating_votes==0){
$rating=3;
}
for($j=0;$j<$rating;$j++){
$rating_stars="$rating_stars<img src=\"gif/star.gif\">";
}
if($_POST[rating]==""){echo "<form action=\"downloads.php?id=$_GET[id]\" method=\"POST\">\n";}
echo "<table width=\"100%\" cellspacing=\"0\" cellpading=\"0\"><tr><td class=\"menu_title\" align=\"center\" colspan=\"2\"><table width=\"100%\"><tr><td width=\"70%\"><a href=\"download.php?id=$_GET[id]\" target=\"_blank\">Starcraft Source $row[naam]</a></td><td align=\"right\">\n";
if($_POST[rating]==""){echo "<select name=\"rating\" size=\"1\">";
echo "<option value=\"1\">1</option>";
echo "<option value=\"2\">2</option>";
echo "<option value=\"3\" selected>3</option>";
echo "<option value=\"4\">4</option>";
echo "<option value=\"5\">5</option>";
echo "</select>";
echo "<input type=\"submit\" value=\"Go!\">";
echo "\n"; }
else{
echo "<b>$rating_stars</b> ($rating_votes Votes)";
}
?>
if($_POST[rating]!=""){
$sql="SELECT * FROM `rating` where id='$_GET[id]'";
$res=mysql_query($sql);
$row=mysql_fetch_array($res);
$rating="rating_$_POST[rating]";
$row[$rating]++;
$sql="update `downloads` set `$rating`='$row[$rating]' where id='$_GET[id]'";
mysql_query($sql);
}
//--------------------
//Verwerk download id|
//--------------------
if($_GET[id]!=""){
$sql="SELECT * FROM `downloads`where id='$_GET[id]'";
$res=mysql_query($sql);
$count=mysql_num_rows($res);
}
//----------------
//Als id juist is|
//----------------
if($count==1){
$sql="SELECT * FROM `rating` where id='$_GET[id]'";
$res=mysql_query($sql);
$row=mysql_fetch_array($res);
$count=mysql_num_rows($res);
//de rating opvragen:
$rating=($row[rating_1]*1)+($row[rating_2]*2)+($row[rating_3]*3)+($row[rating_4]*4)+($row[rating_5]*5);
$rating_votes=$row[rating_1]+$row[rating_2]+$row[rating_3]+$row[rating_4]+$row[rating_5];
if($rating!=0 && $rating_votes!=0){
$rating=$rating/$rating_votes;}
$rating=round($rating);
if($rating_votes==0){
$rating=3;
}
for($j=0;$j<$rating;$j++){
$rating_stars="$rating_stars<img src=\"gif/star.gif\">";
}
if($_POST[rating]==""){echo "<form action=\"downloads.php?id=$_GET[id]\" method=\"POST\">\n";}
echo "<table width=\"100%\" cellspacing=\"0\" cellpading=\"0\"><tr><td class=\"menu_title\" align=\"center\" colspan=\"2\"><table width=\"100%\"><tr><td width=\"70%\"><a href=\"download.php?id=$_GET[id]\" target=\"_blank\">Starcraft Source $row[naam]</a></td><td align=\"right\">\n";
if($_POST[rating]==""){echo "<select name=\"rating\" size=\"1\">";
echo "<option value=\"1\">1</option>";
echo "<option value=\"2\">2</option>";
echo "<option value=\"3\" selected>3</option>";
echo "<option value=\"4\">4</option>";
echo "<option value=\"5\">5</option>";
echo "</select>";
echo "<input type=\"submit\" value=\"Go!\">";
echo "\n"; }
else{
echo "<b>$rating_stars</b> ($rating_votes Votes)";
}
?>
Oke ik geef toe dat het nu op niets trekt lijk ik het post maar met een beetje aanpassingen moet het lukken
Code (php)
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
<?php
$host = "localhost";
$username = "";
$wachtwoord = "";
$database = ""; //
mysql_connect($host, $username, $wachtwoord);
mysql_select_db($database);
?>
$host = "localhost";
$username = "";
$wachtwoord = "";
$database = ""; //
mysql_connect($host, $username, $wachtwoord);
mysql_select_db($database);
?>
Tabel heb'k dus tzelfde gelaten, heb de naam ook downloads.php laten nemen. dus: http://www.fuifen.be/include/script/downloads.php?id=1
id 1 staan wel degelijk in de tabel. Wat zou er mis zijn?