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;
		
			
		}
		
		


	
}


?>