<?php
//connection details
/*$servername = "XXXXXXXXX";
$username = "sqlXXXXXXXXX";
$password = "password";
$dbname = "sqlXXXXXXXXX";*/

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "coursework";

$conn = mysqli_connect($servername, $username, $password, $dbname);

$username=$_POST['name'];
$email=$_POST['email'];
$password=$_POST['password'];
$admin=0;

$hash = crypt($password);

//prepared statement
$stmt = mysqli_prepare($conn, "INSERT INTO USERS (username, email, hash, admin) VALUES (?,?,?,?)");

//dealing with the parameters
mysqli_stmt_bind_param($stmt, "sssi", $username, $email, $hash, $admin);

mysqli_stmt_execute($stmt);

//close statement and connection
mysqli_stmt_close($stmt);
mysqli_close($conn);

?>