-
Notifications
You must be signed in to change notification settings - Fork 0
/
register.php
executable file
·106 lines (87 loc) · 2.48 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
102
103
104
105
106
<?php
/**
* Created by PhpStorm.
* User: kyle
* Date: 10/29/15
* Time: 12:32 PM
*/
?>
<?php
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "personal_finance";
$todaysdate = date('Y-m-d');
session_start();
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $conn->prepare("INSERT INTO user (user_fname, user_lname, user_username, user_password, user_date, user_email) VALUES (:fname, :lname, :usersname, :userspassword, :entdate, :usersemail)");
$stmt->bindParam(':fname', $fname);
$stmt->bindParam(':lname', $lname);
$stmt->bindParam(':usersname', $usersname);
$stmt->bindParam(':userspassword', $userspassword);
$stmt->bindParam(':entdate', $entdate);
$stmt->bindParam(':usersemail', $usersemail);
if ($_SERVER["REQUEST_METHOD"] == "POST") {
if (empty($_POST["user_fname"])) {
header("Location: ./login.php");
exit;
}
else{
$fname = cleanuserdata($_POST["user_fname"]);
}
if (empty($_POST["user_lname"])) {
header("Location: ./login.php");
exit;
}
else{
$lname = cleanuserdata($_POST["user_lname"]);
}
if (empty($_POST["user_lname"])) {
header("Location: ./login.php");
exit;
}
else{
$lname = cleanuserdata($_POST["user_lname"]);
}
if (empty($_POST["user_username"])) {
header("Location: ./login.php");
exit;
}
else{
$usersname = cleanuserdata($_POST["user_username"]);
}
if (empty($_POST["user_password"])) {
header("Location: ./login.php");
exit;
}
else{
$userspassword = cleanuserdata($_POST["user_password"]);
}
if (empty($_POST["user_email"])) {
header("Location: ./login.php");
exit;
}
else{
$usersemail = cleanuserdata($_POST["user_email"]);
}
}
$entdate = $todaysdate;
$stmt->execute();
echo "new User Created ". $usersname;
$_SESSION["username"] = $usersname;
}
catch(PDOException $e) {
echo "Error: " . $e->getMessage();
}
$conn = null;
?>
<?php
function cleanuserdata($data) {
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
?>