Untitled

<?php

    session_start();
    $_SESSION['message'] = "";
    $mysqli = new mysqli("localhost", "root", "", "accounts") or die ("Cannot connect");

    if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    	//katsotaan, että salasanat täsmäävät
    	if ($_POST['password'] == $_POST['confirmpassword']) {

    			$username = $mysqli->real_escape_string($_POST['username']);
    			$email = $mysqli->real_escape_string($_POST['email']);
    			$password = md5($_POST['password']);

    			$sql = "INSERT INTO users (username, email, password) " . "VALUES ('$username', '$email', '$password')";

    			if ($mysqli->query($sql) == true) {
    				header("location: verification.php");
            $_SESSION['message'] = "Rekisteröintisi onnistui. Ole hyvä ja vahvista tilisi sähköpostiisi lähetetyn linkin kautta";

//    				function send_mail($email,$message,$subject)
					 {
					  $mail = new PHPMailer();
					  $mail->IsSMTP();
					  $mail->SMTPDebug  = 0;
					  $mail->SMTPAuth   = true;
					  $mail->SMTPSecure = "ssl";
					  $mail->Host       = "smtp.gmail.com";
					  $mail->Port       = 465;
					  $mail->AddAddress($email);
					  $mail->Username = "yourgmailid@gmail.com";
					  $mail->Password = "yourgmailpassword";
					  $mail->SetFrom('you@yourdomain.com','Coding Cage');
					  $mail->AddReplyTo("you@yourdomain.com","Coding Cage");
					  $mail->Subject = $subject;
					  $mail->MsgHTML($message);
					  $mail->Send();
					 }
    			}else {
    				$_SESSION['message'] = "Käyttäjää ei voitu lisätä";
    			}

    	}else{
    		$_SESSION['message'] = "Salasanat eivät täsmää";
    	}
    }

?>

<!DOCTYPE html>
<html lang="fi">
  <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>HD Finland</title>


    <link href="css/bootstrap.css" rel="stylesheet">
	<link href="carousel.css" rel="stylesheet">
	<link href="style.css" rel="stylesheet">

  </head>
  <body>

  <div class="navbar-wrapper">
      <div class="container">


        <nav class="navbar navbar-inverse navbar-static-top">
          <div class="container">
            <div class="navbar-header">
              <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
                <span class="sr-only">Toggle navigation</span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
              </button>
              <a class="navbar-brand" href="index.php">HD Finland</a>
            </div>
            <div id="navbar" class="navbar-collapse collapse">
              <ul class="nav navbar-nav">
                <li class="dropdown">
                  <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Genret <span class="caret"></span></a>
                  <ul class="dropdown-menu">
                    <li><a href="#">Animaatio</a></li>
          					<li><a href="#">Dokumentti</a></li>
          					<li><a href="#">Draama</a></li>
          					<li><a href="#">Fantasia</a></li>
          					<li><a href="#">Kauhu</a></li>
          					<li><a href="#">Komedia</a></li>
          					<li><a href="#">Länkkäri</a></li>
          					<li><a href="#">Scifi</a></li>
          					<li><a href="#">Seikkailu</a></li>
                    <li><a href="#">Sota</a></li>
					          <li><a href="#">Toiminta</a></li>
                    <li><a href="#">Trilleri</a></li>
                  </ul>
                </li>
				        <li><a href="#">Tietoa meistä</a></li>
        				<form class="navbar-form navbar-left" action="search.php" method="GET">
        					<div class="form-group">
        						<input name="keyword" type="text" class="form-control" placeholder="Hae elokuvia...">
        					</div>
        					<button type="submit" class="btn btn-default">Hae</button>
        				</form>
              </ul>
            </div>
          </div>
        </nav>


		<div class="body-content">
		  <div class="module">
		    <h1>Luo tunnus</h1>
		    <form class="form" action="register.php" method="POST" enctype="multipart/form-data" autocomplete="off">
		      <div class="alert alert-error"><?= $_SESSION['message']?></div>
		      <input type="text" placeholder="Käyttäjänimi" name="username" required />
		      <input type="email" placeholder="S.posti" name="email" required />
		      <input type="password" placeholder="Salasana" name="password" autocomplete="new-password" required />
		      <input type="password" placeholder="Vahvista salasana" name="confirmpassword" autocomplete="new-password" required />
		      <input type="submit" value="Rekisteröidy" name="register" class="btn btn-block btn-primary" />
		    </form>
		  </div>
		</div>

      </div>
    </div>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
    <script src="js/bootstrap.js"></script>
  </body>
</html>