Example #1
0
 /**
  * @param string|\yii\db\ActiveQuery $sql
  * @param array $params
  * @return array
  */
 public static function queryHash($sql, $params = [])
 {
     if ($sql instanceof ActiveQuery) {
         $query = $sql->asArray()->all();
     } else {
         $query = \Yii::$app->db->createCommand($sql)->query($params);
     }
     $result = [];
     foreach ($query as $row) {
         $row = array_values($row);
         $result[$row[0]] = $row[1];
     }
     return $result;
 }