Kullanıcıların anket yapabilmesini sağlayabilirmisiniz?

CREATE DATABASE anket

CREATE TABLE anket (
no int(10) unsigned NOT NULL auto_increment,
soru varchar(255) NOT NULL default '',
secenek_1 varchar(50) NOT NULL default '',
alan_1 varchar(6) NOT NULL default '0',
secenek_2 varchar(50) NOT NULL default '',
alan_2 varchar(6) NOT NULL default '0',
secenek_3 varchar(50) NOT NULL default '',
alan_3 varchar(6) NOT NULL default '0',
secenek_4 varchar(50) NOT NULL default '',
alan_4 varchar(6) NOT NULL default '0',
KEY no (no)
)

<?
include "config.php";
bas();
switch ("$git") {
case "01";
if( empty($soru) ) {
echo "Form alanını eksik doldurdunuz\n";
exit();
}
echo "Anket sorusu: $soru\n";
echo "<form action=\"$PHP_SELF?git=02\" method=\"post\">\n";
echo "<table width=\"50%\" border=\"0\">
<tr>
<td>No: </td>
<td>Seçenek </td>
<td>Oy sayısı</td>
</tr>";
for ( $i=0; $i < 4; $i++ ) {
$no=$i+1;
echo "
<tr>
<td>$no</td>
<td><input type='text' name='alan_$no'></td>
<td><input type='text' name='oy_$no' maxlength=\"3\" size=\"4\" value=1></td>
</tr>";
}
echo "<tr>
<td>
<input type=\"hidden\" name=\"soru\" value=\"$soru\">
</td>
<td><input type=\"submit\" value=\"Tamam\"></td>
</tr>
</table>
</form>";
son();

break;
case "02";

if ( empty($soru) || empty($alan_1) || empty($alan_2) || empty($alan_3) || empty($alan_4) ) {
echo "Formu eksik doldurdunuz--$soru";
exit();
}
$veri = "INSERT INTO anket (soru, secenek_1, secenek_2, secenek_3, secenek_4, alan_1, alan_2, alan_3,alan_4)
VALUES ('$soru','$alan_1','$alan_2','$alan_3','$alan_4','$oy_1','$oy_2','$oy_3','$oy_4')";

if ( mysql_query($veri) ) {
$sira = mysql_num_rows(mysql_query("select * from anket") );
echo "Anket yapıldı.Anketi görmek için <a href='anket.php?git=$sira'>tıklayın[/url]";
} else {
echo "Bir hata oldu.Anket oluşturulamadı";
}

son();

break;
default:
?>
<form method="post" action="<? echo $PHP_SELF; ?>?git=01">
<table width="50%" border="0">
<tr>
<td>Anket Sorusu</td>
<td><input type="text" name="soru">
</td>
</tr>
<tr>
<td> </td>
<td><input type="submit" value="İleri"></td>
</tr>
</table>
</form>

<?
son();
}
?>

<?
mysql_connect("localhost","root") || die ("HATA 1");
mysql_select_db("anket") || die ("HATA 2");

function bas () {
echo "
<html>
<head>
<title>::::ANKET:::::</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-9\">
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1254\">
</head>
<body>
";
}

function son() {
echo "
</body>
</html>
";
}

?>

<?php
if ( $HTTP_COOKIE_VARS["anket_$git"]=="oy_$git" ) :
include "config.php";
$tablo = "SELECT * FROM anket WHERE no='$git'";
$sorgu = mysql_query($tablo);
if ( mysql_num_rows($sorgu) < 1 ) {
echo "Belirtilen numaralı bir anketimiz yok";
exit();
}
$toplam = "SELECT alan_1+alan_2+alan_3+alan_4 AS toplam FROM anket WHERE no='$git'";
$sor = mysql_query($toplam);
$toplam_sayi = @mysql_result($sor,0,"toplam");
$oku = array (
1=> @mysql_result($sorgu,0,"alan_1"),
2=> @mysql_result($sorgu,0,"alan_2"),
3=> @mysql_result($sorgu,0,"alan_3"),
4=> @mysql_result($sorgu,0,"alan_4"),
5=> @mysql_result($sorgu,0,"soru"),
6=> @mysql_result($sorgu,0,"secenek_1"),
7=> @mysql_result($sorgu,0,"secenek_2"),
8=> @mysql_result($sorgu,0,"secenek_3"),
9=> @mysql_result($sorgu,0,"secenek_4"),
10> @mysql_result($sorgu,0,"no")
);
bas();
echo "
<table align='center' border='0' bgcolor='yellow'>
<tr>
<td></td>
<td>$oku[5]</td>
</tr>";
for ( $a=1; $a <= 4; $a++) {
$ortalama[$a] = round($oku[$a]*100/$toplam_sayi);
$yuzde[$a] = floor($ortalama[$a]);
$b[$a] = $yuzde[$a];
$c = $a+5;
echo "<tr>
<td>$oku[$c]</td>
<td><img src='resim.gif' height='15' width='$b[$a]'></td>
</tr>
";
}
echo "</table>";
son();
else:
include("anket2.php");
endif;
?>

<?

if ( $HTTP_COOKIE_VARS["anket_$git"] == "oy_$git" ) :
header ("Location: anket.php?git=$git");
exit();
endif;
include "config.php";
$tablo = "SELECT * FROM anket WHERE no='$git'";
$sorgu = mysql_query($tablo);
if ( mysql_num_rows($sorgu) < 1 ) {
echo "Belirtilen numaralı bir anketimiz yok";
exit();
}
$toplam = "SELECT alan_1+alan_2+alan_3+alan_4 AS toplam FROM anket WHERE no='$git'";
$sor = mysql_query($toplam);
$toplam_sayi = @mysql_result($sor,0,"toplam");
$oku = array (
1=> @mysql_result($sorgu,0,"alan_1"),
2=> @mysql_result($sorgu,0,"alan_2"),
3=> @mysql_result($sorgu,0,"alan_3"),
4=> @mysql_result($sorgu,0,"alan_4"),
5=> @mysql_result($sorgu,0,"soru"),
6=> @mysql_result($sorgu,0,"secenek_1"),
7=> @mysql_result($sorgu,0,"secenek_2"),
8=> @mysql_result($sorgu,0,"secenek_3"),
9=> @mysql_result($sorgu,0,"secenek_4"),
10> @mysql_result($sorgu,0,"no")
);

bas();
?>

<form method="post" action="oyla.php?git=<? echo $git; ?>">
<table width="30%" border="0" align="center" bgcolor="#99CCFF">
<tr>
<td></td>
<td><? echo $oku[5]; ?></td>
</tr>
<tr>
<td width="15%">
<input type="radio" name="oy" value="1">
</td>
<td width="85%"><? echo $oku[6]; ?></td>
</tr>
<tr>
<td width="15%">
<input type="radio" name="oy" value="2">
</td>
<td width="85%"><? echo $oku[7]; ?></td>
</tr>
<tr>
<td width="15%">
<input type="radio" name="oy" value="3">
</td>
<td width="85%"><? echo $oku[8]; ?></td>
</tr>
<tr>
<td width="15%">
<input type="radio" name="oy" value="4">
</td>
<td width="85%"><? echo $oku[9]; ?></td>
</tr>
<tr>
<td width="15%"> </td>
<td width="85%">
<input type="submit" name="Submit" value="Oyla">
</td>
</tr>
</table>
</form>
<? son(); ?>

<?
include "config.php";
if ( empty($git) && ($oy=="1" ) ) {
echo "Anketi seçiniz";
} else {

$tablo = "SELECT * FROM anket WHERE no='$git'";
$sorgu = mysql_query($tablo);
$oku = array (
1=> @mysql_result($sorgu,0,"alan_1"),
2=> @mysql_result($sorgu,0,"alan_2"),
3=> @mysql_result($sorgu,0,"alan_3"),
4=> @mysql_result($sorgu,0,"alan_4")
);
$yeni = $oku[$oy]+1;
$tablo2 = "UPDATE anket SET alan_$oy='$yeni' WHERE no='$git'";

if ( mysql_query($tablo2) ) {
setcookie("anket_$git","oy_$git",time()+3600*24*30);
header("Location: anket2.php?git=$git");
}
}
?>