/
handle_add_user.php
39 lines (39 loc) · 1.36 KB
/
handle_add_user.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
<?php
require_once('./conn.php');
$set_user = $_POST['username'];
$nickname = $_POST['nickname'];
$set_password = $_POST['password'];
$password2 = $_POST['password2'];
// 欄位空白檢查
if (empty($set_user) || empty($nickname) || empty($set_password) || empty($password2)) {
die('您有欄位未完成,請檢查資料');
}
// 密碼設定檢查
if ($set_password !== $password2) {
echo "<script>alert('請確認兩次密碼輸入均相同')</script>";
die('請返回上一頁');
}
// 帳號重複檢查
$sql_account_check = "SELECT * FROM yoding_users
WHERE username = ?";
$stmt_check = $conn->prepare($sql_account_check);
$stmt_check->bind_param("s", $set_user);
$stmt_check->execute();
$result_check = $stmt_check->get_result();
if($result_check->num_rows > 0) {
echo "<script>alert('此帳號已註冊')</script>";
die('請返回上一頁');
} else {
$hashed_password = password_hash($set_password, PASSWORD_DEFAULT);
}
// 正式建置會員資料
$sql_account_set = "INSERT INTO yoding_users(username, nickname, password) VALUES(?, ?, ?)";
$stmt_set= $conn->prepare($sql_account_set);
$stmt_set->bind_param("sss", $set_user, $nickname, $hashed_password);
$stmt_set->execute();
if($stmt_set->execute()) {
header('Location: ./login.php');
} else {
echo "Failed. " . $conn->error;
}
?>