<?php

//opens connection to the database

$dbc = mysql_connect('localhost', 'root', '');

if (!$dbc)
    {
        die("Not Connected :" .mysql_error());
    }

// selecting a database

$db_select= mysql_select_db("testing", $dbc);

if (!$db_select)
    {
        die ("Not Connected : ". mysql_error());
    }


$username= $_POST['username'];

$password= $_POST['pwd1'];

$vpassword= $_POST['pwd2'];

$email= $_POST['email'];

$email1 = mysql_real_escape_string($email1);

$check_email_query = "SELECT EMAIL FROM MEMBERS WHERE EMAIL = '$email1';";

$email_result = mysql_query($check_email_query);

if (mysql_num_rows($check_email_query) > 0)

    {
        print '<script type="text/javascript">';
        print 'alert("The email address '. $_POST['email'].' is already registered")';
        print '</script>';
        header("Location: index.html");
        exit;
    }
else if

    {


$username1 = mysql_real_escape_string($username);

$check_username_query = "SELECT USERNAME FROM MEMBERS WHERE USERNAME = '$username1';";

$username_result = mysql_query($check_username_query);

if (mysql_num_rows($username_result) > 0)
    {

        print '<script type="text/javascript">';
        print 'alert("The Username '. $_POST['username'].' is already taken")';
        print '</script>';
        header("Location: index.html");
        exit;
    }
}
    else

$query= "INSERT INTO members (username, password, vpassword) VALUES ('$username', '$password', '$vpassword')";

$result= mysql_query($query);

echo "Fields inserted successfully in the database";

?>
</br>
<a href="index.html">Back</a>