+<?php
+//require_once ("config.php");
+//$mysqli = new mysqli('mysql.metropolia.fi', 'pauliips', 'pelle666', 'pauliips');
+
+//ob_start();
+session_start();
+
+//include_once ("config.php");
+
+//$error = false;
+
+if (isset($_POST['signup']) ) {
+
+  include_once ("config.php");
+
+  $username = $_POST['username'];
+  $email = $_POST['email'];
+  $password = $_POST['password'];
+
+  //error händleri
+  //tarkista tyhjät kentät
+  if (empty($username) || empty($email) || empty($password)) {
+      header("Location: signup.html?signup=empty");
+      exit();
+  } else {
+      //tarkista sähköposti
+      if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
+          header("Location: signup.html?signup=invalidemail");
+          exit();
+      } else {
+          $sql =  "SELECT * FROM Users WHERE Nickname = '$username'";
+          $param = array('username' => $username);
+          $query = $DBH->prepare($sql);
+          $query->execute($param);
+          $row = $query->fetch();
+
+          if ($query-> rowCount != 0) {
+              header("Location: signup.html?signup=usertaken");
+              exit();
+          } else {
+              //salasana häshi/suola
+              $hashpassword = md5($_POST['password'].'!!!');
+              //tietokantaan lisäys
+              $params = array('username' => $username, 'email' => $email, 'password' => $hashpassword);
+              $query =  $DBH->prepare("INSERT INTO Users (Nickname, Email, Passwrd) VALUES ('$username','$email','$hashpassword')");
+              $query->execute($params);
+              header("Location: login.html?signup=success");
+              exit();
+          }
+      }
+
+  }
+
+} else {
+    header("Location: index.html");
+    exit();
+}
+
+    /*$username = trim($_POST['username']);
+    $username = strip_tags($username);
+    $username = htmlspecialchars($username);
+
+    $email = trim($_POST['email']);
+    $email = strip_tags($email);
+    $email = htmlspecialchars($email);
+
+    $password = trim($_POST['password']);
+    $password = strip_tags($password);
+    $password = htmlspecialchars($password);
+
+
+    //error händlerit
+    if (empty($username) || empty($email)  || empty($password)) {
+        header("There was an error, SOS");
+        exit();
+    } else {
+        //tsekii sähköposstin
+        if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
+            header("There was an error, SOS");
+            exit();
+        } else {
+            //tsekitään onko käyttäjänimeä olemassa
+            $sql = "SELECT * FROM Users WHERE Nickname = '$username'";
+            $result = mysqli_query($DBH, $sql);
+            $resultCheck = mysqli_num_rows($result);
+            if ($resultCheck > 0) {
+                header("Location: ../signup.html");
+                exit();
+            }
+        }
+
+    }
+
+    //password hash
+    //$password = md5($_POST['password'].'!!!');
+
+    //jos ei tuu errorii jatka rekisteröitymiseen
+    if (!$error) {
+       $query =  $DBH->prepare("INSERT INTO Users (Nickname, Email, Passwrd) VALUES ('$username','$email','$password')");
+
+       if ($query->execute()) {
+           $errTYp = header("wii");
+           $errMSG = header("Successfully registered, you may login now");
+           unset($username);
+           unset($email);
+           unset($password);
+       } else {
+           $errTyp = header("SOS");
+           $errMSG = header("homma kusi");
+       }
+    }
+
+?>
+    }*/