在yii如何使用电子邮件字段查找用户的ID(In yii how to find user's id by using email field)

在yii如何使用电子邮件字段查找用户的ID(In yii how to find user's id by using email field)

在yii我正在开发function.I检查用户输入的电子邮件ID是否它存在于数据库中的查询 -

$record=User1::model()->find(array( 'select'=>'primaryEmail', 'condition'=>'PrimaryEmail=:email', 'params'=>array(':email'=>$_POST['email'])) );

如果记录存在，那么我想要检索该记录的用户标识和SecurityQuestionId。 那么如何编写搜索查询。

In yii i am developing function.I am checking user entered email id whether it exists in database by query-

$record=User1::model()->find(array( 'select'=>'primaryEmail', 'condition'=>'PrimaryEmail=:email', 'params'=>array(':email'=>$_POST['email'])) );

if record exists then i want to retrieve that record's userid and SecurityQuestionId. So how to write search query.

最满意答案

$record=User1::model()->find(array( 'select'=>'id, securityQuestionId, primaryEmail', 'condition'=>'primaryEmail=:email', 'params'=>array(':email'=>$_POST['email'])) );

要不就

$record = User1::model()->findByAttributes(array('primaryEmail' => $_POST['email'])); $record=User1::model()->find(array( 'select'=>'id, securityQuestionId, primaryEmail', 'condition'=>'primaryEmail=:email', 'params'=>array(':email'=>$_POST['email'])) );

or just

$record = User1::model()->findByAttributes(array('primaryEmail' => $_POST['email']));在yii如何使用电子邮件字段查找用户的ID(In yii how to find user's id by using email field)

在yii我正在开发function.I检查用户输入的电子邮件ID是否它存在于数据库中的查询 -

$record=User1::model()->find(array( 'select'=>'primaryEmail', 'condition'=>'PrimaryEmail=:email', 'params'=>array(':email'=>$_POST['email'])) );

如果记录存在，那么我想要检索该记录的用户标识和SecurityQuestionId。 那么如何编写搜索查询。

In yii i am developing function.I am checking user entered email id whether it exists in database by query-

$record=User1::model()->find(array( 'select'=>'primaryEmail', 'condition'=>'PrimaryEmail=:email', 'params'=>array(':email'=>$_POST['email'])) );

if record exists then i want to retrieve that record's userid and SecurityQuestionId. So how to write search query.

最满意答案

$record=User1::model()->find(array( 'select'=>'id, securityQuestionId, primaryEmail', 'condition'=>'primaryEmail=:email', 'params'=>array(':email'=>$_POST['email'])) );

要不就

$record = User1::model()->findByAttributes(array('primaryEmail' => $_POST['email'])); $record=User1::model()->find(array( 'select'=>'id, securityQuestionId, primaryEmail', 'condition'=>'primaryEmail=:email', 'params'=>array(':email'=>$_POST['email'])) );

or just

$record = User1::model()->findByAttributes(array('primaryEmail' => $_POST['email']));