PHP zantonijevic\documents\models Category::findBySql Examples

Example #1

File: Document.php Project: zivoradantonijevic/documents

 public function getCategoriesSelect($id)
 {
     $sql = 'SELECT id,title FROM {{%document_category}} WHERE published = 1 AND id !=' . $id;
     $categories = Category::findBySql($sql)->asArray()->all();
     $array = [];
     foreach ($categories as $category) {
         $array[$category['id']] = $category['title'];
     }
     return $array;
 }