CODEWITHSUNDEEP
sqlyii
Shilpa Kirad
Shilpa Kirad

Reputation: 219

In yii how to find user's id by using email field

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.

Upvotes: 2

Views: 3581

Answers (1)

driver_by
driver_by

Reputation: 1705

$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']));

Upvotes: 6

Related Questions