/
registration.php
94 lines (78 loc) · 4.22 KB
/
registration.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
<?php include "includes/header.php"; ?>
<!-- Navigation -->
<?php include "includes/navigation.php"; ?>
<?php
if(isset($_POST['submit'])){
$username = $_POST['username'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$password = $_POST['password'];
if(!empty($username) && !empty($email) && !empty($password)){
$username = mysqli_real_escape_string($connection,$username);
$firstname = mysqli_real_escape_string($connection,$firstname);
$lastname = mysqli_real_escape_string($connection,$lastname);
$email = mysqli_real_escape_string($connection,$email);
$password = mysqli_real_escape_string($connection,$password);
$password = password_hash($password, PASSWORD_BCRYPT, array('cost' => 12));
// $query = "INSERT INTO users (user_role,username,user_firstname,user_lastname,user_email,user_password) ";
// $query .= "VALUES( 'subscriber','{$username}','{$firstname}','{$lastname}','{$email}','{$password}' )";
// $register_user_query = mysqli_query($connection,$query);
// if(!$register_user_query){
// die("QUERY FAILED" . mysqli_error($connection) . ' ' . mysqli_errno($connection));
// }
$query = "INSERT INTO users (user_role,username,user_firstname,user_lastname,user_email,user_password) ";
$query .= "VALUES( 'subscriber',?,?,?,?,?)";
$stmt = mysqli_prepare($connection,$query);
mysqli_stmt_bind_param($stmt,"sssss",$username,$firstname,$lastname,$email,$password);
mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);
if(!$stmt){
die("QUERY FAILED" . mysqli_error($connection) . ' ' . mysqli_errno($connection));
}
$message = "Your Registration has been submitted";
}else{
$message = "fields cannot be empty";
}
}else{
$message = "";
}
?>
<!-- Page Content -->
<div class="container">
<section id="login">
<div class="row justify-content-center align-items-center">
<div class="col-sm-5 col-sm-offset-5">
<div class="form-wrap">
<h3 class="text-center mt-3 mb-3"><i class="fas fa-portrait fa-3x"></i></h3>
<form role="form" action="registration.php" method="post" id="login-form" autocomplete="off">
<h6><?php echo $message; ?></h6>
<div class="form-group">
<label for="username" class="sr-only">username</label>
<input type="text" name="username" id="username" class="form-control" placeholder="Enter Desired Username">
</div>
<div class="form-group">
<label for="firstname" class="sr-only">Firstname</label>
<input type="text" name="firstname" id="firstname" class="form-control" placeholder="Enter Your Firstname">
</div>
<div class="form-group">
<label for="lastname" class="sr-only">Lastname</label>
<input type="text" name="lastname" id="lastname" class="form-control" placeholder="Enter Your Lastname">
</div>
<div class="form-group">
<label for="email" class="sr-only">Email</label>
<input type="email" name="email" id="email" class="form-control" placeholder="somebody@example.com">
</div>
<div class="form-group">
<label for="password" class="sr-only">Password</label>
<input type="password" name="password" id="key" class="form-control" placeholder="Password">
</div>
<input type="submit" name="submit" id="btn-login" class="btn btn-secondary btn-lg btn-block" value="Register">
</form>
</div>
</div> <!-- /.col-sm-5 -->
</div> <!-- /.row -->
</section>
<hr>
<?php include "includes/footer.php";?>
</div> <!-- /.container -->