Untitled

 <!--<?php include('database.php'); ?>-->
<!DOCTYPE html>

<html>
<head>
    <meta charset="utf-8">
    <title>Teh Games Questionaire</title>
</head>
<body>

<form method="post">
    <fieldset>
<?php
$host='cyberfyre.com.mysql';
$user='cyberfyre_com';
$password='SEt8iLhh';
$databaseName='cyberfyre_com';

$conn = mysqli_connect($host, $user, $password, $databaseName);
if ($conn->connect_error)
{
	die("Connection failed: " . $conn->connect_error);
}

echo "Connected successfully\r\n";

if (mysqli_ping($conn))
{
	echo " | Pinged Successfully";
}
else
{
	echo "Error: ". mysqli_error($conn);
}

?>
	</fieldset>
</form>

<form method="post">
    <fieldset>

	<form method="Name">

	      What is your name<br>

	      Name: <input type="text" name="Name"><br><br>
	</form>

	<form method="Email">

	      What is your email?<br>

	      Email: <input type="text" name="Email"><br><br>
	</form>

	<form method="Age">

		What age range do you belong to?<br>

		<input type="radio" name="Age" value="Under18"> Under 18.<br>
		<input type="radio" name="Age" value="18-25"> 18-25.<br>
		<input type="radio" name="Age" value="25-30"> 25-30.<br>
		<input type="radio" name="Age" value="30-35"> 30-35.<br>
		<input type="radio" name="Age" value="40-50"> 40-50.<br>
		<input type="radio" name="Age" value="50+"> 50+.<br><br>
	</form>

	<form method="FavGenre">
	      What is your favourite video-game genre?<br>
	      <input type="radio" name="FavGenre" value="RPG"> Role Playing Game.<br>
	      <input type="radio" name="FavGenre" value="Action"> Action.<br>
	      <input type="radio" name="FavGenre" value="MMORPG"> Massive Multiplayer Online Role Playing Game.<br>
	      <input type="radio" name="FavGenre" value="Strategy"> Strategy.<br>
	      <input type="radio" name="FavGenre" value="Simulation"> Simulation.<br>
	      <input type="radio" name="FavGenre" value="Adventure"> Adventure.<br>
	      <input type="radio" name="FavGenre" value="Sports"> Sports.<br>
	      <input type="radio" name="FavGenre" value="Action-Adventure"> Action-Adventure.<br><br>
	</form>

	<form method="DeviceQ">
	      What device do you usually play videogames on?<br>
	      <input type="radio" name="DeviceQ" value="PC"> PC.<br>
	      <input type="radio" name="DeviceQ" value="PS4"> Playstation 4.<br>
	      <input type="radio" name="DeviceQ" value="XBOXONE"> Xbox One.<br>
	      <input type="radio" name="DeviceQ" value="Wii U"> Nintendo Wii U.<br>
	      <input type="radio" name="DeviceQ" value="3DS"> Nintendo 3DS.<br>
	      <input type="radio" name="DeviceQ" value="Vita"> Playstation Vita<br><br>

	</form>

    	<form method="SingOrMulti">

	      Which do you enjoy more: Single Player or Multiplayer?<br>

	      <input type="radio" name="SingOrMulti" value="Single-Player"> Single-Player.<br>
	      <input type="radio" name="SingOrMulti" value="Multi-Player"> Multi-Player.<br><br>
	</form>

	<form method="locOrOnline">

		If you play multiplayer games, do you prefer local or online multiplayer?<br>

		<input type="radio" name="locOrOnline" value="Online"> Online.<br>
		<input type="radio" name="locOrOnline" value="Local"> Local.<br><br>
	</form>

	<form method="OpenWQ">

	       Do you prefer open world games or ones where the path is chosen for you?<br>

	      <input type="radio" name="OpenWQ" value="open"> Open World.<br>
	      <input type="radio" name="OpenWQ" value="pathed"> Path is chosen for you.<br>
	      <input type="radio" name="OpenWQ" value="notsure"> No Preference.<br><br>
	</form>

	<form method="actionorLinear">

		Do you prefer a game that reacts to your actions or one that is heavily linear?<br>

		<input type="radio" name="actionorLinear" value="yes"> Reacts to my actions.<br>
		<input type="radio" name="actionorLinear" value="no"> One that is linear.<br>
		<input type="radio" name="actionorLinear" value="same"> No Preference.<br><br>
	</form>

	<form method="challengeQ">

		Do you prefer simple games or ones with a challenge?<br>

		<input type="radio" name="challengeQ" value="Simple"> Simple.<br>
		<input type="radio" name="challengeQ" value="Challenging"> Challenging.<br><br>
	</form>

	<form method="gameplayTimeQ">

		How often do you spend playing games in each sitting?<br>

		<input type="radio" name="gameplayTimeQ" value="<1 hr"> <1 hr.<br>
		<input type="radio" name="gameplayTimeQ" value="1-2 hrs"> 1-2 hrs.<br>
		<input type="radio" name="gameplayTimeQ" value="2-3 hrs"> 2-3 hrs.<br>
		<input type="radio" name="gameplayTimeQ" value="3-5 hrs"> 3-5 hrs.<br>
		<input type="radio" name="gameplayTimeQ" value="5+ hrs"> 5+ hrs.<br><br>
	</form>

	<form method="JoshQ1">

		What is more important to you gameplay or graphics?<br>

		<input type="radio" name="JoshQ1" value="yes"> Gameplay.<br>
		<input type="radio" name="JoshQ1" value="no"> Graphics.<br><br>
	</form>

	<form method="JoshQ2">

          Do you prefer playing independent games or AAA titles?<br>

          <input type="radio" name="JoshQ2" value="yes"> Independant.<br>
          <input type="radio" name="JoshQ2" value="no"> AAA.<br><br>
	</form>

	<form method="JoshQ3">

		Do you enjoy realistic simulation games or more fictional ones?<br>

		<input type="radio" name="JoshQ3" value="yes"> Simulation.<br>
		<input type="radio" name="JoshQ3" value="no"> Fictional.<br><br>
	</form>

	<form method="JoshQ4">


		Do you prefer first person or third person in game?<br>

		<input type="radio" name="JoshQ4" value="yes"> First Person.<br>
		<input type="radio" name="JoshQ4" value="no"> Third Person.<br><br>
	</form>

	<form method="mod1">

	      Have you ever modded a game, or seen a modded game(e.g. Skyrim, G-Mod)?<br>

	      <input type="radio" name="mod1" value="yes"> Yes.<br>
	      <input type="radio" name="mod1" value="no"> No.<br><br>
	</form>

	<form method="mod2">

	      Do you think modded games are good enough to buy a pc over console?<br>

	      <input type="radio" name="mod2" value="yes"> Yes.<br>
	      <input type="radio" name="mod2" value="no"> No.<br><br>
	</form>

	<form method="comp1">

		Do you like “competetive games” ? e.g. DotA, CS:GO, Starcraft<br>

		<input type="radio" name="comp1" value="yes"> Yes.<br>
		<input type="radio" name="comp1" value="no"> No.<br><br>
	</form>

	<form method="cheatersQ">


	      Have Cheaters/Hackers ever put you off playing game?<br>

	      <input type="radio" name="cheatersQ" value="yes"> Yes.<br>
	      <input type="radio" name="cheatersQ" value="no"> No.<br><br>
	</form>

	<form method="post">
	      How many hours do you play games over the course of a week?<br>
	      <input type="radio" name="WkTime" value="60+"> 60+ hours a week.<br>
	      <input type="radio" name="WkTime" value="40-59"> 40-59 hours a week.<br>
	      <input type="radio" name="WkTime" value="30-39"> 30-39 hours a week.<br>
	      <input type="radio" name="WkTime" value="20-29"> 20-29 hours a week.<br>
	      <input type="radio" name="WkTime" value="15-19"> 15-19 hours a week.<br>
	      <input type="radio" name="WkTime" value="10-14"> 10-14 hours a week.<br>
	      <input type="radio" name="WkTime" value="5-9"> 5-9 hours a week.<br>
	      <input type="radio" name="WkTime" value="Less than 4"> Less than 4 hours a week.<br><br>
	</form>

	<form method="post">
	      Do you have any interest in purchasing DLC (Downloadable Content)?<br>
	      <input type="radio" name="DLCInterest" value="Very Interested"> Very Interested.<br>
	      <input type="radio" name="DLCInterest" value="Slightly Interested"> Slightly Interested.<br>
	      <input type="radio" name="DLCInterest" value="disinterested"> Disinterested.<br>
	      <input type="radio" name="DLCInterest" value="Slightly Interested"> Very disinterested.<br>
	      <input type="radio" name="DLCInterest" value="Depends"> Depends on game.<br><br>
	</form>

	<form method="post">
	      Which platforms do you purchase most games from?<br>
	      <input type="radio" name="GamePlatform" value="Retail"> Retail stores such as Game.<br>
	      <input type="radio" name="GamePlatform" value="Online physical"> Physical Copies from online retailers.<br>
	      <input type="radio" name="GamePlatform" value="online"> Online reatailers such as Steam or Green Man Gaming that provide digital copies.<br>
	      <input type="radio" name="GamePlatform" value="Developer"> Purchase games straight from the developer.<br>
	      <input type="radio" name="GamePlatform" value="Console marketplace"> Appropriate console marketplace, such as the Xbox live marketplace .<br>
	      <input type="radio" name="GamePlatform" value="second hand"> from pre-owned sources such as friends or ebay.<br><br>
	</form>

	<form method="post">
	       Would you be willing to pay a small subscription fee to play a game?<br>
	       <input type="radio" name="Subscription" value="Yes"> Yes.<br>
	       <input type="radio" name="Subscription" value="No"> No.<br><br>
	</form>

        <input type="submit" name="submit" value="Submit"><br>

    </fieldset>
</form>

<?php
if (empty($_POST['submit']))
{
	if(empty($_POST['Name']) and empty($_POST['Email']) and empty($_POST['Age']) and empty($_POST['FavGenre']) and empty($_POST['DeviceQ']) and empty($_POST['SingOrMulti']) and empty($_POST['locOrOnline']) and
	empty($_POST['OpenWQ']) and empty($_POST['actionorLinear']) and empty($_POST['challengeQ']) and empty($_POST['gameplayTimeQ']) and
	empty($_POST['JoshQ1']) and empty($_POST['JoshQ2']) and empty($_POST['JoshQ3']) and empty($_POST['JoshQ4']) and
	empty($_POST['mod1']) and empty($_POST['mod2']) and empty($_POST['comp1']) and empty($_POST['cheatersQ']) and
	empty($_POST['WkTime']) and empty($_POST['DLCInterest']) and empty($_POST['GamePlatform']) and empty($_POST['Subscription']))

	echo "You have missed questions";  //  Displaying Selected Value
	die();
}
else
{
	$sql = 'INSERT INTO `Responses` (`Name`, `Email`, `Age`, `FavGenre`, `DeviceQ`, `SingOrMulti`, `locOrOnline`, `OpenWQ`, `actionorLinear`, `challengeQ`, `gameplayTimeQ`, `JoshQ1`, `JoshQ2`, `JoshQ3`, `JoshQ4`,
	`mod1`, `mod2`, `comp1`, `cheatersQ`, `WkTime`, `DLCInterest`, `GamePlatform`, `Subscription`) VALUES ($_POST['Name'], $_POST['Email'], $_POST['Age'], $_POST['FavGenre'], $_POST['DeviceQ'],
        $_POST['SingOrMulti'], $_POST['locOrOnline'], $_POST['OpenWQ'], $_POST['actionorLinear'], $_POST['challengeQ'], $_POST['gameplayTimeQ'], $_POST['JoshQ1'], $_POST['JoshQ2'], $_POST['JoshQ3'],
		$_POST['JoshQ4'], $_POST['mod1'], $_POST['mod2'], $_POST['comp1'], $_POST['cheatersQ'], $_POST['WkTime'], $_POST['DLCInterest'], $_POST['GamePlatform'], $_POST['Subscription'])';
	mysql_query($sql) or die(mysql_error());
}
?>