<?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
$connected = mysql_connect(localhost,$username,$password);
if (!$connected) {
    die('Could not connect: ' . mysql_error());
}

//selects database
mysql_select_db($database, $connected) or die('Unable to select database: ' . $mysql_error());
//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();

?>