View difference between Paste ID: <a href="/qrNp5xfm">qrNp5xfm</a> and <a href="/dy3Y79Lc">dy3Y79Lc</a>

<?php include 'database.php' ?>
1		<?php include 'database.php' ?>
2
3		<?php
4		if($_SERVER["REQUEST_METHOD"]=="POST")
5		{
6		$username = mysql_real_escape_string($_POST['username']);
7		$password = mysql_real_escape_string($_POST['password']);
8		$bool = true;
9
10		$query = mysql_query("SELECT * FROM employee");
11		while($row=mysql_fetch_array($query))
12		{
13		$table_employee=$row['username'];
14		if($username==$table_employee)
15		{
16		$bool=false;
17		Print '<script>alert("Username has been taken !");</script>';
18		Print '<script>window.location.assign("register.php");</script>';
19		}
20		}
21
22		if($bool)
23		{
24		$username = $_POST['username'] //ni sambung
25		$icno= $_POST['icno'] //ni sambung
26		$icno= $_POST['icno'] //ni sambung
27		mysql_query("INSERT INTO employee(username, password, name, icno, address, postcode, email, phone)
28		VALUES('$username','$password','$name','$icno','$address','$postcode','$email','$phone')");
29		Print '<script>alert("Successfully Registered !");</script>';
30		// Print '<script>window.location.assign("login.php");</script>';
31		}}
32		?>
33
34		<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
35		<html xmlns="http://www.w3.org/1999/xhtml">
36		<head>
37		<title>PCC Register</title>
38		</head>
39		<?php include 'header login.php';?>
40		<body>
41
42		<div class="container">
43		<div class="row">
44		<div class="col-md-6 col-md-offset-3">
45		<div class="panel panel-login">
46		<div class="panel-heading">
47		<div class="row">
48		<div class="col-xs-6">
49		<a href="login.php" class="active" id="loginlink">Login</a>
50		</div>
51		<div class="col-xs-6">
52		<a href="register.php" id="registerlink">Register</a>
53		</div>
54		</div>
55		<hr>
56		</div>
57		<div class="panel-body">
58		<div class="row">
59		<div class="col-lg-12">
60		<form id="register-form" action="register.php" method="post" role="form" style="display: block;">
61		<div class="form-group">
62		<input type="text" name="username" id="username" tabindex="1" class="form-control" placeholder="Username" required="required">
63		</div>
64		<div class="form-group">
65		<input type="password" name="password" id="password" tabindex="2" class="form-control" placeholder="Password" required="required">
66		</div>
67		<div class="form-group">
68		<input type="text" name="name" id="name" tabindex="3" class="form-control" placeholder="Your Full Name" required="required">
69		</div>
70		<div class="form-group">
71		<input type="text" name="icno" id="icno" tabindex="4" class="form-control" placeholder="IC Number" required="required">
72		</div>
73		<div class="form-group">
74		<textarea type="text" name="address" id="address" tabindex="5" class="form-control" placeholder="Address" required="required"></textarea>
75		</div>
76		<div class="form-group">
77		<input type="number" name="postcode" id="postcode" tabindex="6" class="form-control" placeholder="Postcode" required="required">
78		</div>
79		<div class="form-group">
80		<input type="text" name="email" id="email" tabindex="7" class="form-control" placeholder="1234@gmail.com" required="required">
81		</div>
82		<div class="form-group">
83		<input type="text" name="phone" id="phone" tabindex="8" class="form-control" placeholder="Mobile Number" required="required">
84		</div>
85
86
87
88		<div class="form-group">
89		<div class="row">
90		<div class="col-sm-6 col-sm-offset-3">
91		<input type="submit" name="reg-submit" id="reg-submit" tabindex="9" class="form-control btn btn-login" value="Register">
92		</div>
93		</div>
94		</div>
95
96		</form>
97
98		</div>
99		</div>
100		</div>
101		</div>
102		</div>
103		</div>
104		</div>
105		</body>
106		</html>