Breaking News: Grepper is joining You.com. Read the official announcement!

select model yii

Gabriel Ramirez answered on July 20, 2022 Popularity 3/10 Helpfulness 2/10

answer select model yii

select model yii

Comment

// return a single customer whose ID is 123
// SELECT * FROM `customer` WHERE `id` = 123
$customer = Customer::find()
    ->where(['id' => 123])
    ->one();

// return all active customers and order them by their IDs
// SELECT * FROM `customer` WHERE `status` = 1 ORDER BY `id`
$customers = Customer::find()
    ->where(['status' => Customer::STATUS_ACTIVE])
    ->orderBy('id')
    ->all();

// return the number of active customers
// SELECT COUNT(*) FROM `customer` WHERE `status` = 1
$count = Customer::find()
    ->where(['status' => Customer::STATUS_ACTIVE])
    ->count();

// return all customers in an array indexed by customer IDs
// SELECT * FROM `customer`
$customers = Customer::find()
    ->indexBy('id')
    ->all();

Popularity 3/10 Helpfulness 2/10 Language whatever

Source: www.yiiframework.com

Tags: model select whatever yii

Link to this answer
Share Copy Link