 |
| Membuat Voting atau Polling dengan PHP |
Buatlah database dengan nama voting, berikut struktur databasenya:
body {
margin:0;
background-color:#fff;
}
#sidebar{
background-color:#f3f1e7;
margin-left:30%;
margin-right:30%;
margin-top:5%;
border-radius:5px;
box-shadow:5px 0px 5px #999;
border-color:#C4E0AF;
border-style:solid;
border-width:thin;
}
#sidebar .body {
margin: 20px 5px 20px 5px;
}
#sidebar .judul {
margin:-13px auto 0;
width:98%;
height:35px;
background-color:#96b74b;
background-repeat:repeat-x;
border-radius:5px;
}
#sidebar .judul h4{
color:#ffffff;
text-shadow:0px 0px 5px #666666;
padding-left:10px;
padding-top:5px;
}
#sidebar li{
list-style-type:none;
display:block;
padding-top:8px;
padding-bottom:8px;
margin-left:-40px;
border-bottom:1px solid;
border-color:#C4E0AF;
}
#sidebar li a{
color:#2e776a;
text-decoration:none;
padding-left:5px;
}
#sidebar li:hover{
color:#ffffff;
background-color:#b2df8e;
padding-left:-80px;
}
<?php
include "koneksi.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, minimum-scale=1.0, maximum-scale=1.0"/>
<title>Demo Voting - Masholeh</title>
<link href="style.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
function voting(){
alert('Terima Kasih Anda telah mengikuti Voting');
return false;
}
</script>
</head>
<body>
<div id="isi">
<div id="sidebar"><div class="judul"><h4>Tentukan Pilihan Anda</h4></div>
<div class="body">
<font size="3" color="#2e776a" face="verdana"><b>Apakah Tutorial WWW.BLOG.MASHOLEH.WEB.ID Bermanfaat Bagi Anda?</b><br></font>
<form method="post" action="voting.php">
<font size="2" color="#2e776a" face="verdana">
<table>
<tr><td width="20"><input type="Radio" name="polling" value="sangat" checked></td>
<td>Sangat Bermanfaat</td></tr>
<tr><td width="20"><input type="Radio" name="polling" value="bermanfaat"></td>
<td>Bermanfaat</td></tr>
<tr><td width="20"><input type="Radio" name="polling" value="biasa"></td>
<td>Biasa Saja</td></tr>
<tr><td width="20"><input type="Radio" name="polling" value="tidak"></td>
<td>Tidak Bermanfaat</td></tr>
<tr><td width="20"><input type="Radio" name="polling" value="sangattidak"></td>
<td>Sangat Tidak Bermanfaat</td></tr>
<tr><td width="20"></td><td><input type="submit" name="polling2" value="Vote" onClick="voting();"></tr>
</table>
</font>
</form>
</div>
</div>
</div>
</body>
</html>
<?
if (isset($_POST['polling']))
{
include "koneksi.php";
$pilihan=$_POST['polling'];
$tanggal;
$polling=mysql_db_query($db,"select * from voting",$koneksi);
$baris=mysql_fetch_row($polling);
list($sangat,$bermanfaat,$biasa,$tidak,$sangattidak)=$baris;
$array1=$sangat+1;
$array2=$bermanfaat+1;
$array3=$biasa+1;
$array4=$tidak+1;
$array5=$sangattidak+1;
switch($pilihan)
{
case "sangat";
echo "<br>";
$update=mysql_db_query($db,"update voting set sangat='$array1', tanggal='$tanggal'",$koneksi);
echo "<script> document.location.href='view-voting.php'; </script>";
break;
case "bermanfaat";
echo "<br>";
$update=mysql_db_query($db,"update voting set bermanfaat='$array2', tanggal='$tanggal'",$koneksi);
echo "<script> document.location.href='view-voting.php'; </script>";
break;
case "biasa";
echo "<br>";
$update=mysql_db_query($db,"update voting set biasa='$array3', tanggal='$tanggal'",$koneksi);
echo "<script> document.location.href='view-voting.php'; </script>";
break;
case "tidak";
echo "<br>";
$update=mysql_db_query($db,"update voting set tidak='$array4', tanggal='$tanggal'",$koneksi);
echo "<script> document.location.href='view-voting.php'; </script>";
break;
case "sangattidak";
echo "<br>";
$update=mysql_db_query($db,"update voting set sangattidak='$array5', tanggal='$tanggal'",$koneksi);
echo "<script> document.location.href='view-voting.php'; </script>";
break;
}
}
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, minimum-scale=1.0, maximum-scale=1.0"/>
<title>Demo Voting - Masholeh</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<?
include "inc/koneksi.php";
$hasil=mysql_db_query($db,"select * from voting",$koneksi);
$row=mysql_fetch_row($hasil);
list($sangat,$bermanfaat,$biasa,$tidak,$sangattidak,$megah,$masih)=$row;
$total=(int)$sangat+(int)$bermanfaat+(int)$biasa+(int)$tidak+(int)$sangattidak;
//menampilkan persentase
$persen_sangat =round(((int)$sangat/(int)$total)*100,2);
$persen_bermanfaat =round(((int)$bermanfaat/(int)$total)*100,2);
$persen_biasa =round(((int)$biasa/(int)$total)*100,2);
$persen_tidak =round(((int)$tidak/(int)$total)*100,2);
$persen_sangattidak =round(((int)$sangattidak/(int)$total)*100,2);
$persen_megah =round(((int)$megah/(int)$total)*100,2);
$persen_masih =round(((int)$masih/(int)$total)*100,2);
//mengkonversi persentasi menjadi ukuran pada diagram batang dengan mengalikan faktor 2, karena jika 100% artinya lebar maksimum digram adalah 100pt
$lebar_sangat=$persen_sangat*2;
$lebar_bermanfaat=$persen_bermanfaat*2;
$lebar_biasa=$persen_biasa*2;
$lebar_tidak=$persen_tidak*2;
$lebar_sangattidak=$persen_sangattidak*2;
?>
<div id="sidebar"><div class="judul"><h4>Hasil Voting</h4></div>
<br/>
<center><b>Apakah Tutorial WWW.BLOG.MASHOLEH.WEB.ID Bermanfaat Bagi Anda?</b></center><br/>
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td><table border="0" width="100%">
<tr>
<td width="30%" align="left"><font size="2" face="verdana">Sangat Bermanfaat</font></td>
<td width="5%" align="right"><font size="2" face="verdana"><? echo $sangat;?></font></td>
<td width="1%"> </td>
<td width="20%" align="left"><img src="images/stat.jpg" border="1" width="<? echo $lebar_sangat ?>" height="12"> <font size="2" face="verdana">
<? echo $persen_sangat."%"; ?></font></td>
</tr>
<tr>
<td align="left"><font size="2" face="verdana">Bermanfaat</font></td>
<td align="right"><font size="2" face="verdana"><? echo $bermanfaat;?></font></td>
<td> </td>
<td align="left"><img src="images/stat.jpg" border="1" width="<? echo $lebar_bermanfaat ?>" height="12"> <font size="2" face="verdana">
<? echo $persen_bermanfaat."%";?></font> </td>
</tr>
<tr>
<td align="left"><font size="2" face="verdana">Biasa Saja</font></td>
<td align="right"><font size="2" face="verdana"><? echo $biasa;?></font></td>
<td> </td>
<td align="left"><img src="images/stat.jpg" border="1" width="<? echo $lebar_biasa ?>" height="12"> <font size="2" face="verdana">
<? echo $persen_biasa."%";?></font></td>
</tr>
<tr>
<td align="left"><font size="2" face="verdana">Tidak Bermanfaat</font></td>
<td align="right"><font size="2" face="verdana"><? echo $tidak;?></font></td>
<td> </td>
<td align="left"><img src="images/stat.jpg" border="1" width="<? echo $lebar_tidak ?>" height="12"> <font size="2" face="verdana">
<? echo $persen_tidak."%"; ?></font></td>
</tr>
<tr>
<td align="left"><font size="2" face="verdana">Sangat Tidak Bermanfaat</font></td>
<td align="right"><font size="2" face="verdana"><? echo $sangattidak;?></font></td>
<td> </td>
<td align="left"><img src="images/stat.jpg" border="1" width="<? echo $lebar_sangattidak ?>" height="12"> <font size="2" face="verdana">
<? echo $persen_sangattidak."%";?></font> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center"><p><font face="verdana" size="2" color="#666666"><? echo 'Total Voting : ',$total; ?></font></p></td>
</tr>
</table>
<a href="index.php">Back To Home</a>
</div>
<?php
ini_set('display_errors',FALSE);
$server="localhost";
$user_db="root";
$pass_db="";
$db="voting";
$koneksi=mysql_connect($server,$user_db,$pass_db) or die("Gagal Koneksi DB!");
mysql_select_db($db) or die ("DB tidak ada!");
$tanggal=date("Y-m-d");
?>
Sekian dari saya, banyak lebihnya Terimakasih !!!
Contoh tabelny bagaimana ya bang?
BalasHapus