TP資料層進行增刪改查操作的代碼

本篇文章給大家帶來的內容是關於TP資料層進行增刪改查操作的代碼，有一定的參考價值，有需要的朋友可以參考一下，希望對你有所協助。

Thinkphp資料層（模型層），添刪改查操作超詳細詳解！下面一起來看看！

<?php   namespace Home\Model;use Think\Model;class YmdModel extends Model{public function __construct(){$this->dbYimudi = M('yimudi');$this->dbYimudiUse = M('yimudi_use');$this->dbYimudiInfo = M('yimudi_info');$this->dbYimudiCi = M('yimudi_ci');}//兩個表關聯查詢public function getYimudiOne($condition,$field){if (!$condition) {return false;}else{return $this->dbYimudiUse->table('yimudi_use yu,yimudi y')->where(' yu.yimudi_id = y.yimudi_id'.$condition)->field($field)->find();}}//統計一個表滿足條件的數量public function getYimudiUseCount($condition){if (!$condition) {return false;}else{return $this->dbYimudiUse->where($condition)->count();}}//求和運算public function getEchangeYimudiCount($condition){if (!$condition) {return false;}else{return $this->dbYimudiUse->table('yimudi_use yu,yimudi y')->where(' yu.yimudi_id = y.yimudi_id'.$condition)->sum('change_num');}}//(yimud_id分組)public function getExchageByYimudiId($condition,$field){if (!$condition) {return false;}else{return $this->dbYimudiUse->table('yimudi_use yu,yimudi_ci yc')->where(' yu.yimudi_id = yc.yimudi_id'.$condition)->field($field)->group('yu.yimudi_id')->select();}}//更新操作public function updateYimudiUse($condition,$data){if (!$condition) {return false;}else{return $this->dbYimudiUse->where($condition)->save($data);}}//多表串連查詢，分頁擷取資料public function getYimudiList($condition,$start,$size){if (!$condition) {return false;}else{return $this->dbYimudiUse->table('yimudi_use as yu')->join('yimudi  as  y  on  yu.yimudi_id = y.yimudi_id', 'left')->join('yimudi_cinema as yc  on yu.yimudi_id = yc.cinema_id', 'left')->where($condition)->field($field)->limit($start, $size)->select();}}//關聯兩個表滿足的資料public function getYimudiCount($condition){if (!$condition) {return false;}else{return $this->dbYimudiUse->table('yimudi_use as yu')->join('yimudi  as  y  on  yu.yimudi_id = y.yimudi_id', 'left')->join('yimudi_ci as yc  on yu.yimudi_id = yc.yimudi_id', 'left')->where($condition)->count();}}//擷取YIMUDI列表——ajaxpublic function getYimudiListAjax($condition,$start,$size){if (!$condition) {return false;}else{return $this->dbYimudiUse->table('yimudi_use as yu')->join('yimudi  as  y  on  yu.yimudi_id = y.yimudi_id', 'left')->join('yimudi_ci as yc  on yu.yimudi_id = yc.yimudi_id', 'left')->where($condition)->field($field)->limit($start, $size)->select();}}//擷取單條記錄public function getYimudiCiDecription($condition,$file){if (!$condition) {return false;}else{return $this->dbYimudiCi->where($condition)->field($field)->find();}}//分頁擷取列表public function getCiYimudiList($condition,$start,$size){if (!$condition) {return false;}else{return $this->dbYimudiCiInfo->where($condition)->limit($start, $size)->select();}}//多表關聯查詢一條記錄public function getCiYimudiById($condition){if (!$condition) {return false;}else{return $this->dbYimudiUse->table('yimudi_use as yu')->join('yimudi  as  y  on  yu.yimudi_id = y.yimudi_id', 'left')->join('yimudi_ci as yc  on yu.yimudi_id = yc.yimudi_id', 'left')->where($condition)->field($field)->find();}}        }