prepare("SELECT program_id,anket_soru,anket_id,anket_tarih,aktif FROM anketler WHERE anket_id='$anket_id'" ); $sql_anket->execute(); if ($sql_anket->rowCount()>0) { foreach ($sql_anket as $yazdir){ $anket_soru=$yazdir['anket_soru']; $program_turu=$yazdir['program_id']; }}} //-------------------------------- $sql=null; ?> Survey Center query("SELECT anket_soru,anket_id,anket_tarih,aktif FROM anketler order by anket_tarih desc",pdo::FETCH_ASSOC); } else{ $sql_anket = $db_kayitlar->query("SELECT anket_soru,anket_id,anket_tarih,aktif FROM anketler WHERE anket_id='$anket_id'",pdo::FETCH_ASSOC); } if($sql_anket->rowCount()==0){ echo "

Anket bulunamadı(!)

"; } else { foreach($sql_anket as $yazdir){ $anket_id = $yazdir['anket_id']; $anket_soru = $yazdir['anket_soru']; $anket_tarih = $yazdir['anket_tarih']; $anket_durum = $yazdir['aktif']; } } $sql_anke=null; //setcookie("bayiranket", $anket_id, time()+3600); If ($_COOKIE['bayiranket']==$anket_id){ $OyDurum = "False"; } else{ $SecID = $_POST['sec_id']; If (strlen($SecID) > 0 and is_numeric($SecID)==True){ $sql_anket_guncelle=$db_kayitlar->exec("UPDATE secenekler SET sec_sayac = sec_sayac + 1 WHERE sec_id='$SecID'"); $sql_anket_guncelle=null; setcookie("bayiranket", $anket_id, time()+3600); $OyDurum = "False"; } Else{ $OyDurum = "True"; }} $sql_SecenekSay = $db_kayitlar->query("select Sum(sec_sayac) from secenekler where anket_id='$anket_id'",pdo::FETCH_ASSOC); $row = $sql_SecenekSay->fetch(PDO::FETCH_NUM); //$row = mysql_fetch_array($sql_SecenekSay); $Total= $row[0]; $sql_secenekler = $db_kayitlar->query("SELECT * FROM secenekler WHERE anket_id ='$anket_id' order by sirasi asc",pdo::FETCH_ASSOC); ?>