分页前,需要获取记录条数
$count = M('abc')->where($where)->count();
但是, 如果查询还需要使用到 GROUP BY的话
$count = M('video_log')->where($where)->group('ip')->count();
这样是等不到正确条数的,得到的还是总条数
怎样实现呢,需要借助原生sql语句
方法1:参考网址https://www.qiusuoweb.com/71.html
//SQL_CALC_FOUND_ROWS记录查询条数
//在测试中发现,mysql5.7中添加关键词SQL_CALC_FOUND_ROWS不是必须的。
Db::query("select SQL_CALC_FOUND_ROWS date('time') as date from users group by date");
//found_rows()获取以上查询记录的条数
$count = Db::query("select found_rows() as count");
自己用
Db::query("select * from my_video_log group by ip");
$count = Db::query("select found_rows() as count");
方法2:参考网址https://blog.csdn.net/weixin_37946518/article/details/89550409
SELECT COUNT(DISTINCT column_1, column_2) FROM tablename WHERE conditions
其中第二条的 column_1, column_2与第一条的GROUP BY 后的字段要保持一致(字段数量和顺序)
自己用
$rs = Db::query("SELECT COUNT(DISTINCT ip) as count FROM my_video_log");
$count = $rs[0]['count'];