<?php

$user = 'root';
$password = 'root';
$db = 'cdhouse';
$host = 'localhost';
$port = 3306;

$link = mysqli_init();
$success = mysqli_real_connect(
   $link,
   $host,
   $user,
   $password,
   $db,
   $port
);

$account      = $_POST["account"];
$password     = $_POST["password"];
$name         = $_POST["name"];
$phone        = $_POST["phone"];
$email        = $_POST["email"];
$current_area = $_POST["current_area"];
$badge        = $_POST["badge"];
$wonder_area  = $_POST["wonder_area"];

$sql = "INSERT INTO contacts(`account`,`password`,`name`, `phone`, `email`, `current_area`, `badge`, `wonder_area`) VALUES('$account','$password','$name', '$phone', '$email', '$current_area', '$badge', '$wonder_area')";

mysqli_query($link, $sql);

header("Location: /cdhouse");