Herkese selamlar arkadaşlar kolay gelsin
ARKADAŞLAR SORUNU ÇÖZMÜŞ BULUNMAKTAYIM HERKESE TEŞEKKÜRLER
Fatal error: Uncaught Error: Cannot use object of type PDOStatement as array in C:\wamp64\www\dersler\dahil.php on line 157
( ! ) Error: Cannot use object of type PDOStatement as array in C:\wamp64\www\dersler\dahil.php on line 157
<?php
try {
$veritabani = new PDO("mysql:host=localhost;dbname=kisiler;charset=utf8", "root","123456");
$veritabani->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
die($e->getMessege());
}
class anketana {
function giriskontrol($veritabani){
$buton=$_POST["buton"];
$sifre=$_POST["sifre"];
if($buton):
$sorgu="select * from veriler where sifre='$sifre'";
$getir = $veritabani->prepare($sorgu);
$getir->execute();
$tamson=$getir->fetch(PDO::FETCH_ASSOC);
if($tamson["sifre"]==$sifre):
$_SESSION["giris"]=$tamson["sifre"];
echo"giriş başarılı";
header("refresh:3,url=anket.php" );
else:
echo"gecersiz kod";
header("refresh:3,url=index.php" );
endif;
else:
echo"butona basılmadı";
endif;
}
function soruget($veritabani){
$sorgu2="select * from veriler";
$getir2 = $veritabani->prepare($sorgu2);
$getir2->execute();
$tamson2=$getir2->fetch(PDO::FETCH_ASSOC);
$anketid=$tamson2["id"];
$ip=$_SERVER['REMOTE_ADDR'];
$sorgu3="select * from ipkontrol where anketid='$anketid' and ip='$ip' ";
$getir3 = $veritabani->prepare($sorgu3);
$getir3->execute();
if($getir3->rowCount()==0):
echo'
<form action="anket.php?aksiyon=oyver" method="post" >
<div class="row">
<div class="col-md-12">Soru'.$tamson2["soru"].' <hr /></div>
<div class="col-md-12">'.$tamson2["sec1"].'<input type="radio" name="oy" value="sec1" /> </div>
<div class="col-md-12">'.$tamson2["sec2"].'<input type="radio" name="oy" value="sec2" /> </div>
<div class="col-md-12">'.$tamson2["sec3"].' <input type="radio" name="oy" value="sec3" /> </div>
<div class="col-md-12">'.$tamson2["sec4"].' <input type="radio" name="oy" value="sec4" /> </div>
<input type="submit" name="oyver" value="BUTON" class="btn btn-success" />
<input type="hidden" name="anketid" value="'.$tamson2["id"].'" />
</div>
</div>
</form>
';
else:
$toplamoy=$tamson2["oy1"] + $tamson2["oy2"] + $tamson2["oy3"] + $tamson2["oy4"];
$secenek1= ($tamson2["oy1"] / $toplamoy) * 100;
$secenek2= ($tamson2["oy2"] / $toplamoy) * 100;
$secenek3= ($tamson2["oy3"] / $toplamoy) * 100;
$secenek4= ($tamson2["oy4"] / $toplamoy) * 100;
echo '<div class="row">
<div class="col-md-12" Sonuclar <hr /></div>
<div class="col-md-12">'.$secenek1.' </div>
<div class="col-md-12"> '.$secenek2.'</div>
<div class="col-md-12"> '.$secenek3.'</div>
<div class="col-md-12">'.$secenek4.' </div>
<div class="col-md-12" '.$toplamoy.'toplam oy <hr /></div>
</div>';
endif;
}
function oyver($veritabani) {
$buton=$_POST["oyver"];
$oy=$_POST["oy"];
$anketid=$_POST["anketid"];
if($buton):
switch($oy):
case"sec1";
$sutun="oy1";
$veri=1;
case"sec2";
$sutun="oy2";
$veri=1;
case"sec3";
$sutun="oy3";
$veri=1;
case"sec4";
$sutun="oy4";
$veri=1;
default:
endswitch;
$sorgu4="select * from oylama where anketid='$anketid'";
$getir4 = $veritabani->prepare($sorgu4);
$getir4->execute();
if($getir4->rowCount()==0):
$sorgu5="insert into oylama (anketid,$sutun) VALUES ($anketid,$veri)";
$getir5 = $veritabani->prepare($sorgu5);
$getir5->execute();
$ip=$_SERVER['REMOTE_ADDR'];
$sorgu6="insert into ipkontrol (anketid,ip) VALUES ($anketid,$ip)";
$getir6 = $veritabani->prepare($sorgu6);
$getir6->execute();
echo"OYUNUZ ALINDI";
header("refresh:3,url=index.php" );
else:
$mevcutdeger= $getir4[$sutun];
$sonveri=$mevcutdeger + 1;
$sorgu8="update oylama set $sutun=$sonveri where anketid=$anketid";
$getir8 = $veritabani->prepare($sorgu8);
$getir8->execute();
$ip=$_SERVER['REMOTE_ADDR'];
$sorgu7="insert into ipkontrol (anketid,ip) VALUES ($anketid,$ip)";
$getir7 = $veritabani->prepare($sorgu7);
$getir7->execute();
echo"OYUNUZ ALINDI";
header("refresh:3,url=index.php");
endif;
else:
echo"butona basılmadı";
endif;
}
}
?>