<?php

  $name = $_POST['name'];
  $username = $_POST['username'];
  $email = $_POST['email'];
  $password_1 = $_POST['password_1'];
  $password_2 = $_POST['password_2'];
  $agreed = $_POST['confirm'];
  $newsletter = $_POST['newsletter'];
  $password = md5($password_1);

 $db = new PDO('mysql:host=localhost;dbname=emildeveloping6;charset=utf8mb4', 'root', '');

try{

    $query = "INSERT INTO users (username, name, email, password, newsletter, agreed) VALUES (:username,:name,:email,:password,:newsletter,:agreed)";

$stmt = $db->prepare($query);
$stmt->bindparam(":username",$username);
$stmt->bindparam(":name",$name);
$stmt->bindparam(":email",$email);
$stmt->bindparam(":passsword",$password);
$stmt->bindparam(":newsletter",$nesletter);
$stmt->bindparam(":agreed",$agreed);
$stmt->execute();

echo "Test";
exit();
}

catch(PDOException $exception){
die('ERROR: ' . $exception->getMessage());
}
?>