mysql 插入前检查_php – 在插入[mysql_errno()]之前检查预先存在的记录的最快方法...

我的问题将使用电子邮件作为示例,但这可以适用于任何事情.

通常在注册新用户之前(包括插入他/她的电子邮件),我检查他/她的电子邮件是否已存在于DB中,如下所示：

$result = mysql_query("SELECT * FROM Users WHERE email = '".mysql_real_escape_string($email)"';");

if(!$result)

{

die(mysql_error());

}

if(mysql_num_rows($result) > 0)

{

die('

Email already in DB. Recover Email

');

}

else

{

//insert new user data into Users table

}

既然我已经将我的Users表中的电子邮件字段限制为UNIQUE,那么首先尝试插入是否会更快,如果失败,请检查错误？像这样的东西：

$result = mysql_query(...);//insert new user data into Users table

if(!$result)

{

if(mysql_errno()==$insert_unique_error)

{

$error = '

Email already in DB. Recover Email

';

}

else

{

$error = mysql_error();

}

die($die_str);

}

问题是我不知道$insert_unique_error应该是什么.这些是唯一的错误代码I could find：

The first two characters of an SQLSTATE value indicate the error class:

Class = ’00’ indicates success.

Class = ’01’ indicates a warning.

Class = ’02’ indicates “not found.” This is relevant within the context of cursors and is used to control what happens when a cursor reaches the end of a data set. This condition also occurs for SELECT … INTO var_list statements that retrieve no rows.

Class > ’02’ indicates an exception.