-
Notifications
You must be signed in to change notification settings - Fork 2
/
create_account.php
91 lines (82 loc) · 3.89 KB
/
create_account.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
<?php
session_start();
//if($_SESSION['login'] == 'admin'){
?>
<!DOCTYPE html>
<html>
<head>
<title>Register | WassUp!</title>
<link rel="shortcut icon" href="https://imgur.com/G4KMHP3.png" type="image/x-icon" />
<link href='https://fonts.googleapis.com/css?family=Montserrat' rel='stylesheet'>
<link rel="stylesheet" href="css/create_account.css">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
<script src="https://code.jquery.com/jquery-3.3.1.min.js"></script>
</head>
<body>
<ul class="text-animation hidden" onclick = "javascript:window.location.href='index.php'">
<li>R</li>
<li>e</li>
<li>g</li>
<li>i</li>
<li>s</li>
<li>t</li>
<li>e</li>
<li>r</li>
<li>!</li>
</ul>
<div class="box">
<form method="POST">
<input type = "text" name = "id" required = "true" placeholder="Enter Your ID">
<input type = "password" name = "pw" required = "true" placeholder="Enter Your Password">
<input type ="text" name = "nkn" required = "true" placeholder="Enter Your Nickname">
<a class="gender">Gender : </a>
<input type = "radio" name = "sex" required = "true" value="male"><a class="options">Male</a>
<input type = "radio" name = "sex" value="female"><a class="options">Female</a>
<input type = "radio" name = "sex" value="Others"><a class="options">Others</a><br><br>
<h2>What is your most favorite animal ?</h2>
<input type = "text" name = "security" required = "true" placeholder="Most favorite animal"><br>
<input type = "submit" value ="Register">
</form>
</div>
<script type="text/javascript">
$(function(){
setTimeout(function(){
$('.text-animation').removeClass('hidden');
}, 500);
});
</script>
</body>
</html>
<?php
require_once('login.php');
$dsn = 'mysql:host=localhost;dbname=wassup';
$dbh = new PDO($dsn,$CFG['username'],$CFG['pw']);
if(empty(@$_POST['id']) == false && empty(@$_POST['pw']) == false && empty(@$_POST['nkn']) == false && empty(@$_POST['sex']) == false && empty(@$_POST['security']) == false){
$sth2 = $dbh->prepare('select * from users where id = ? ;');
$sth2->execute(array(@$_POST['id']));
$result = $sth2->fetch(PDO::FETCH_ASSOC);
if($result['id'] != $_POST['id']){
$sth = $dbh->prepare('insert into users (id,pw,name,gender,problem) values (?,?,?,?,?) ;');
$hashed_pw = md5(@$_POST['pw']); //hashing pw
$hashed_security = md5(@$_POST['security']); //hashing security
$sth->execute(array(@$_POST['id'],$hashed_pw,@$_POST['nkn'],@$_POST['sex'],$hashed_security));
if(isset($_POST['id'])){
$inst = 'create table if not exists '.htmlentities($_POST['id']).'_list (list_name VARCHAR(50), CONSTRAINT list_unique UNIQUE (list_name));';
$sth = $dbh->prepare($inst);
$sth->execute();
}
echo "<script>alert('Registration SUCCESS!')</script>";
echo "<script type='text/javascript'>";
echo "window.location.href='index.php'";
echo "</script>";
}
else{
echo "<script>alert('Duplicate ID!')</script>";
echo "<script type='text/javascript'>";
echo "window.location.href='create_account.php'";
echo "</script>";
}
}
?>