Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //field value bertambah 1, setiap kali voting dilakukan dengan sesuai dengan kriteria yang di pilih
- $qr=@mysql_query("update vooting set value = value + 1 where kriteriaId = '$_POST[pilihan]'", $conn) or die ("kriteria Vooting salah");
- //Perhitungan Prosentase dari total kriteria
- $qr=@mysql_query("Select sum(value) as TotalPersentase from vooting", $conn) or die ("Query tidak bisa dilakukan");
- $row= mysql_fetch_array($qr);
- $total=$row[TotalPersentase];
- $qr=@mysql_query("Select Max(value) as NilaiMax From Vooting", conn) or die ("Query tidak bisa dilakukan karena ada kesalahan");
- $row=mysql_fetch_array($qr);
- $pengali=100/$row[NilaiMax];
- //Menampilkan data yang di urutkan berdasarkan kriteria
- $qr=mysql_query("Select kriteria, value from vooting order by kriteria", conn) or die("Query tidak bisa di lakukan karena ada kesalahan");
- while ($row = mysql_fetch_array($qr))
- {
- $persen=round($row[value]*pengali,0);
- $valPersen=round($row[value]/$total*100,2);
- //untuk mencetak hasil na
- echo "<tr>
- <td width=25% height=22>$row[kriteria]</td>
- <td width=75% height=18>";
- echo "<table border=1 cellpadding=0 cellspacing=0 style='border-collapse:collapse'
- width=$persen% height=18>";
- echo "<tr><td width=100% bgcolor=#CCFF66 align=center>$valpersen%</td>";
- echo "</tr></table></td></tr>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement