<?php
//take inputs from register.html
$userNameInput = $_POST['Name'];
$userEmailInput = $_POST['Email'];
$userPasswordInput = $_POST['Password'];
$userWaterInput = $_POST['Water'];
$userImageInput = $_POST['Image'];
$userLocationInput = $_POST['Location'];
$userCourseInput = $_POST['Location'];

//database connection jazz
$username="root";
$password="lolno";
$database="assassin";
//connection line
mysql_connect(localhost,$username,$password);

//selects database
@mysql_select_db($database) or die("Unable to select database");
//self congratulatory message on win.
print "Congratulations!";


$query = "INSERT INTO users (name,email,password,water,image,location,course) VALUES ('$userNameInput','$userEmailInput','$userPasswordInput','$userWaterInput','$userImageInput','$userLocationInput','$userCourseInput')";

if (mysql_query('$query'))
{
echo "Data entered!";
}
else
{
echo "Failed!";
}

//closes database connection, IMPORTANT
mysql_close();

?>