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

$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)
    {
        echo 'Username Exists';
        return false;
    }
    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>