我使用 PHP 進行了表單驗證。如果發生錯誤，錯誤消息將顯示在每個輸入列周圍。我想檢查一下這個郵箱是否被使用過。因此，我使用錯誤代碼來定義是否使用輸入電子郵件地址，然后顯示“電子郵件已被使用”的錯誤消息。然而，結果變成了我輸入的任何內容，它只顯示“電子郵件已被使用”。有人可以幫我解決這個問題嗎？謝謝！<?php require_once('./conn.php'); $errorMsgs = array('nickname'=>'', 'email'=>'', 'password'=>''); if(isset($_POST['submit'])) { if(empty($_POST['nickname'])) { $errorMsgs['nickname'] = "Please enter your nickname"; } $email = $_POST['email']; $password = $_POST['password']; // checking the email is valid or empty if(empty($_POST['email'])) { $errorMsgs['email'] = "Please enter your email"; } else { if(!filter_var($email, FILTER_VALIDATE_EMAIL)) { $errorMsgs['email'] = "Please enter a valid email"; } } $errorCode = $conn->errno; if($errorCode === 1062) { $errorMsgs['email'] = "The email has been used"; } // checking the password is valid or empty if(empty($_POST['password'])) { $errorMsgs['password'] = "Please enter your password"; } else { if(!preg_match('/\w{8,}/', $password)) { $errorMsgs['password'] = "Please enter at least 8 characters"; } } if(!array_filter($errorMsgs)) { $sql = sprintf("INSERT INTO member (nickname, email, password) values ('%s', '%s', '%s')", $_POST['nickname'], $_POST['email'],$_POST['password']); $result = $conn->query($sql); if($result) { header("Location: index.php"); } }}?>
1 回答
慕蓋茨4494581
TA貢獻1850條經驗 獲得超11個贊
您必須檢查該電子郵件是否存在于您的用戶表中。像這樣的東西。
<?php
require_once('./conn.php');
$errorMsgs = array('nickname'=>'', 'email'=>'', 'password'=>'');
if(isset($_POST['submit'])) {
if(empty($_POST['nickname'])) {
$errorMsgs['nickname'] = "Please enter your nickname";
}
$email = $_POST['email'];
$password = $_POST['password'];
// checking the email is valid or empty
if(empty($_POST['email'])) {
$errorMsgs['email'] = "Please enter your email";
} else {
if(!filter_var($email, FILTER_VALIDATE_EMAIL)) {
$errorMsgs['email'] = "Please enter a valid email";
}
else{
//you should use sql parameter binding
$email = $_POST['email'];
$checkDuplicate= $conn->query("SELECT email FROM user_table where email = '$email'");
if(!empty($checkDuplicate)) {
$errorMsgs['email'] = "The email has been used";
}
}
}
// checking the password is valid or empty
if(empty($_POST['password'])) {
$errorMsgs['password'] = "Please enter your password";
} else {
if(!preg_match('/\w{8,}/', $password)) {
$errorMsgs['password'] = "Please enter at least 8 characters";
}
}
if(empty($errorMsgs)) { //you need to check if there's any error
$sql = sprintf("INSERT INTO member (nickname, email, password) values ('%s', '%s', '%s')", $_POST['nickname'], $_POST['email'],$_POST['password']);
$result = $conn->query($sql);
if($result) {
header("Location: index.php");
}
}
}
?>
- 1 回答
- 0 關注
- 127 瀏覽
添加回答
舉報
0/150
提交
取消