register.php

<?php include 'database.php' ?>

<?php
if($_SERVER["REQUEST_METHOD"]=="POST")
{
$username = mysql_real_escape_string($_POST['username']);
$password = mysql_real_escape_string($_POST['password']);
$bool = true;

$query = mysql_query("SELECT * FROM employee");
while($row=mysql_fetch_array($query))
{
	$table_employee=$row['username'];
	if($username==$table_employee)
{
	$bool=false;
	Print '<script>alert("Username has been taken !");</script>';
	Print '<script>window.location.assign("register.php");</script>';
}
}

if($bool)
{
	mysql_query("INSERT INTO employee(username, password, name, icno, address, postcode, email, phone)
	VALUES('$username','$password','$name','$icno','$address','$postcode','$email','$phone')");
	Print '<script>alert("Successfully Registered !");</script>';
   // Print '<script>window.location.assign("login.php");</script>';
}}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>PCC Register</title>
</head>
<?php include 'header login.php';?>
<body>

<div class="container">
    	<div class="row">
			<div class="col-md-6 col-md-offset-3">
				<div class="panel panel-login">
					<div class="panel-heading">
						<div class="row">
							<div class="col-xs-6">
								<a href="login.php" class="active" id="loginlink">Login</a>
							</div>
							<div class="col-xs-6">
								<a href="register.php" id="registerlink">Register</a>
							</div>
						</div>
						<hr>
					</div>
					<div class="panel-body">
						<div class="row">
							<div class="col-lg-12">
								<form id="register-form" action="register.php" method="post" role="form" style="display: block;">
									<div class="form-group">
										<input type="text" name="username" id="username" tabindex="1" class="form-control" placeholder="Username" required="required">
									</div>
									<div class="form-group">
										<input type="password" name="password" id="password" tabindex="2" class="form-control" placeholder="Password" required="required">
									</div>
                                    <div class="form-group">
										<input type="text" name="name" id="name" tabindex="3" class="form-control" placeholder="Your Full Name" required="required">
									</div>
                                    <div class="form-group">
										<input type="text" name="icno" id="icno" tabindex="4" class="form-control" placeholder="IC Number" required="required">
									</div>
                                    <div class="form-group">
										<textarea type="text" name="address" id="address" tabindex="5" class="form-control" placeholder="Address" required="required"></textarea>
									</div>
                                    <div class="form-group">
										<input type="number" name="postcode" id="postcode" tabindex="6" class="form-control" placeholder="Postcode" required="required">
									</div>
                                    <div class="form-group">
										<input type="text" name="email" id="email" tabindex="7" class="form-control" placeholder="1234@gmail.com" required="required">
									</div>
                                    <div class="form-group">
										<input type="text" name="phone" id="phone" tabindex="8" class="form-control" placeholder="Mobile Number" required="required">
									</div>


                                    <div class="form-group">
										<div class="row">
											<div class="col-sm-6 col-sm-offset-3">
												<input type="submit" name="reg-submit" id="reg-submit" tabindex="9" class="form-control btn btn-login" value="Register">
											</div>
										</div>
									</div>

								</form>

							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>
</body>
</html>