<?php

	// CONEXION A LA DB
	$dbserver 			= "localhost";
	$dbusername 		= "root";
	$dbpassword 		= "";
	$db 				= "mmorts";

	// CREAR CONEXION
	$conn = new mysqli($dbserver, $dbusername, $dbpassword, $db);

	// CHEKEAR CONEXION
	if ($conn->connect_error)
	{
		die("Connection failed: ".$conn->connect_error);
	}


	//VARIABLES REGISTER.PHP
	$username 	= $_POST['username'];
	$password 	= $_POST['password'];
	$email 		= $_POST['email'];

	//ENCRYPTAR PASS
	// $password = md5($password);

	$password = password_hash($password, PASSWORD_BCRYPT);

	//CHEKEAR VARIABLES IF OK

	//CHECKEAR SI EL USER ES UNICO
	$sql = "SELECT username FROM users WHERE username = '$username'";
	if($result=mysqli_query($conn,$sql))
	{
		$rowcount = mysqli_num_rows($result);
	}

	if($rowcount >= 1)
	{
		echo "There is alredy an user with that name.";
	}
	else
	{
		//INSERTAR DATA A DATABASE
		 $sql ="INSERT INTO users (username, password, email)
		 VALUES ('$username', '$password', '$email')";

		//EXECUTE QUERY
		if($conn->query($sql) === TRUE)
		{
			echo "Account has been added successfully.";

			header("Location: ../../index.php?msg=registrationsuccess");
			die();
		}
		else
		{
			echo "Error: ".$sql."<br/>".$conn->error;
		}
	}
?>