Fetch number of Stars from the sql database and show them in a webpage using php.

Question

Not only the number of starts but also show the designed stars. Exactly like ratings. Anyone ?

Answer 1

Well there’s alot of variations.

$query = $db->query(”SELECT raiting FROM database”)
$row = $query->fetch();
echo $row[”raiting”];
for($a = 0; $a < $row[”raiting”]; $a++) {
echo ”<img src=’star.png’ />;
}

Answer 2

Well, you can create function which will create stars for example:
function showStars($a){
for($i=0; $i<$a; $i++){
echo "<img src='star.png' />";
}
}
And you need to call function during getting rows from database