// 统计表数据量 $count = read('news'); // 参数: $table=表名(不含前缀), $where=条件 // 返回: 记录数 // 带条件的统计 $count = read('product', ['checked' => 1]); // 示例: 统计已审核产品数 $checked = read('product', ['checked' => 1]); // 示例: 统计推荐新闻数 $rec = read('news', ['ifrecommend' => ['like', '%1%']]);

// 查询新闻列表 $list = getTableContent('news', 10, [], 'id desc'); // 参数: $table, $nums, $wheresql=条件数组, $order // 带条件查询 $list = getTableContent('product', 10, [ 'checked' => 1, 'delstatus' => 0 ], 'clicks desc'); // 条件支持: 键值对、like、in等 $list = getTableContent('news', 10, [ 'title' => ['like', '%化工%'] ], 'id desc');

// 按分类查询内容 $list = getTableContentall('news', $cid, 10, 'id desc'); // 参数: $table, $cid=分类ID, $nums, $order // 自动包含delstatus=0和checked=1条件 // 查询分类下产品 $products = getTableContentall('product', 5, 10, 'id desc');

// 按类型和分类获取数据 $list = getDataByCat($cid, 'news', 10, 'id desc'); // 参数: $cid, $ctype=类型, $nums, $order // 类型: news/product/video/photo/experience/kungfu/master // 获取分类下视频 $videos = getDataByCat(3, 'video', 10, 'clicks desc');

use think\facade\Db; // 多表关联查询 $list = Db::name('product') ->alias('p') ->join('category c', 'p.cid = c.cid') ->where('p.delstatus', 0) ->where('p.checked', 1) ->field('p.*, c.cnname as catname') ->order('p.id', 'desc') ->limit(10) ->select(); // 分页查询 $list = Db::name('news') ->where('delstatus', 0) ->order('id', 'desc') ->paginate(15); // 聚合查询 $count = Db::name('product')->where('checked', 1)->count(); $sum = Db::name('product')->where('checked', 1)->sum('clicks'); $avg = Db::name('product')->where('checked', 1)->avg('clicks');