-
Notifications
You must be signed in to change notification settings - Fork 170
/
register.php
101 lines (94 loc) · 3.17 KB
/
register.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
<head>
<title>Registration</title>
</head>
<body>
<H1>Register to CabsOnline</H1>
<form action ="register.php" method="post">
<p>Please fill the fields below to complete your registration.</p>
<table>
<tr>
<td><label>Name:</label></td> <td><input type="text" name="name" maxlength="30"></td>
</tr><tr>
<td><label>Password:</label></td> <td><input type="text" name="pwd" maxlength="30"></td>
</tr><tr>
<td><label>Confirm password:</label></td> <td><input type="text" name="Cpwd" maxlength="30"></td>
</tr><tr>
<td><label>Email:</label></td> <td><input type="text" name="email" maxlength="30"></td>
</tr><tr>
<td><label>Phone:</label></td> <td><input type="text" name="phone" maxlength="12"><br></td>
</tr><tr>
<td></td><td><button type="reset" value="Reset">Reset</button><button type="submit" name="submit">Submit</button></td>
</tr>
</table>
</form>
<b>Already registered? </b> <a href="login.php">Login here</a><br><br>
</body>
<?php
//connect to mysql server
include ('dbconnect.php');
//get name, password, e-mail and contact number passed from client
if (isset($_POST['submit']))
{
$name = $_POST['name'];
$pwd = $_POST['pwd'];
$Cpwd = $_POST['Cpwd'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$count = 0;
//validate the name
if (empty($name)) {
echo "Please fill in your name.<br>";
} else {
$name = $_POST['name'];
++$count;
}
//validate password
if (empty($pwd)) {
echo "Please fill in your password.<br>";
} elseif (empty($Cpwd)) {
echo "Please enter a confirmation password.<br>";
} elseif ($pwd !== $Cpwd) {
echo "The passwords do not match. Please enter again.<br>";
} else {
$pwd = $_POST['Cpwd'];
++$count;
}
//validate email
if (empty($email)) {
echo "Please fill in a valid e-mail address.<br>";
} elseif (filter_var($email, FILTER_VALIDATE_EMAIL) == true) {
//access data in database
$SQLstring = "SELECT Email from customer where Email = '$email';";
$queryResult = @mysqli_query($DBConnect, $SQLstring)
Or die ("<p>1.Unable to query the table.</p>"."<p>Error code ".mysqli_errno($DBConnect). ": ".mysqli_error($DBConnect)). "</p>";
if (mysqli_num_rows($queryResult) !== 0)
{ --$count;
echo "This email is already registered. Please use another email address.<br>";
} else {
$email=strtolower($_POST['email']);
++$count;
}
} else {
echo "Please fill in a valid e-mail address.<br>";
}
//validate phone
if (empty($phone)) {
echo "Please fill in your contact phone number.<br>";
} elseif (is_numeric($phone)) {
$phone = $_POST['phone'];
++$count;
} else {
echo "Please fill in a valid contact number.<br>";
}
//write to database of customer table
if ($count == 4) {
$query = "INSERT INTO customer ( Name, Password, Email, Phone) VALUES ('$name','$pwd','$email','$phone');";
$result= @mysqli_query($DBConnect,$query)
Or die ("<p>2.Unable to query the table.</p>"."<p>Error code ".mysqli_errno($DBConnect). ": ".mysqli_error($DBConnect). "</p>");
}
if (mysqli_affected_rows($DBConnect) == 1) {
echo "Thank you. The registration is now complete. You may now <a href='login.php'>Log In</a> here.";
}
mysqli_close($DBConnect);
}
?>