12

<html lang="de">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Bootstrap 101 Template</title>

    <!-- Bootstrap -->
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <link href="css/fail.css" rel="stylesheet">

    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
      <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
  </head>
  <body>


    <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
    <!-- Include all compiled plugins (below), or include individual files as needed -->
    <script src="js/bootstrap.min.js"></script>
  </body>
</html>

<?php
session_start();
include_once("db.php");


$name = $_POST["username"];
$pw = $_POST["password"];
$mail = $_POST["email"];

$query = "SELECT * FROM user WHERE username = '".$name."'";
$result = mysqli_query($db,$query);

if(mysqli_num_rows($result) > 0)
{

	?>
	<html>
	<body>

	<div class="bs-example">
    <div class="alert alert-danger alert-error">
        <strong>Fehler!</strong> Dieser Benutzername wird bereits verwendet!<br>
        <a href="registration.html" class = "alert-link"><i>Klicken, falls du nicht automatisch Weitergeleitet wirst!</i>
    </div>
	</div>
	</body>

	</html>


	<?php
	header("Refresh:5; url=registration.html", true, 303);
}
else
{

	$quer = "INSERT INTO user (username, password, email, rang) VALUES ('".$name."','".$pw."','".$mail."','0')";
	$res = mysqli_query($db,$quer);

	?>
	<html>
	<body>

	<div class="bs-example">
    <div class="alert alert-success">
    Benutzer erfolgreich angelegt!<br>
        <a href="main.php" class = "alert-link"><i>Klicken, falls du nicht automatisch Weitergeleitet wirst!</i>
    </div>
	</div>
	</body>

	</html>
	<?php

	header("Refresh:5; url=main.php", true, 303);
}


  ?>