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);
?>