Yii2.0：數據庫操作增刪改查詳細介紹

Yii 2.0 中數據庫的增刪改查操作。

查詢數據

查詢一條數據

<?php
//根據主鍵查詢數據
Customer::findOne(10);

//查詢一條數據 id=10 
Customer::find()
  ->where(['id' => 10])
  ->one();

//根據主鍵多個值查詢
Customer::findOne([10, 11, 12]);

//同上
Customer::find()
  ->where(['id' => [10, 11, 12]])
  ->one();

查詢多條數據

<?php
//根據主鍵查詢
PageModel::findAll(10);

//根據主鍵查詢
PageModel::findAll([10, 11, 12]);

//按分類返回列表，結果轉換為數組
$params = array();
$params[':classify'] = 1;

$pageList = PageModel::find()
  ->select('id, title')
  ->where('classify=:classify')
  ->params($params)
  ->asArray()
  ->all();

插入數據

<?php
//插入數據
$pageModel = new PageModel();
$pageModel->name = $name;
$pageModel->content = $content;
$pageModel->save();

刪除數據

//刪除一條數據
$pageModel = PageModel::findOne(1);
$pageModel->delete();

//根據條件刪除多條數據
$params = array();
$params[':id'] = 0;
$condition = 'id=:id';
PageModel::deleteAll($condition, $params);

修改數據

//修改一條數據
$pageModel = PageModel::findOne(1);
$pageModel->title = $title;
$pageModel->update = date('Y-m-d');
//指定需要更新的字段
$attributeNames = array("title", "update");
$pageModel->update(true, $attributeNames);

//批量修改數據
$attributes = array(
  'title' => $title,
  'update' => date('Y-m-d')
);
$condition = 'id=:id';
$params = array(
  ':id' => 1
);
PageModel::updateAll($attributes, $condition, $params);