我的注册不再有效,但我没有对它做任何更改,为什么会这样?我所做的唯一更改是进入数据库,更改为1个用户的id,并删除2个其他用户。下面是我的代码:
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.';
}
}
} 发布于 2011-08-11 06:05:14
不确定它为什么起作用或者是什么改变了。但据我所知,您不能像这里那样在变量数据周围的查询中使用双引号:
$query = 'SELECT * FROM users WHERE email = "' . mysql_real_escape_string($email) . '" LIMIT 1';它应该是:
$query = "SELECT * FROM users WHERE email = '" . mysql_real_escape_string($email) . "' LIMIT 1";和你的其他查询一样,如果你有一些错误正在显示,如果有错误,还有什么也会有帮助:
$result = mysql_query($queryuser) or trigger_error('SQL Error on User Query: ' . mysql_error());它还应该告诉您错误是什么/曾经是什么。由于display_errors使用trigger_error,因此通过将其设置为off,可以很容易地将其关闭给最终用户。
https://stackoverflow.com/questions/7018408
复制相似问题