[SOLVED]User Login With DB

[michael_diamond]

include(Employee.php): failed to open stream: No such file or directory

(/home/mystuff/frameworks/yii/framework/YiiBase.php:432)

I have tried everything and I am still getting this error

[manojdhiman (Manoj)]

file employee.php not found . this error is coming when i am using this code , please help i am new to yii , I want to login from database

include(Employee.php): failed to open stream: No such file or directory

(/home/mystuff/frameworks/yii/framework/YiiBase.php:432)

[knehcu (Huseinazmi)]

hi mr. kiran, i got this error:

Property "CWebUser.userType" is not defined.

i did debug, and assume maybe it comes from the accessRules function in my controllers.

array('allow', // allow admin user (type 1) to perform 'admin' and 'delete' actions

 'actions'=>array('admin','delete'),                                

 'expression'=>'(Yii::app()->user->userType == 1)'                                

),

what should i do mr. kiran?

thanks in advance…

[imaminul]

Hi , refer following steps.

step : 1

first you have to override id using getId() function , I post here working code of UserIdentity ,

class UserIdentity extends CUserIdentity

{

   private $_id;

   public function authenticate()

   {

       $record=Employee::model()->findByAttributes(array('E_EMAIL'=>$this->username));  // here I use Email as user name which comes from database

       if($record===null)

               {

                       $this->_id='user Null';

         			   $this->errorCode=self::ERROR_USERNAME_INVALID;

               }

       else if($record->E_PASSWORD!==$this->password)            // here I compare db password with passwod field

               {        $this->_id=$this->username;

                       $this->errorCode=self::ERROR_PASSWORD_INVALID;

               }

	 else if($record['E_STATUS']!=='Active')                //  here I check status as Active in db

               {        

			   		$err = "You have been Inactive by Admin.";

			        $this->errorCode = $err;

               }

	

       else

       {  

          $this->_id=$record['E_NAME'];

	   $this->setState('title', $record['E_NAME']);

           $this->errorCode=self::ERROR_NONE;


       }

       return !$this->errorCode;

   }


   public function getId()       //  override Id

   {

       return $this->_id;

   }

}

step : 2

here is my loginForm function ,

public function authenticate($attribute,$params)

	{

		if(!$this->hasErrors())

		{

			$this->_identity=new UserIdentity($this->username,$this->password);

			if(!$this->_identity->authenticate())

				$this->addError('password','Incorrect username or password.');

		}

	}

step : 3

finaly i use controller as ,

public function actionLogin()

	{

		$model=new LoginForm;

		

		if(isset($_POST['ajax']) && $_POST['ajax']==='login-form')

		{

			echo CActiveForm::validate($model);

			Yii::app()->end();

		}


		if(isset($_POST['LoginForm']))

		{

		

			$model->attributes=$_POST['LoginForm'];

			

			// validate user input and redirect to the previous page if valid

			if($model->validate() && $model->login())

			{

                          $this->redirect(array("page_after_login"));

			

			}

				

		}

                	$this->render('login',array('model'=>$model));

}

[imaminul]

Thanks. It works fine