Untitled

<!DOCTYPE html>
<html>
	<head>
		<title>Spillside</title>
		<meta charset="utf-8" >
		<link rel="stylesheet" a href="spill.css" >
		<link rel="icon" href="diamant.png">
		<style>

		</style>
	</head>
	<body>
		<div id="conteiner">
			<div id="top">
				<img src="spillbanner2.gif" width="1210px">
			</div>

			<ul id="meny">
				<li><a href="spill.php" >Forside</a></li>
				<li><a href="nybruker.php" >Ny spiller</a></li>
				<li><a href="nyttspill.php" >Nytt Spill</a></li>
				<li><a href="session.php" >Ny Session</a></li>
			</ul>


			<div id="midten">
				<div class="overskrift"><h1>Ny Session</h1></div>
				<br>
				<form class="skjema" action="session.php" method="post">
					<?php

					$conn = new mysqli('localhost', 'root', '', 'spillside')
					or die ('Cannot connect to db');

						$result = $conn->query("select id, alias from spiller");

						echo "<html>";
						echo "<body>";
						echo "<div><label for='id'>Spiller: </label><select name='id'>";

						while ($row = $result->fetch_assoc()) {

							unset($id, $alias);
							$id = $row['id'];
							$alias = $row['alias'];
							echo '<option value="'.$id.'">'.$alias.'</option><br><br>';

							}

						echo "</select></div>";

					?>
					<?php

					$conn = new mysqli('localhost', 'root', '', 'spillside')
					or die ('Cannot connect to db');

						$result = $conn->query("select id, alias from spiller");

						echo "<html>";
						echo "<body>";
						?>
						<div><label for='motid'>Motspiller: </label><select name='motid'>
						<?php

						while ($row = $result->fetch_assoc()) {

							unset($motid, $alias);
							$motid = $row['id'];
							$alias2 = $row['alias'];
							echo '<option value="'.$motid.'">'.$alias2.'</option><br><br>';

							}

						echo "</select></div>";

					?>
					<?php

					$conn = new mysqli('localhost', 'root', '', 'spillside')
					or die ('Cannot connect to db');

						$result = $conn->query("select snr, snavn from spill");

						echo "<html>";
						echo "<body>";
						?>
						<div><label for='snr'> Spillnavn: </label><select name='snr'>
						<?php

						while ($row = $result->fetch_assoc()) {

							unset($snr, $snavn);
							$snr = $row['snr'];
							$snavn = $row['snavn'];
							echo '
							<option value="'.$snr.'" name="snr">'.$snavn.'</option><br><br>';

							}

						echo "</select></div>";

					?>
					<div>
					<label for="dato">Dato:</label>
					<input type="date" name="dato" id="dato" required>
					</div>
					<div>
					<label for="rate">Rating:</label>
					<input type="number" name="rate" id="rate" min="1" max="10" placeholder=" (1 - 10) " required>
					</div>
					<div>
					<label for="resultat">Resultat</label>
					<select name="resultat">
					<option value=1>Vant</option>
					<option value=-1>Tapte</option>
					<option value=0>Uavgjort</option>
					</select>
					</div><br>
					<div>
					<input type="submit" name="registrere" class="registrer" value="  Registrer  ">
					</div>
				</form>
				<br>
				<?php
					$servername = "localhost";
					$username = "root";
					$password = "";
					$dbname = "spillside";


					if (!mysqli_connect($servername,$username,$password, $dbname)){
						die("Connection failed: " . $conn->connect_error);
					}else{
						$conn = mysqli_connect($servername, $username, $password, $dbname);
						}
						$conn->set_charset("utf8");

					if(isset($_POST['id'])&&isset($_POST['snr'])&&isset($_POST['motid']) &&isset($_POST['dato'])&&isset($_POST['rate']) &&isset($_POST['resultat'])){
						if ($_POST['id'] !== $_POST ['motid']){
							$id = $_POST['id'];
							$motid = $_POST['motid'];
							$snr = $_POST['snr'];
							$dato = $_POST['dato'];
							$rate = $_POST['rate'];
							$resultat = $_POST['resultat'];
							if(!empty($id)&&!empty($motid)&&!empty($snr)&&!empty($dato)&&!empty($rate)&&!empty($resultat)){
								$sql = "INSERT INTO session VALUES ('','$dato','$rate','$resultat','$id','$motid','$snr')";
								$query_run=mysqli_query($conn, $sql);
								echo '<p class="regtext">Ny session er registrert</p>';
							}
							else{
								echo '<p class="regtext">Du må fylle ut alt!</p>';
							}
						}
						else {
							echo '<p class="regtext">Du kan ikke spille med deg selv!</p>';
						}
					}
					$conn->close();
				?>
			<br><br>
			</div>
			<div id="bunn">
				<p>Copyright &copy; 2015 Petter Røe Sundhaug</p>
			</div>
		</div>
	</body>

</html>