[FIXED] how to check, if authenticated user in array from db

Issue

In my DB I have a project table which has

  project
  id | title | users |
  1  | First | 1,2,3 |
  2  | Second| 2,6   |

how can I check Yii::app()->user->id contained in users field? I want to check, if true then show row in gridview.

Which $criteria must I use?

Solution

Use LIKE query for checking your user id exist or not in users column.

$user = Yii::app()->user->id;
$result = Yii::app()->db->createCommand('SELECT * FROM project WHERE users  LIKE "%'.$user.'%"')->queryAll();
if(count($result)){
    //Your other scripts to show in grid view
}

If you have a Project model class then you also can use:

$user = Yii::app()->user->id;
$criteria = new CDbCriteria;
$criteria->select = '*';
$criteria->compare('t.users', $user, true);
$results = Project::model()->findAll($criteria);

Answered By - alamincse07