用户注册时,先检查有没有重复的用户名的作用//链接数据库,没问题的$con=mysql_connect("localhost","admin","12345");if(!$con){die('Couldnotconnect:'.mysql_error());}mysql_s...
用户注册时,先检查有没有重复的用户名的作用
//链接数据库,没问题的
$con = mysql_connect("localhost","admin","12345");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
//!!!关键是这一句,这样写不行阿,我换了很多写法也不行,请高手赐教阿
$result = mysql_query("SELECT * FROM users where UserName=’$_POST["username"]‘");
if(!$result)//写入数据库
else //已经被注册
还是有问题,大虾可否告知(给我发邮件也行,请)
$con = mysql_connect("localhost","root","xiang");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
$result = mysql_query("SELECT * FROM users where UserName='{$_POST['username']}'");
if(!$result)
{
$sql="INSERT INTO users (UserName, password)
VALUES
('$_POST[username]','$_POST[password]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "One record added";
}
else
echo "There has aleradly registed! ";
mysql_close($con)
?>
展开