<?PHP
//include "file.php";

$databaseConnectionString = "mysql:host=localhost;port=3307;dbname=rpg";
$username = "root";
$password = "usbw";
$error = "";
$naam = "";
try {
$database = new PDO ($databaseConnectionString, $username, $password);
echo "<center> CONNECTION SUCCEDED </center>";
} catch (Exception $ex)
{
echo "Failed to connect to the database : ".$ex->getMessage();
}
if (array_key_exists("Register", $_REQUEST)) {
	echo "<center> <h1>Maakt nieuwe gebruiker aan </h1> <center>";
	$query = "INSERT INTO PLAYERS (USERNAME , PASSWORD, CHARACTER_NAME) VALUES (:veld1 , password(:veld2), :veld3)";
	$data = [
		'veld1' => $_REQUEST["username"],
		'veld2' => $_REQUEST["passwd"],
		'veld3' => $_REQUEST["username"]
	];
	echo "<!-- $query -->";
	try {
		$stmt = $database->prepare($query);
		if ($stmt->execute($data)) {
			echo "<center> <h1>Succesvol toegevoegd... </h1> <center>";
		}
		else {
			$error = "<center> <h1>Deze gebruiker bestaat al! </h1> <center>";
			echo "<!--";
			print_r($database->errorInfo());
			var_dump($data);
			echo "-->";
		}
	} catch (Exception $ex) {
		$error = "Kon geen ding toevoegen want: ".$ex->getMessage();
	}
} else if (array_key_exists("login", $_REQUEST)) {
	echo "";

	$query = "SELECT * FROM players WHERE username=:veld1 AND password=password(:veld2)";
	$data = [
		'veld1' => $_REQUEST["username"],
		'veld2' => $_REQUEST["passwd"],
	];
	try {
		$stmt = $database->prepare($query);
		$stmt->execute($data);
//		var_dump($data);
		if ($row=$stmt->fetch(PDO::FETCH_ASSOC)){
			$naam = $row["username"];
			echo "<center> <h1>Je bent ingelogd! $naam</h1> <center>";
		}
		else {
			echo "<center> <h1> Helaas je gebruikersnaam / wachtwoord klopt niet! </h1> <center>";
		}
	} catch (Exception $ex){
		$error = "Kon geen ding toevoegen want: ".$ex->getMessage();
	}
}

	else {
	echo "<center> <h1> Login om verder te gaan!</h1> <center>";
	}

?>