关于账户激活的奇葩问题,
请教大神我这段代码有什么问题,以前好好的 ,现在却出现莫名问题,编辑器是netbeans,也重新安装过.
现在运行时能执行到第二个_query函数,也就是对数据库的操作成功了,之后就跳过mysql_affected_rows()那段直接执行下面的 else {
_alert_back('非法操作');
}
if (isset($_GET['active']) && $_GET['action'] === 'ok') {
$_active = _mysql_string($_GET['active']);
if (mysql_fetch_array(_query("SELECT tg_active FROM tg_user WHERE tg_active='$_active' LIMIT 1"),MYSQL_ASSOC)) {
//将tg_active设置为actived
_query("UPDATE tg_user SET tg_active='actived' WHERE tg_active='$_active' LIMIT 1");
if (mysql_affected_rows() == 1) {
mysql_close();
_location('账户激活成功','login.php');
} else {
mysql_close();
_location('账户激活失败','register.php');
}
} else {
_alert_back('非法操作');
}
}
if (mysql_fetch_array(_query("SELECT tg_active FROM tg_user WHERE tg_active='$_active' LIMIT 1"),MYSQL_ASSOC)) {
//将tg_active设置为actived
_query("UPDATE tg_user SET tg_active='actived' WHERE tg_active='$_active' LIMIT 1");
if (mysql_affected_rows() == 1) {
mysql_close();
_location('账户激活成功','login.php');
} else {
mysql_close();
_location('账户激活失败','register.php');
}
} else {
_alert_back('非法操作');
}
已抢66305个
抢已抢36228个
抢已抢20100个
抢