ciao non ne sono certo ma penso cmq usano qualcosa di simile per non farti votare 2 volte la stessa pagina/persona...
per quanto riguarda "le stelline" ti posto il listato che mi ero creato...
questo riguarda la creazione della barra seconda della media ottenuta...
Codice PHP:
<?php
if (($mediapp >= 1) AND ($mediap <= 10)){
echo"
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td bgcolor='#00FF00' width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%' align='right'>Media:</td>
<td width='10%' align='left'>$mediap</td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
</tr>
</table>";
}elseif (($mediap >= 10) AND ($mediap <= 20)){
echo"
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%' align='right'>Media:</td>
<td width='10%' align='left'>$mediap</td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
</tr>
</table>";
}elseif (($mediap >= 20) AND ($mediap <= 30)){
echo"
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td width='10%'></td>
<td width='10%' align='right'>Media:</td>
<td width='10%' align='left'>$mediap</td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
</tr>
</table>";
}elseif (($mediap >= 30) AND ($mediap <= 40)){
echo"
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td width='10%' align='right'>Media:</td>
<td width='10%' align='left'>$mediap</td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
</tr>
</table>";
}elseif (($mediap >= 40) AND ($mediap <= 50)){
echo"
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%' align='right'>Media:</td>
<td width='10%' align='left'>$mediap</td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
</tr>
</table>";
}elseif (($mediap >= 50) AND ($mediap <= 60)){
echo"
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00'width='10%' align='right'>Media:</td>
<td bgcolor='#00FF00' width='10%' align='left'>$mediap</td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
</tr>
</table>";
}elseif (($mediap >= 60) AND ($mediap <= 70)){
echo"
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%' align='right'>Media:</td>
<td bgcolor='#00FF00' width='10%' align='left'>$mediap</td>
<td bgcolor='#00FF00' width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
</tr>
</table>";
}elseif (($mediap >= 70) AND ($mediap <= 80)){
echo"
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%' align='right'>Media:</td>
<td bgcolor='#00FF00' width='10%' align='left'>$mediap</td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td width='10%'></td>
<td width='10%'></td>
</tr>
</table>";
}elseif (($mediap >= 80) AND ($mediap <= 90)){
echo"
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%' align='right'>Media:</td>
<td bgcolor='#00FF00' width='10%' align='left'>$mediap</td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td width='10%'></td>
</tr>
</table>";
}elseif (($mediap >= 90) AND ($mediap <= 100)){
echo"
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%' align='right'>Media:</td>
<td bgcolor='#00FF00' width='10%' align='left'>$mediap</td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
<td bgcolor='#00FF00' width='10%'></td>
</tr>
</table>";
}
?>
Questo invece è lo script che ho fatto per calcolare la media e i numero di votanti, non ho usato la funzione media diretta di mysql perchè al mio amico non piaceva il risultato (4 numeri dopo la virgola, ne voleva al max solo 2)
Codice PHP:
include "config.php";
include "connessione.php";
$votopmedia = $nome.$cognome.$pin."votoprivati";
// conteggio utenti...
$risultato = "SELECT * FROM " . $votopmedia ."";
$dbrisultato = mysql_query($risultato, $db);
$quanti_utenti_privati = mysql_affected_rows($db);
echo "<tr><td align='center'>hanno votato ".$quanti_utenti_privati." utenti<td><tr>";
// Faccio la somma e la divido per gli utenti trovando la media...
$votop = "SELECT SUM(voto_privati) as somma FROM {$votopmedia}";
$result = mysql_query($votop) or die("somma non possibile".mysql_error());
list($somma_privati) = mysql_fetch_array($result);
$mediap = ($somma_privati / $quanti_utenti_privati);
//includo lo script per le tabelle
echo "<tr><td>";
include "tabellemediaprivata.php";
Spero che posso andare anche per te, puoi modificarlo come più ti piace se vuoi... ma la sostanza è questa.. ciao alla prox!