WebAppTeamA/poll.php at master · ashleywillard/WebAppTeamA · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
<?php
include ("account.php");


	$fname = $_POST['fname'];
	$fname = mysql_real_escape_string($fname);

	$lname = $_POST['lname'];
	$lname = mysql_real_escape_string($lname);

	$theme = $_POST['theme'];
	$theme = mysql_real_escape_string($theme);

	$vantage = $_POST['vantage_theme'];


	$eighties = $_POST['eighties_theme'];


	$sql = "select lname from poll where lname = '$lname'";
	$result = mysql_query($sql);

	if (mysql_num_rows($result) == 1){
		echo "You have already voted," . $fname . " " . $lname;
	} else{
		if ($vantage != null && $eighties == null) {
			$vantage = 1;
			$eighties = 0;
			$sql1 = "insert into poll (fname, lname, vantage, eighties, other_theme) values ('$fname', '$lname', '$vantage', '$eighties', '$theme')";
			mysql_query($sql1);
			echo "Thank You for voting!";
		} else {
			if($eighties != null && $vantage == null){
			$eighties = 1;
			$vantage = 0;
			$sql2 = "insert into poll (fname, lname, vantage, eighties, other_theme) values ('$fname', '$lname', '$vantage', '$eighties', '$theme')";
			mysql_query($sql2);
			echo "Thank You for voting!";
		}

		}
	}


?>