本篇文章给大家带来的内容是关于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列表——ajax public 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(); } } }
相关推荐：
tp获取name=data[]类型的表单字段（代码）
tp中使用原生的mysql语句的方法（代码）
以上就是tp数据层进行增删改查操作的代码的详细内容。