5 min read

Yii Rights: Get all assigned roles of a user

Last modified June 04, 2014


$command = Yii::app()->db->createCommand("SELECT * FROM `authassignment` WHERE userid={$user_id}");
$results = $command->queryAll();
$roles = array();
foreach ($results as $result)
{
    $roles[] = $result['itemname'];
}
$this->setState('roles', $roles);