if($method=='reg'){//注册新用户
$user=$_POST['user'];
$newpwd=md5($_POST['newpwd']);
echo "<script>alert('$user');</script>";
$sql = "select * from user where name='$user'";
$selectlao_ob=new mysql(WEB_SERVER,WEB_USER,WEB_PWD,WEB_DB,"utf8");
$result = $selectlao_ob->query($sql);
if($result==flase){//先判断有没重复的用户名,问题就是这里了,总是显示用户已存在。
$sql = "INSERT INTO `user` (`name`, `pass`) VALUES('$user', '$newpwd');";
$pwd_ob=new mysql(WEB_SERVER,WEB_USER,WEB_PWD,WEB_DB,"utf8");
$result = $pwd_ob->query($sql);
if($result==true){
echo "<script>alert('注册成功!');location.href='../index.php';</script>";
}else{
echo "<script>alert('注册失败!');history.go(-1);</script>";
}
}else{
echo "<script>alert('用户已存在!');history.go(-1);</script>";
}
}
请大家看看为什么?应该怎么改啊?
$user=$_POST['user'];
$newpwd=md5($_POST['newpwd']);
echo "<script>alert('$user');</script>";
$sql = "select * from user where name='$user'";
$selectlao_ob=new mysql(WEB_SERVER,WEB_USER,WEB_PWD,WEB_DB,"utf8");
$result = $selectlao_ob->query($sql);
if($result==flase){//先判断有没重复的用户名,问题就是这里了,总是显示用户已存在。
$sql = "INSERT INTO `user` (`name`, `pass`) VALUES('$user', '$newpwd');";
$pwd_ob=new mysql(WEB_SERVER,WEB_USER,WEB_PWD,WEB_DB,"utf8");
$result = $pwd_ob->query($sql);
if($result==true){
echo "<script>alert('注册成功!');location.href='../index.php';</script>";
}else{
echo "<script>alert('注册失败!');history.go(-1);</script>";
}
}else{
echo "<script>alert('用户已存在!');history.go(-1);</script>";
}
}
请大家看看为什么?应该怎么改啊?
部分和它的例子。
var_dump($result);
exit;
执行一下取值操作 mysql_fetch_array();看看
mysql_query() 执行一条语句 返回一个资源连接 语句错误时返回false另外你的对象不需要在同一文件中多次实例化