Membuat Poling Dinamis Dengan PHP

sql tabel_pertanyaan


   --
   -- Table structure for table `polling_pertanyaan`
   --
 
   CREATE TABLE `polling_pertanyaan` (
     `idtanya` int(5) NOT NULL auto_increment,
     `pertanyaan` tinytext NOT NULL,
     `tanggal` date NOT NULL,
     PRIMARY KEY  (`idtanya`)
   );
 
   CREATE TABLE `polling_jawaban` (
     `nomor` int(5) NOT NULL auto_increment,
     `idtanya` int(5) NOT NULL,
     `jawaban` tinytext NOT NULL,
     `jumlah` int(5) NOT NULL,
     PRIMARY KEY  (`nomor`)
   );

polling.html


   <script>
function proses(){
    var teks = "";
    j = document.getElementById("jumlah").selectedIndex;
    for(i=1;i<=j;i++){
        teks = teks + "Option " + i + " <input type=text name=jawaban[] size=50><br>";
    }
    document.getElementById("opt").innerHTML = teks;
}
</script>
 
<form method="POST" action="inputpolling.php">
  Pertanyaan Polling :<br>
  <textarea rows="3" name="tanya" cols="36"></textarea><p>
  <p>Jumlah Jawaban : <select size="1" name="jumlah" id=jumlah onchange=proses()>
  <option>0</option>
  <option>1</option>
  <option>2</option>
  <option>3</option>
  <option>4</option>
  <option>5</option>
  <option>6</option>
  <option>7</option>
  <option>8</option>
  <option>9</option>
  </select></p>
  <div id=opt></div>
  <p><input type="submit" value="Submit"></p>
</form>

inputpolling.php


<?php
mysql_connect("localhost","root","");
mysql_select_db("test");
 
$tanya = $_POST['tanya'];
$tny = mysql_query("INSERT INTO polling_pertanyaan VALUES(null,'$tanya',NOW())");
 
$pertanyaan = mysql_query("SELECT idtanya FROM polling_pertanyaan ORDER BY idtanya DESC LIMIT 1");
$t = mysql_fetch_array($pertanyaan);
$idtanya = $t['idtanya'];
 
foreach($_POST['jawaban'] as $value){
    $masuk = mysql_query("INSERT INTO polling_jawaban VALUES(null,$idtanya,'$value',0)");
}
 
if($masuk){
    echo "<a href=lihatpolling.php>Lihat Polling</a>";
}else{
    echo "gagal";
}
?>

lihatpolling.php


<?php
mysql_connect("localhost","root","");
mysql_select_db("test");
?>
<html>
<head>
<title>Polling Management</title>
<style>
td.poll{background-color:#efefef;font-family:arial;font-size:10pt}
</style>
</head>
<body>
<form action=hitungpolling.php method=post>
<table border=0 width=250 cellpadding=4 cellspacing=3>
<?php
$arsip = 0;
if(isset($_GET['no'])){
    $arsip = 1;
    //jika ini adalah arsip, maka idtanya kita ambil nilainya dari variabel $_GET['no']
    $idtanya = $_GET['no'];
    $polling = mysql_query("SELECT * FROM polling_pertanyaan WHERE idtanya=$idtanya");
    while($p = mysql_fetch_array($polling)){
        echo "<tr><td colspan=2 class=poll>".$p['pertanyaan']."</td></tr>";
    }
}else{
    //jika bukan menampilkan arsip, idtanya kita ambil yang terakhir
    $polling = mysql_query("SELECT * FROM polling_pertanyaan ORDER BY idtanya DESC LIMIT 1");
    while($p = mysql_fetch_array($polling)){
        echo "<tr><td colspan=2 class=poll>".$p['pertanyaan']."</td></tr>";
        $idtanya = $p['idtanya'];
    }
}
 
$jawaban = mysql_query("SELECT * FROM polling_jawaban WHERE idtanya=$idtanya");
while($j = mysql_fetch_array($jawaban)){
    $jawab[] = $j['jawaban'];
    $nomor[] = $j['nomor'];
    $jumlah[] = $j['jumlah'];
    $total = $total + $j['jumlah'];
}
 
for($i=0;$i<count($nomor);$i++){
    if($jumlah[$i]>0){
        $persen = sprintf("%01.1f",($jumlah[$i]/$total)*100);
    }else{
        $persen = 0;
    }
    if($arsip==1){//kalau hanya menampilkan arsip polling sebelumnya tidak ada radio button
        echo "<tr><td class=poll>";
    }else{
        echo "<tr><td class=poll><input type=radio name=jwb value=".$nomor[$i].">";
    }
    echo $jawab[$i]."</td><td class=poll>".$jumlah[$i]." ($persen%)</td></tr>";
}
echo "<tr><td class=poll>TOTAL</td><td class=poll>$total</td></tr></table>";
if($arsip==0){
    echo "<input type=submit value=Pilih></form>";
}
?>
<h4>Arsip Polling Sebelumnya</h4>
<ul>
<?php
$pol = mysql_query("SELECT * FROM polling_pertanyaan ORDER BY idtanya DESC LIMIT 1");
$po = mysql_fetch_array($pol);
$idakhir = $po['idtanya'];
echo "<li><a href=lihatpolling.php>".$po['pertanyaan']."</a>";
$pertanyaan = mysql_query("SELECT * FROM polling_pertanyaan WHERE idtanya < $idakhir ORDER BY idtanya DESC");
while($a = mysql_fetch_array($pertanyaan)){
    echo "<li><a href=lihatpolling.php?no=".$a['idtanya'].">".$a['pertanyaan']."</a>";
}
?>
</ul>
</body>
</html>

hitungpolling.php


<?php
mysql_connect("localhost","root","");
mysql_select_db("test");
$jwb = $_POST['jwb'];
$masuk = mysql_query("UPDATE polling_jawaban SET jumlah=jumlah+1 WHERE nomor=$jwb");
if($masuk){
    header("location:lihatpolling.php");
}else{
    echo "Gagal";
}
?>

Download Now Preview

Terima Kasih Sobat Sudah:

1. Berkomentar Dengan Sopan
2. Tidak Memasukkan Link Aktif Dalam Form Komentar
3. Berkomentar Sesuai Artikel/Postingan
4. Berilah Informasi Kepada Admin Jika ada script yang Sudah tidak berfungsi
5. komentar Jorok/kasar /berbau Sara/Porno /saya anggap sebagai SPAM
6. Tidak Mengcopy paste artikel ini ( Ingat Bahaya Copy paste )

Membuat Poling Dinamis Dengan PHP

Total Tayangan Halaman

Postingan Populer