<?php
$host = "localhost";
$db_user = "root";
$db_password = "";
$db_name = "portfolio";
$user = $_POST['user'];
$username = $user[0]['value'];
$surname = $user[1]['value'];
$usernumber = $user[2]['value'];
$password = $user[3]['value'];

$conn = new mysqli($host, $db_user, $db_password, $db_name);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO users (username, surname, usernumber, password)
VALUES ('$username', '$surname', '$usernumber', '$password')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

?>