网页的本质就是超级文本标记语言，通过结合使用其他的Web技术（如：脚本语言、公共网关接口、组件等），可以创造出功能强大的网页。因而，超级文本标记语言是万维网（Web）编程的基础，也就是说万维网是建立在超文本基础之上的。超级文本标记语言之所以称为超文本标记语言，是因为文本中包含了所谓“超级链接”点。
本篇文章给大家带来的内容是关于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();
}
}
}