
<?php
define('DB_HOST', 'localhost');
define('DB_NAME', 'member');
define('DB_USER','root');
define('DB_PASSWORD','bsit');

$con=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " . mysql_error());
$db=mysql_select_db(DB_NAME,$con) or die("Failed to connect to MySQL: " . mysql_error());


function NewUser()
{
	$mem_id = $_POST['mem_id'];
	$Userame = $_POST['Userame'];
	$Password =  $_POST['Password'];
	$Gender = $_POST['Gender'];
	$Fav_band = $_POST['Fav_band'];
	$query = "INSERT INTO member (mem_id,Userame,Password,Gender,Fav_band) VALUES ('$mem_id','$Userame','$Password','$Gender','$Fav_band')";
	$data = mysql_query ($query)or die(mysql_error());
	if($data)
	{
	echo "YOUR REGISTRATION IS COMPLETED...";
	}
}

function SignUp()
{
if(!empty($_POST['Username']))   //checking the 'user' name which is from Sign-Up.html, is it empty or have some text
{
	$query = mysql_query("SELECT * FROM member WHERE Userame = '$_POST[Userame]' AND Password = '$_POST[Password]'") or die(mysql_error());

	if(!$row = mysql_fetch_array($query) or die(mysql_error()))
	{
		newuser();
	}
	else
	{
		echo "SORRY...YOU ARE ALREADY REGISTERED USER...";
	}
}
}
if(isset($_POST['submit']))
header("location: member.php");
    exit();
{
	SignUp();
}
?>