// Variables
$notemoyenne = "";
$notelibelle = "";
$notepourcentage = "";
$notepourcentageurl = "";
$nbavis = 0;
$nbavistotal = 0;
$erreur ="";
$nbmoyenne =0;
// CALCUL DE LA NOTE
$req = "SELECT AVG(note) as notemoyenne, COUNT(idavis) as nbavis FROM avis WHERE enligne ='oui' ";
//echo "req=*".$req."*
";
$recordsmoyenne = mysqli_query($lienbase,$req);
if(!empty($recordsmoyenne)) $nbmoyenne = mysqli_num_rows($recordsmoyenne);
//echo "nbmoyenne=*".$nbmoyenne."*
";
if ($nbmoyenne >= 0) {
$champs = mysqli_fetch_array($recordsmoyenne, MYSQLI_ASSOC);
// NB AVIS
$nbavistotal = $champs["nbavis"];
// NOTE MOYENNE
$notemoyenne = round($champs["notemoyenne"],1);
// NOTE POURCENTAGE
$notepourcentage = round(($notemoyenne*100)/5);
$notepourcentageurl = $notepourcentage;
$notepourcentage = $notepourcentage."%";
// NOTE LIBELLE
if ($notemoyenne<=3.5) {
$notelibelle = "Bon";
}
elseif ($notemoyenne<=4) {
$notelibelle = "Trés bon";
}
elseif ($notemoyenne<=5) {
$notelibelle = "Excellent";
}
}
?>