UC知道php+mysql验证用户名
来源：百度知道 编辑：UC知道 时间：2024/07/01 01:51:59
我是新手，刚开始学php，很多地方都不懂，希望各位大侠们帮帮忙。
代码如下：
$con = mysql_connect("localhost","root","");
if (!$con){
die('Could not connect: ' . mysql_error());
}
mysql_select_db("other_webjx", $con);
$name=$_POST['name'];
$sql = "SELECT * FROM `biandan` WHERE name='$name'";
$res = mysql_query($sql);
$rows=mysql_num_rows($res);
if ($row == $name) {
输入的用户名已存在，请重新输入;
exit;
} else {
$sql = "INSERT INTO biandan (name, passwrod, email)
VALUES ('$_POST[name]','$_POST[passwrod]','$_POST[email]')";
die('Could not connect: ' . mysql_error());
}
代码如下：
$con = mysql_connect("localhost","root","");
if (!$con){
die('Could not connect: ' . mysql_error());
}
mysql_select_db("other_webjx", $con);
$name=$_POST['name'];
$sql = "SELECT * FROM `biandan` WHERE name='$name'";
$res = mysql_query($sql);
$rows=mysql_num_rows($res);
if ($row == $name) {
输入的用户名已存在，请重新输入;
exit;
} else {
$sql = "INSERT INTO biandan (name, passwrod, email)
VALUES ('$_POST[name]','$_POST[passwrod]','$_POST[email]')";
die('Could not connect: ' . mysql_error());
}
// 判断记录数，大于0就表示有这用户了
if (intval($rows) > 0) {
echo "输入的用户名已存在，请重新输入";
exit;
} else {
$sql = "INSERT INTO biandan (name, passwrod, email)
VALUES ('$_POST[name]','$_POST[passwrod]','$_POST[email]')";
mysql_query($sql) or die('Could not connect: ' . mysql_error());
}