Resolved: Yii2 How to get all values from column (DB)

Question:

I’ve been sitting for hours trying to find how to get values from table’s iab_categories column category_name. I’ve found only the way to echo all table names:

$connection = Yii::app()->db;//get connection
$dbSchema = $connection->schema;
//or $connection->getSchema();
$tableNames = $dbSchema->getTableNames();//returns array of tbl schema's
var_export($tableNames);

Can anyone help me?

Answer:

You can use query builder to do that:

$categories = (new \yii\db\Query())
    ->select(['category_name'])
    ->from('iab_categories')
    ->column();

The select() method sets what columns should be included in result. The from() method sets what table should be queried. And the column() method executes the query and return first column from result set as array.
EDIT: now, I’ve realized that even though you’ve mentioned Yii 2 in title the code you’ve included in question looks more like Yii 1.x. So there is query builder version for Yii 1.x:

$categories = Yii::app()->db->createCommand()
    ->select('category_name')
    ->from('iab_categories')
    ->queryColumn();

If you have better answer, please add a comment about this, thank you!

Resolved: Yii2 How to get all values from column (DB)

Resolved: How can I write CSS selector(s) that apply to table rows for all td elements on that row after a td with a certain class?

Resolved: How do I use SetWindowText with Unicode in Win32 using PowerShell?

Resolved: Shopware 400 Status Error “This value is too long. It should have 255 character or less.” When I Try Updating Database Table

Leave A Reply