أثناء تصفحى فى منتدى موقع devarticles الشهير.
وجدت شرح لأسكريبت التقييم مثل الموجود فى المقالات فى موقع devarticles
وها هو اليكم:
أولا قاعدة البيانات :
كود PHP:
CREATE TABLE rates (
ID int(5) DEFAULT '0' NOT NULL auto_increment,
FileName varchar(50) NOT NULL,
Num_Votes int(4) NOT NULL,
Votes int(5) NOT NULL,
Rating int(5) NOT NULL,
PRIMARY KEY (ID)
);
ثانيا ملف article.php
كود PHP:
<?
$dbhost = "localhost";
$dbname = "book";
$dbpass = "";
$dbuser = "";
$DBC = @mysql_connect("$dbhost", "$dbuser", "$dbpass");
if (!$DBC) {
echo "ERROR";
exit();
}
# select DB
$DBS = @mysql_select_db("$dbname");
if (!$DBS) {
echo "ERROR";
exit();
} ?>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#EFEFEF" width="100%" id="AutoNumber1" bgcolor="#EFEFEF">
<tr>
<td width="100%">
<?
$result2 = mysql_query("select * from rates");
while ( $row = mysql_fetch_array($result2))
{
$id = $row["id"];
?>
<form method="GET" action=rate.php?id= <? echo $id; ?>>
<p align="center"><?}?>
<span class="blackSmall"><font size="1" face="Tahoma">id =
<input type="text" name="ID" size="2" value="1"><br>
<b>How would you
rate this article: Bad <input type="radio" value="2" name="rValue" checked>
<input type="radio" value="4" name="rValue"> <input type="radio" value="6" name="rValue">
<input type="radio" value="8" name="rValue"> <input type="radio" value="10" name="rValue">
Good </b></font></span></p>
<p align="center">
<input type="submit" value="Rate" name="B1" style="color: #000080; border: 1px groove #000080; background-color: #FFFFCC"></p>
</form>
</td>
</tr>
</table>
</body>
ثالثا ملف rate.php
كود PHP:
<?
$dbhost = "localhost";
$dbname = "book";
$dbpass = "";
$dbuser = "";
$DBC = @mysql_connect("$dbhost", "$dbuser", "$dbpass");
if (!$DBC) {
echo "ERROR";
exit();
}
# SELECT DB
$DBS = @mysql_select_db("$dbname");
if (!$DBS) {
echo "ERROR";
exit();
}
$sql = mysql_query("SELECT * from rates where id=$ID");
while ($row=mysql_fetch_array($sql))
{
$id=$row["id"];
$FileName=$row["FileName"];
$Num_Votes=$row["Num_Votes"];
$Votes =$row["Votes"];
$Rating=$row["Rating"];
$new_Votes=$Num_Votes+1;
$Votes2=$Votes+$rValue;
$Rating=round(($Votes/$new_Votes),2);
$sql2 = mysql_query("UPDATE rates SET Num_Votes=$new_Votes, Votes=$Votes2, Rating=$Rating where id=$ID");
if ($sql2) {
echo "Thank you. The article has rating = $Rating after your vote.";
}
}
?>
وتحياتى لكم بالتوفيق