<?php
$servername = "localhost";
$dbusername = "ryan";
$dbpassword = "rocx";
$dbname = "test_php";

$fname = $_POST ['username'];
$fname = $_POST ['email'];
$fname = $_POST ['password'];
$fname = $_POST ['password_confirm'];

//Create Connection
$conn = new mysqli ($servername, $dbusername, $dbpassword, $dbname);

//Check Connection
if ($conn->connect_error) {
  die("connection_failed: " . $sconn->connect_error);
}

$sql = "INSERT INTO accounts (username, email, password, password_confirm)
VALUES ('username', 'email', 'password', 'password_confirm')";

if ($conn->query($sql) === TRUE) {
    echo "Thanks for registering at Kitnet, enjoy!";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();