<?php

	try {
		$db = new PDO('mysql:host=localhost;dbname=db;charset=UTF-8', 'user', 'pass', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));

		$username=$_POST['username'];
		$password=$_POST['password'];
		$confirm_password=$_POST['password2'];

		$prepquery=$db->prepare('SELECT * FROM users WHERE username=:username OR email=:email');
		$prepquery->bindParam(':username', $username);
		$prepquery->bindParam(':email', $email);
		$query=$db->exec($prepquery);
		$check=$query->rowCount();

		if($check !== 0) {
			echo "Username and/or email address already in use, please go back and try again.";
		} if($password !== $confirm_password) {
			echo "The passwords did not match, please go back and try again.";
		} else {

			$stmt = $db->prepare('INSERT INTO users (username, password, email, creation_date) VALUES (:username, :password, :email, :date)');
			$stmt->bindParam(':username', $name);
			$stmt->bindParam(':password', $finalPassword);
			$stmt->bindParam(':email', $email);
			$stmt->bindParam(':date', $date);

			$date = date("F j, Y, g:i a");

			$Salt = uniqid();
			$Algo = '6';
			$Rounds = '7500';
			$cryptSalt = '$' . $Algo . '$rounds=' . $Rounds . '$' . $Salt;

			$finalPassword=crypt($password, $cryptSalt);

			$stmt->execute();

			echo 'Registration complete, you may now login.';
		}

	} catch(PDOException $ex) {
		echo "An error occured!";
	}