<?php
$servername = "";
$username = "";
$password = "";
$dbname = "test";

$conn = new mysqli($servername, $username, $password, $dbname);

if (!$conn) {
                die("connection failed: " . mysqli_error());
}

$username = $_POST['username'];
$password = $_POST['password'];

$sql = "INSERT INTO user (username, password) VALUES ('$username', '$password')";


if($conn->query($sql) === TRUE) {
        echo "created new account";
} else {
        echo "Error";
}
        $conn->close();

?>


~