首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >PHP注册表单正常工作,现在不能工作,因为我没有做任何更改

问PHP注册表单正常工作,现在不能工作,因为我没有做任何更改
EN

Stack Overflow用户
提问于 2011-08-11 06:00:14
回答 1查看 162关注 0票数 0

我的注册不再有效,但我没有对它做任何更改,为什么会这样?我所做的唯一更改是进入数据库,更改为1个用户的id,并删除2个其他用户。下面是我的代码:

代码语言:javascript
复制
include 'scripts/global.php';

// Register attempt  
if(isset($_POST['registerSubmit']) && $_POST['registerSubmit'] == 'true'){
$username = trim($_POST['username']);  
$email = trim($_POST['email']);  
$password = trim($_POST['password']);  
$confirmPassword    = trim($_POST['confirmPassword']);  

if(!preg_match("/^[_\.0-9a-zA-Z-]+@([0-9a-zA-Z][0-9a-zA-Z-]+\.)+[a-zA-Z]{2,6}$/i", $email))  
    $errors['email'] = 'Your email address is invalid.';  

if(strlen($password) < 6)  
    $errors['password'] = 'Your password must be greater than 6 characters.';  

if($password != $confirmPassword)  
    $errors['confirmPassword'] = 'Your passwords did not match.';  

// Check to see if we have a user registered with this email address already  
$query = 'SELECT * FROM users WHERE email = "' . mysql_real_escape_string($email) . '" LIMIT 1';  
$result = mysql_query($query);  
if(mysql_num_rows($result) == 1)  
    $errors['email'] = 'This email address already exists.';

//Check if username is already taken
     $queryuser = 'SELECT * FROM users WHERE username = "' . mysql_real_escape_string($username) . '" LIMIT 1';  
$result = mysql_query($queryuser);  
if(mysql_num_rows($result) == 1)  
    $errors['username'] = 'This username is already taken.';



if(!$errors){  
    $queryFinal = 'INSERT INTO users SET email = "' . mysql_real_escape_string($email) . '", 
                                                                    password = MD5("' . mysql_real_escape_string($password) . '"), 
                                                                    date_registered = "' . date('Y-m-d H:i:s') . '",
                                                                    username = "' . mysql_real_escape_string($username) . '"';

    if(mysql_query($queryFinal)){  
        $success['register'] = 'Thank you for registering. You can now log in on the right.';  
    }else{  
        $errors['register'] = 'There was a problem registering you. Please check your details and try again.';  
    }  
}  

}  
EN

回答 1

Stack Overflow用户

发布于 2011-08-11 06:05:14

不确定它为什么起作用或者是什么改变了。但据我所知,您不能像这里那样在变量数据周围的查询中使用双引号:

代码语言:javascript
复制
$query = 'SELECT * FROM users WHERE email = "' . mysql_real_escape_string($email) . '" LIMIT 1';

它应该是:

代码语言:javascript
复制
$query = "SELECT * FROM users WHERE email = '" . mysql_real_escape_string($email) . "' LIMIT 1";

和你的其他查询一样,如果你有一些错误正在显示,如果有错误,还有什么也会有帮助:

代码语言:javascript
复制
$result = mysql_query($queryuser) or trigger_error('SQL Error on User Query: ' . mysql_error());

它还应该告诉您错误是什么/曾经是什么。由于display_errors使用trigger_error,因此通过将其设置为off,可以很容易地将其关闭给最终用户。

票数 2
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/7018408

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档