检查MySQL数据库中现有用户的最佳方法? [英] Best way to check for existing user in mySQL database?
问题描述
我正在尝试用PHP创建用户登录/创建脚本,并且想知道在创建用户时检查用户名是否存在的最佳方法.目前,我有以下代码:
I am trying to create a user login/creation script in PHP and would like to know the best way to check if a username exists when creating a user. At the moment, I have the following code:
function createUser($uname,$pword) {
$server->connect(DB_HOST,DB_USER,DB_PASS,DB_NAME);
$this->users = $server->query("SELECT * FROM user_list");
while ($check = mysql_fetch_array($this->users) {
if ($check['uname'] == $uname) {
我不确定执行此操作的最佳逻辑.我正在考虑添加一个布尔变量来做类似的事情(在if语句之后):
What I'm not sure about is the best logic for doing this. I was thinking of adding a boolean variable to do something like (after the if statement):
$boolean = true;
}
if ($boolean) {
echo "User already exists!";
}
else {
$server->query("INSERT USER INTO TABLE");
echo "User added Successfully";
}
但这似乎效率不高-是否有更有效的方法来做到这一点?抱歉,如果有一个基本的解决方案-我是一个相对较新的PHP程序员.
But this seems a little inefficient - is there a more efficient way to do this? Sorry if this has a basic solution - I'm a relatively new PHP programmer.
推荐答案
使用WHERE
子句仅获取具有给定用户名的行:
Use the WHERE
clause to get only rows with the given user name:
"SELECT * FROM user_list WHERE uname='".$server->real_escape_string($uname)."'"
然后检查查询是否导致选择任何带有 MySQLi_Result::num_rows
的行(0或1行):
Then check if the query results in selecting any rows (either 0 or 1 row) with MySQLi_Result::num_rows
:
function createUser($uname,$pword) {
$server->connect(DB_HOST,DB_USER,DB_PASS,DB_NAME);
$result = $server->query("SELECT * FROM user_list WHERE uname='".$server->real_escape_string($uname)."'");
if ($result->num_rows() === 0) {
if ($server->query("INSERT INTO user_list (uname) VALUES ('".$server->real_escape_string($uname)."'")) {
echo "User added Successfully";
} else {
echo "Error while adding user!";
}
} else {
echo "User already exists!";
}
}
这篇关于检查MySQL数据库中现有用户的最佳方法?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!