<?php



try  {
	$baglan = new PDO("mysql:host=localhost;dbname=quiz;charset=utf8", "root","123456");
	$baglan->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	
	
} catch (PDOException $e) {
	die($e->getMessege());
}



function sorulargetir ($baglan){
?>
<h4>QUİZ</h4>

	<form action="index.php?islem=sonuc" method="post">
	<?php
	$so="select * from sorular";
	$sonuc=$baglan->prepare($so);
	$sonuc->execute();
	while ($son=$sonuc->fetch(PDO::FETCH_ASSOC)):
	?>
	<div class="row" id="renk" style="margin-bottom:0px;">
	<div class="col-sm-12 " id="pad"> <?php echo $son["soru"]; ?> </div>
	
	</div>
    <div class="row" id="renk" style="margin-bottom:0px;">  
    <div class="col-sm-6" id="pad"> <input name="cevap<?php echo $son["id"]; ?>" type="radio" value="<?php echo $son["cevap1"]; ?>" /> <?php echo $son["cevap1"]; ?></div>
     <div class="col-sm-6" id="pad"> <input name="cevap<?php echo $son["id"]; ?>" type="radio" value="<?php echo $son["cevap2"]; ?>" /> <?php echo $son["cevap2"]; ?></div>
      <div class="col-sm-6" id="pad"> <input name="cevap<?php echo $son["id"]; ?>" type="radio" value="<?php echo $son["cevap3"]; ?>" /> <?php echo $son["cevap3"]; ?></div>
       <div class="col-sm-6" id="pad"> <input name="cevap<?php echo $son["id"]; ?>" type="radio" value="<?php echo $son["cevap4"]; ?>" /> <?php echo $son["cevap4"]; ?></div>
       <input type="hidden" name="id<?php echo $son["id"]; ?>" value=""<?php echo $son["id"]; ?>"
   
   
    
    
    
    
    </div>
	
	
	
	<?php endwhile; ?>
    <input name="buton" type="submit" value="Cevapla" class="btn btn-success" />
    </form>
    <?php
	
	
	
	
	
	}
function sonuc ($baglan){
	
	$buton=$_POST["buton"];
	if($buton):
	$so="select * from sorular";
	$sonuc=$baglan->prepare($so);
	$sonuc->execute();
	
	$hata=0;
		while($son=$sonuc->fetch(PDO::FETCH_ASSOC)):
		
		$gelenid=@$_POST["id".$son["id"]];
		$gelencevap=@$_POST["cevap".$son["id"]];
		
		$ve="select * from sorular where id=$gelenid";
		$dsonuc=$baglan->prepare($ve);
		$dsonuc->execute();
		$bson=$dsonuc->fetch(PDO::FETCH_ASSOC);
		
		
			if($bson["dc"]==$gelencevap):
			
			else:
			++$hata;
			echo'<div class="row" id="renk">
			<div class="col-sm-6"> Soru no : '.$bson["id"].'</div>
			<div class="col-sm-6"> Verdiğin Cevap  : '.$gelencevap.'</div>
			div class="col-sm-6"> Doğru Cevap  : '.$bson["dc"].'</div>
			
			</div>
			';
			endif;
			
		endwhile;
			if ($hata==0):
			$dcs=$tsayi - $hata;
			
			echo'<div class="row" id="renk">
			<div class="col-sm-12"> Sana Helal Olsun Tebrikler </div>
		
			</div>
			';
			else:
			'<div class="row" id="renk">
			<div class="col-sm-6"> hatalı cevap sayısı '.$hata.' </div>
			
			<div class="col-sm-6"> Doğru cevap sayısı  '.$dcs.' </div>
		
			</div>
			';
			endif;
	else:
	echo "hata var ";	
	
	endif;
	
	
	
	
	}


?>