<?php
	include_once("db_conection.php");

	$error = "";
	if(isset($_POST["submit"]))
	{
		if(empty($_POST["username"]) || empty($_POST["password"]))
		{
			$error = "Beiden velden zijn vereist";
		}else
		{
			$username=$_POST['username'];
			$password=$_POST['password'];

			$username = mysqli_real_escape_string($db, $username);
			$password = mysqli_real_escape_string($db, $password);
			$password = md5($password);

			$sql="SELECT 1 FROM users WHERE username='$username' AND password='$password'";

			$result=mysqli_query($db,$sql);
			$row=mysqli_fetch_array($result,MYSQLI_ASSOC);


			if(mysqli_num_rows($result) == 1)
			{
				$_SESSION['username'] = $username;
				header("location: reacties.php");
			}else
			{
				$error='<div class="alert alert-danger">Inlognaam en of wachtwoord klopt niet</div>';
			}

		}
	}
$msg = "";
	if(isset($_POST["submit2"]))
	{
		$username = $_POST["username"];
		$email = $_POST["email"];
		$password = $_POST["password"];

		$username = mysqli_real_escape_string($db, $username);
		$email = mysqli_real_escape_string($db, $email);
		$password = mysqli_real_escape_string($db, $password);
		$password = md5($password);


		$sql="SELECT email FROM users WHERE email='$email'";
		$result=mysqli_query($db,$sql);
		$row=mysqli_fetch_array($result,MYSQLI_ASSOC);
		if(mysqli_num_rows($result) == 1)
		{
			$msg = "Deze E-Mail adres is al in gebruik.";
		}
		else
		{
			$query = mysqli_query($db, "INSERT INTO users (username, email, password)VALUES ('$username', '$email', '$password')");
			if($query)
			{
						$msg='<div class="alert alert-success">Bedankt voor je registratie Je zult nu doorgestoord worden</div>';

				header( "Refresh: 2; url=index.php
" );

			}
		}
	}
?>