Merhaba
hazırlamaya çalıştığım anket de, verilen oyları anket sonuclarına yansıtamadım.. Yardımcı olursanız memnun olurum.
Phpmyadminden baktığımda oylar tablosu artıyor. Fakat sonuc z2.php de
cıkmıyor.. anket3 den bakabilirsiniz...
anket.sql
CREATE TABLE `anket` (
  `anket_id` INT(3) NOT NULL AUTO_INCREMENT,
  `aktif` VARCHAR(1) NOT NULL,
  `soru` VARCHAR(255) NOT NULL,
  `tarih` DATETIME NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin5 AUTO_INCREMENT=1 ;
CREATE TABLE `secenekler` (
  `secenek_id` BIGINT(5) NOT NULL AUTO_INCREMENT,
  `anket_id` INT(3) NOT NULL,
  `secenek` VARCHAR(255) NOT NULL,
  KEY `id` (`id`),
  KEY `anket_id` (`anket_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin5 AUTO_INCREMENT=1 ;
CREATE TABLE `oylar` (
  `oy_id` BIGINT(10) NOT NULL AUTO_INCREMENT,
  `anket_id` INT(3) NOT NULL,
  `secenek_id` BIGINT(5) NOT NULL,
  `oy` BIGINT(5) NOT NULL DEFAULT '0',
  `kullanici_ip` VARCHAR(25) NOT NULL,
  `tarih` DATETIME NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `anket_id` (`anket_id`),
  KEY `secenek_id` (`secenek_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin5 AUTO_INCREMENT=1 ;
index.php
<html><head><title>anket3</title>
<META http-equiv="content-type" content="text/html; charset=ISO-8859-9">
<script>
function z2(ilanid) {
window.open("z2.php?id="+ilanid,"_blank","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=no,copyhistory=no,width=250,height=200,left=5,top=25")
}
</script>
</head>
<body oncontextmenu="return false" style="text-decoration: none;" leftmargin=0 topmargin=0 bgproperties="FIXED">
<center>
<? 
include ("yol.php"); 
$oku = mysql_query("SELECT * FROM anket where aktif='e'"); 
echo '<br>';
$id=$okunan['anket_id'];
while ($okunan = mysql_fetch_array($oku)){ 
$turk_tarih = strftime("%d-%m-%Y", strtotime($okunan['tarih']));
$okus = mysql_query("SELECT * FROM secenekler WHERE anket_id=".$okunan['anket_id']);
?>
<table cellspacing="0" cellpadding="0" align="CENTER" bgcolor="#F0F0F0">
<form action="oyla.php" method="POST">
<tr><td colspan="2" align="CENTER">&nbsp;<?echo $turk_tarih;echo '&nbsp;<br><br>';?></td></tr>
<tr><td colspan="2" bgcolor="#C5D9FA">&nbsp;<?=$okunan[soru]?>&nbsp;</td></tr> 
<?
while ($okunans = mysql_fetch_array($okus)){ 
?>
<tr><td align="CENTER"><?=$okunans['secenek'];?>&nbsp;</td><td><input type="Radio" name="verilenoy" value="$anket_id">&nbsp;</td></tr>
<?
        }
    }
?>
<tr><td colspan="2" align="CENTER" bgcolor="#C5D9FA">
<input type="hidden" name="anket_id" value="$secenek_id">
<!-- <input type="hidden" name="refer" value="<? echo $_SERVER['REMOTE_ADDR']; ?>" />-->
&nbsp;<input type="Submit" value="oyla" align="MIDDLE" style="background-color: #3399ff;">&nbsp;</td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="2" align="CENTER"><a href="javascript:z2(<?=$id;?>)"><font face="Century Gothic" color="Maroon">Sonuc</font></a></td></tr>
</table>
oyla.php
<?
include ("yol.php"); 
$oy = $_POST['verilenoy'];
$kullanici_ip = $_SERVER['REMOTE_ADDR'];
$anket_id= $_POST['anket_id'];
	$update_oylar = "UPDATE oylar SET oy = oy + 1";
	$insert = mysql_query($update_oylar);
	$ekle = mysql_query("INSERT INTO oylar (anketid,oy,kullanici_ip,) values ('$anketid', '$oy', '$kullanici_ip') ");
echo "Oy Kullandiginiz icin, Tesekkur Ederiz..";
?>
<br><br>
<a href="javascript:history.go(-1);">Önceki Sayfa</a>
</center></body></html>
sonuc (z2.php)
<? 
include ("yol.php"); 
$oku = mysql_query("SELECT * FROM anket where aktif='e'");
while ($okunan = mysql_fetch_array($oku)){
	//toplam oy
	$toplamSQL=@mysql_query("select * from oylar where anket_id=".$okunan[0]);
	$toplam=mysql_num_rows($toplamSQL);
	echo $okunan['soru'];
	echo "<br>";
	$secenekSQL=@mysql_query("select * from secenekler where anket_id=".$okunan[0]);
	if(mysql_num_rows($secenekSQL)>0){
		while($secenekSonuc=mysql_fetch_array($secenekSQL)){
			$oylarSQL=mysql_query("select * from oylar where secenek_id=".$secenekSonuc[0]);
			if(!$oylarSQL){
				echo mysql_error();
			}
			$sayi=mysql_num_rows($oylarSQL);
			$yuzde=ceil($sayi*100/$toplam);
			//echo "<br>".$secenekSonuc['secenek']."=".$sayi ." - YÜZDE = ".$yuzde;
			echo "<br>".$secenekSonuc['secenek']."&nbsp;=&nbsp;".$sayi ."&nbsp;&nbsp;&nbsp;%&nbsp;".$yuzde;
		}
	}
	else{
		echo "Seçenek Bulunamadı";
	}
}
echo "<br><br>Toplam Oy : ".$toplam;
ob_end_flush();
?>
</div>
<br>
<a href="javascript:self.close()">Pencereyi Kapat</a>
</center></body></html>