getting an array instead of string from a query yii2

Question

the task is to save the $model->image with row id in it. to anticipate the next autoincrement id i use the query below. mysql returns right result, but when i try to save this query result in model it saves it like 'Array' string. For example : article_Array_1516534305.png instead of article_13_1516534305.png

i tried to use array_shift() function, but result is the same

        $connection = Yii::$app->getDb();
        $dbName = $this->getDsnAttribute('dbname', Yii::$app->getDb()->dsn);

        $query = new Query;
        $query->select('AUTO_INCREMENT')
            ->from('information_schema.TABLES')
            ->where("TABLE_SCHEMA = '".$dbName."'")
            ->andWhere("TABLE_NAME = '".$this->tableName()."'");
        $id = $query->one();

        $this->image = 'article_'.$id.'_'.time(). '.' . $image->extension;

ScaisEdge · Accepted Answer · 2018-01-21 12:11:31Z

3

With $query->one() you get a single model

If you need only the column value you should use scalar()

$query->scalar();

http://www.yiiframework.com/doc-2.0/guide-db-query-builder.html

http://www.yiiframework.com/doc-2.0/yii-db-query.html#scalar()-detail

or if you want the model however you can use

$id = $query->one(); 
$id = $id['AUTO_INCREMENT'];

edited Jan 21, 2018 at 12:11

answered Jan 21, 2018 at 12:04

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

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

1 Comment

ScaisEdge Over a year ago

you arwe welcome .. anyway answer updated with the access to the model column too..

Yury · Accepted Answer · 2018-01-21 12:07:14Z

0

the problem was that i had associated array

$id = $query->one(); $id = $id['AUTO_INCREMENT']; now it works

answered Jan 21, 2018 at 12:07

Yury

237 bronze badges

Collectives™ on Stack Overflow

getting an array instead of string from a query yii2

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