<?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'];


$username1 = mysql_real_escape_string($username);

$email1 = mysql_real_escape_string($email);

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

$email_result = mysql_query($check_email_query);

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

$username_result = mysql_query($check_username_query);

if (mysql_num_rows($username_result) > 0)
    {
        echo "Username Taken".'</br>';


    }

else (mysql_num_rows($email_result) > 0)
    {
        echo "Email Taken";
        exit;
    }



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

'$vpassword','$email')";

$result= mysql_query($query);

echo "Fields inserted successfully in the database";

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