<?php$dbhost = 'localhost';$dbuser = 'root';$dbpw = 'root';$dbcharset = 'gb2312';$tablepre = 'nu_';//連接MySQL數(shù)據(jù)庫$link = mysql_connect($dbhost,$dbuser,$dbpw);if(!$link){echo "數(shù)據(jù)庫連接失敗"."</br>";die();}mysql_query("set names ".$dbcharset,$link);//定位數(shù)據(jù)庫if(!mysql_select_db($dbname,$link)){echo "無法定位數(shù)據(jù)庫"."</br>";mysql_close($link);die();}//檢查相關注冊信息是否已經(jīng)被占用$query="select * from ".$tablepre."common_members"." where username ='".$_POST['reg_username']."'";$result=mysql_query($query,$link);if(mysql_fetch_object($result)){echo '<script type="text/javascript">alert("用戶名已被占用 ,請重新輸入！");location.replace("../reg/index.php");</script>';die();}?>
2 回答
繁華開滿天機
TA貢獻1816條經(jīng)驗 獲得超4個贊
用mysql_num_rows()吧，判斷>0則說明注冊了的，否則就沒注冊。mysql_fetch_object()一般是用來 輸出 內(nèi)容的，而不是進行判斷的。-----------------------<?php
mysql_connect("hostname", "user", "password");
mysql_select_db("mydb");
$result = mysql_query("select * from mytable");
while ($row = mysql_fetch_object($result)) {
echo $row->user_id;
echo $row->fullname;
}
mysql_free_result($result);
?>
蝴蝶刀刀
TA貢獻1801條經(jīng)驗 獲得超8個贊
不要用mysql_fetch_object()這個函數(shù)來判斷，這個返回來的是個數(shù)組；一般情況下是這么來判斷的：$query="select * from ".$tablepre."common_members"." where username ='".$_POST['reg_username']."'";$result=mysql_query($query,$link);$num = mysql_num_rows($result); //取得結(jié)果集中行的數(shù)目if($num){echo '<script type="text/javascript">alert("用戶名已被占用 ,請重新輸入！");location.replace("../reg/index.php");</script>';die();}
添加回答
舉報
0/150
提交
取消