Анкета

S

slideR

Registered
Ето това е едно кодче написано от мен за анкета
Код: 
<?php

	include 'connect.php';

	mysql_query("SET NAMES cp1251");

	header("Content-type: text/html; charset=Windows-1251");

	$time = time();

	$ip = $_SERVER['remote_addr'];

	$sql = "SELECT * FROM vaprosi ORDER BY id DESC LIMIT 1";

	$result = mysql_query($sql);

	$row = mysql_fetch_assoc($result);

	$vapros = $row['vapros'];

	$vid = $row['id'];

	echo $vapros;

	echo '<br>';

	echo "\n";

	$sql1 = "SELECT * FROM ip WHERE ip LIKE '$ip' AND za LIKE '$vid' ";

	$rez1 = mysql_query($sql1);

	$chekip = mysql_num_rows($rez1);

	if ($chekip == 0) {

		$sql2 = "SELECT * FROM otgovori WHERE za = '$vid'";

		$res2 = mysql_query($sql2);

		echo '<form action="" method="post">';

			while($row1 = mysql_fetch_assoc($res2)) {

				echo '<input type="radio" name="vote" value="'.$row1['otgovor'].'"> '.$row1['otgovor'].'<br>';

				echo "\n";

			}

		echo '<input type="submit" name="glas" value="Гласувай">';

		echo "\n";

		echo '</form>';

		$vote = $_POST['vote'];

			if(isset($_POST['glas'])) {

			$sql10 = "SELECT * FROM ip WHERE ip LIKE '$ip' AND za LIKE '$vid' ";

			$rez10 = mysql_query($sql10);

			$chekip = mysql_num_rows($rez10);

			if ($chekip == 0) {

			$sql6 = "SELECT * FROM otgovori WHERE otgovor = '$vote'";

			$result1 = mysql_query($sql6);

			$row = mysql_fetch_assoc($result1);

				$voteе=$row['rezultat'];

				$voteе++ ; 

				$sql="UPDATE otgovori SET rezultat='$voteе' WHERE otgovor = '$vote'";

				mysql_query($sql);

	

				$sql3 = "INSERT INTO ip (ip, za) VALUES ('$ip','$vid')";

				mysql_query($sql3);

				echo 'Успешно гласувахте!';

			} else {

				echo 'Вие сте гласували!';

			}

			}

	} else {

	$sql5 = "UPDATE otgovori SET rezultat='$tvote' WHERE o_id='$vote'";

	$rez = mysql_query($sql); 

	$sql4 = "SELECT * FROM ip WHERE za LIKE '$vid'";

	$rez1 = mysql_query($sql4);

	$broiip = mysql_num_rows($rez1); 

		$sql = "SELECT * FROM otgovori WHERE za LIKE '$vid'";

		$rez = mysql_query($sql);

			while($red=mysql_fetch_array($rez)){

				if($red['rezultat'] == NULL) {

				

					echo $red['otgovor'];

					echo "\n";

					echo " <font color=\"red\">0</font><br>\n";

				} else {

					echo $red['otgovor'];

					echo "\n";

					echo " <font color=\"red\">".$red['rezultat']."</font><br>\n";

				}

			

		} 

	}

?>
sql.sql
Код: 
CREATE TABLE `otgovori` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `otgovor` varchar(255) COLLATE cp1251_bulgarian_ci NOT NULL,
  `za` varchar(255) COLLATE cp1251_bulgarian_ci NOT NULL,
  `rezultat` varchar(255) COLLATE cp1251_bulgarian_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=cp1251 COLLATE=cp1251_bulgarian_ci;

CREATE TABLE `ip` (
  `ip` varchar(255) COLLATE cp1251_bulgarian_ci NOT NULL,
  `za` varchar(255) COLLATE cp1251_bulgarian_ci NOT NULL,
  PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bulgarian_ci;

CREATE TABLE `vaprosi` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `vapros` varchar(255) COLLATE cp1251_bulgarian_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=cp1251 COLLATE=cp1251_bulgarian_ci;
connect.php
Код: 
<?php
	$host = "localhost";
	$user = "root";
	$pass = "";
	$db = "asd";
	mysql_connect($host,$user,$pass) or die ("Не мога да се свържа с mysql сървър");
	mysql_select_db($db) or die ("Няма такава база данни");
?>
Искам да ви помоля да ми го направите с проценти!
Примерно за отговор "Да" има 1 глас и да каже, че това е 100% от всички гласове, които са 1
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе