<?php
//MySql database varibles
$host = 'mysql7.000webhost.com';
$database = 'a5580827_yuriah';
$db_username = 'a5580827_kelvin';
$db_password = 'monmon123';

//Connect to the MySQL database
if (($db = new PDO("mysql:host=$host;dbname=$database", $db_username, $db_password)) == NULL) {
	echo $db->getMessage();
}

//POST the username and password
$username =  $_POST['username'];
$password = sha1(sha1($_POST['username']) . sha1($_POST['password']));
$email = $_POST['email'];

  $db_query = mysql_query("SELECT (*) FROM Members WHERE username=:username");
  $db_query->execute(':username' => $username);
    if (mysql_num_rows($db_query) > 0) {
        echo "This username is already taken";
		die();
    } else {
        $db_query = mysql_query("INSERT INTO Members VALUES ('$username','$password','$email')");
        echo "Registration Success";
		header("location:index.php");
		}
?>