yii2 - fetch data with activerecord in FETCH_KEY_PAIR array format

Question

I have table like this:

CREATE TABLE `developer` (
  `id` bigint(20) AUTO_INCREMENT,
  `name` varchar(1024) NOT NULL,
  `link` varchar(1024) NOT NULL,
  `parent` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`),
  CONSTRAINT `developer_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `developer` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB CHARSET=utf8 COLLATE=utf8_unicode_ci;

I want get only id,name in PDO::FETCH_KEY_PAIR array from this table and use:

Developer::find()->select(['id', 'name'])->asArray()->all();

But I can not get the data in PDO::FETCH_KEY_PAIR format
how can i do it?

vitalik_74 · Accepted Answer · 2015-04-11 18:47:01Z

3

You may use ArrayHelper for generate array with key is id field and value is name field. Use like that:

ArrayHelper::map(Developer::find()->select(['id', 'name'])->asArray()->all(), 'id', 'name')

For more http://www.yiiframework.com/doc-2.0/guide-helper-array.html#building-maps

Edit: You may use createCommand, like that:

$res = Yii::$app->db->createCommand('SELECT id, name FROM developer')->queryAll(PDO::FETCH_KEY_PAIR);

But if you want use ActiveRecord see in https://github.com/yiisoft/yii2/blob/master/framework/db/Query.php#L204 In this line not set fetchMode.

You may take this class Query, ActiveRecord and change his. And extends your Develop model from new class.

edited Apr 11, 2015 at 18:47

answered Apr 11, 2015 at 16:53

vitalik_74

4,6112 gold badges21 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Death Programmer Over a year ago

i know it and this is not solution , maybe yii2 have another option to choose fetch method.

Ashish Pathak · Accepted Answer · 2016-03-08 11:26:28Z

1

add code in controller

public function actionViewdata() {
    $model = new Contact();
    $data = $model::find()
            // ->where(['id' > 0])
            //->orderBy('age')
            ->all();
    return $this->render('viewdata', array(
                'model' => $model,
                'contactdata' => $data,
    ));
}

now in view(viewdata.php)

echo'<pre>';
print_r($contactdata);

answered Mar 8, 2016 at 11:26

Ashish Pathak

8348 silver badges16 bronze badges

Collectives™ on Stack Overflow

yii2 - fetch data with activerecord in FETCH_KEY_PAIR array format

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related