
ob_start(); 
?>

<?php
include ('conn.php');
$ip = $_SERVER['REMOTE_ADDR'];
//$sql = "delete  from ippoll";
//mysql_query($sql) or die('mislukt; ' . mysql_error());
$sql = "select gemiddelde from ippoll";
$res = mysql_query($sql) or die('mislukt; ' . mysql_error());
$num_rows = mysql_num_rows($res);
$sql2 = "select gemiddelde from ippoll where gemiddelde = '$ip'";
$con = mysql_query($sql2) or die('mislukt; ' . mysql_error());
$controle = mysql_num_rows($con);

if ($controle == 0)
{
print"
<form method='post' action='index.php'> 
Wat vind u van deze site: <select name='optie'>
       <option value='0'>Poll</option>
   <option value='1'>Leuk</option>
  <option value='2'>Gaat wel</option>
   	<option value='3'>Niets aan</option><br>
  <input type='submit' value='Stem'> 
</form> ";

$controle = "select * from poll";  
$controlesql = mysql_query($controle) or die('mislukt; ' . mysql_error());
 $fetch = mysql_fetch_array($controlesql);
$controletabel = $fetch ["0"]; 

if ($fetch  < 1)
{
mysql_query("INSERT INTO poll (optie1,optie2,optie3) values ('0','0','0')");
}

else{
if($_SERVER["REQUEST_METHOD"] == "POST")
{ 
  mysql_query("INSERT INTO ippoll (gemiddelde) values ('$ip')");
$optie  = $_POST['optie'];

if ($optie == 1)
{
$file = "select * from poll";  
$filedel = mysql_query($file) or die('mislukt; ' . mysql_error());
 $gegevens = mysql_fetch_array($filedel);

$array1 = $gegevens ["0"]; 
 $array2 = $gegevens ["1"]; 
   $array3 = $gegevens ["2"]; 

$resultaat = $array1 + 1;

  
  $sql = "delete from poll";
$res = mysql_query($sql) or die('mislukt; ' . mysql_error());
  	
	mysql_query("INSERT INTO poll (optie1,optie2,optie3) values ('$resultaat','$array2','$array3')");
  $stemmen = $array1 + $array2 + $array3;
  $gem1 = round (@($array1 / $stemmen) * 100,1);
  $gem2 = round (@($array2 / $stemmen) * 100,1);
  $gem3 = round  (@($array3 / $stemmen)	 * 100,1);
  
  print "<span class='poll'><br>$gem1% vind dit een mooie site.<br>"; 
   print "$gem2% vind dit een redelijke site.<br>"; 
     print "$gem3% vind dit geen mooie site.</span>"; 
	
	}

elseif ($optie == 2)
{
$file = "select * from poll";  
$filedel = mysql_query($file) or die('mislukt; ' . mysql_error());
 $gegevens = mysql_fetch_array($filedel);

$array1 = $gegevens ["0"]; 
 $array2 = $gegevens ["1"]; 
   $array3 = $gegevens ["2"]; 

$resultaat = $array2+ 1;

 $sql = "delete from poll";
$res = mysql_query($sql) or die('mislukt; ' . mysql_error());
  
  	mysql_query("INSERT INTO poll (optie1,optie2,optie3) values ('$array1','$resultaat','$array3')");
  
  if ($array = 1)
  
  $stemmen = $array1 + $array2 + $array3;
  $gem1 = round (@($array1 / $stemmen) * 100,1);
  $gem2 = round (@($array2 / $stemmen) * 100,1);
  $gem3 = round  (@($array3 / $stemmen)	 * 100,1);

  print "<span class='poll'><br>$gem1% vind dit een mooie site.<br>"; 
   print "$gem2% vind dit een redelijke site.<br>"; 
     print "$gem3% vind dit geen mooie site.</span>"; 
	

}

elseif ($optie == 3)
{

$file = "select * from poll";  
$filedel = mysql_query($file) or die('mislukt; ' . mysql_error());
 $gegevens = mysql_fetch_array($filedel);
$array1 = $gegevens ["0"]; 
 $array2 = $gegevens ["1"]; 
   $array3 = $gegevens ["2"]; 
$resultaat = $array3 + 1;
   
   
   
   
  $stemmen = $array1 + $array2 + $array3;
  $gem1 = round (@($array1 / $stemmen) * 100,0);
  $gem2 = round (@($array2 / $stemmen) * 100,0);
  $gem3 = round  (@($array3 / $stemmen)	 * 100,0);
  
 
  
  
  print "<span class='poll'><br>$gem1% vind dit een mooie site.<br>"; 

   print "$gem2% vind dit een redelijke site.<br>"; 
     print "$gem3% vind dit geen mooie site.</span>"; 
  
  
  $sql = "delete from poll";
$res = mysql_query($sql) or die('mislukt; ' . mysql_error());
  
  	mysql_query("INSERT INTO poll (optie1,optie2,optie3) values ('$array1','$array2','$resultaat')");

	



}
elseif ($optie == 0)
{

Print "ongeldige keuze";



}

}
else
{
print "maak een keuze";

}
}

}
else

{

  print "<span class='poll'><b>U heeft al op deze poll gestemd</b>";
 $file = "select * from poll";  

$filedel = mysql_query($file) or die('mislukt; ' . mysql_error());

 $gegevens = mysql_fetch_array($filedel);

$array1 = $gegevens ["0"]; 
 $array2 = $gegevens ["1"]; 
   $array3 = $gegevens ["2"]; 

$resultaat = $array3 + 1;
 
  
  
  $stemmen = $array1 + $array2 + $array3;

  $gem1 = round (@($array1 / $stemmen) * 100,0);

  $gem2 = round (@($array2 / $stemmen) * 100,0);
    $gem4 = round  (@(($array3 + $array2) / $stemmen)	 * 100,0);
  $gem3 = round  (@($array3 / $stemmen)	 * 100,0);
  
   $balk1 = $gem1 * 2;
     $balk2= $gem2 * 2;
       $balk3= $gem3 * 2;
  print "<br>$gem1% Vind dit een mooie site.<br>"; 
   print "<table cellpadding='0' cellspacing='0'><td width='$balk1' bgcolor='black' height='5'></tr></td></table>";
   print "$gem2% Vind dit een redelijke site.<br>"; 
    print "<table cellpadding='0' cellspacing='0'><td width='$balk2' bgcolor='black' height='5'></tr></td></table>";
     print "$gem3% Vind dit geen mooie site.<br>"; 
       print "<table cellpadding='0' cellspacing='0'><td width='$balk3' bgcolor='black' height='5'></tr></td></table>";
        print "<b>Aantal stemmen: $stemmen </b></span>"; 

}
?>
<?php 
ob_end_flush(); 
?>