(PHP)--获取每个月的用户量

首先sql语句就是 

$sql ="SELECT DATE_FORMAT(add_time,'%Y-%m') as time , count(*) as count FROM simai_wx_member GROUP BY time ";

这样就把时间按月份的格式统计分组了

/**
 * 参数 data
 * 正确返回 每个月的数量
 * 错误返回
 */
public static function getMonthUser($data){
    $wx_member_mode =D('wx_member');
    $count = '';
    $sql ="SELECT DATE_FORMAT(add_time,'%Y-%m') as time , count(*) as count FROM simai_wx_member GROUP BY  time ";
    $result = $wx_member_mode->query($sql);
    foreach ($result as $key => $value){
        if($data==$value['time']){//就是把输入的时间和数据库里面的时间字段的值进行比较然后保存
            $count = $value['count'];
        }
    }
    if($count==null){
        return '';
    }
    return $count;
}

//测试每个月的时间
public function test(){
    $data = date('Y-m',strtotime('2018-03'));
    $result = wx_memberModel::getMonthUser($data);
   echo $result;
}