YII learning, yii_PHP tutorial

YII learning, yii

CONFIG

tablePrefix sets the table prefix

MODEL

Set the table associated with MODEL

public function tableName(){

return {{%table_name}} table prefix plus table name format

}

Pagination: use yiidataPagination; $Page = new Pagination(['totalCount' => Total number of items,'pageSize'=>Number displayed on each page]); ​ Query: There must be a model corresponding to the database name Model name::find()->where(condition['status'=>1]); ​                   $tombList
->offset($Page->offset paging)
->limit($Page->limit number of pages)
->all(); ->all();                                         Search all ->one(); Query one ->count(); Query quantity ->average(field); Query the average ->min(field); Query the minimum value ->max(field); Query the maximum value ->scalar(); Query the value of the first row and column ->column(); Query the value of the first column of all results ->each(quantity); Repeated query results to deal with memory overflow delete Yii::$app->db->createCommand()->delete('table name','condition')->execute(); Revise Yii::$app->db->createCommand()->update('table name', modify field ['status'=>1], 'condition')->execute(); Add to Yii::$app->db->createCommand()->insert('table name', data)->execute();

http://www.bkjia.com/PHPjc/981701.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/981701.htmlTechArticleYII learning, yii CONFIG tablePrefix Set the table prefix MODEL Set the table associated with MODEL public function tableName(){ return { {%table_name}} Table prefix plus table name format} Pagination: use yii...