-
Notifications
You must be signed in to change notification settings - Fork 0
/
signupdbh.php
65 lines (57 loc) · 1.96 KB
/
signupdbh.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
<?php
include 'dbh.php';
if(isset($_POST['submitbtn']))
{
$name=mysqli_real_escape_string($conn,$_POST['user_name']);
$email=mysqli_real_escape_string($conn,$_POST['user_email']);
$pwd=mysqli_real_escape_string($conn,$_POST['user_pwd']);
if( empty($name) || empty($email) || empty($pwd))
{
header("Location: signup?required fields are empty");
exit();
}
else
{
if(!preg_match("/^[a-zA-Z]*$/", $name))
{
header("Location: signup?required fields are invalid");
exit();
}
else{
$sql="SELECT * FROM users WHERE user_name='$name'";
$res=mysqli_query($conn,$sql);
$resrows=mysqli_num_rows($res);
if($resrows>=1)
{
header("Location: signup?username already taken");
exit();
}
else
{
if(!filter_var($email,FILTER_VALIDATE_EMAIL))
{
header("Location: signup?required fields are invalid");
exit();
}
else
{
$hashingPWD=password_hash($pwd,PASSWORD_DEFAULT);
$finalquery="INSERT INTO users (user_name,user_email,user_pwd,flags) VALUES ('$name','$email','$hashingPWD',0);";
mysqli_query($conn,$finalquery);
header("Location: signup?signedup succesfully");
if(!empty($_POST['prevbtn']))
{
header("Location: home?signedup succesfully");
exit();
}
}
}
}
}
}
else
{
header("Location: signup?please register to login");
exit();
}
?>