PHP CI 数据分组 每100条一组 不足100条 放在数组最后 适用于邮件、短信群发

 

function send_sms_all(){echo 0;die; //向所有实名认证用户群发，每次100
        
        $sql = 'SELECT username FROM ych_user WHERE real_status!=0 and user_id not in(466,2,3,6,7)';
        //$sql = 'SELECT username FROM ych_user WHERE real_status!=0 and user_id in(466,2,3,6,7)';//先用自己人的手机号测试
        $r = $this->db->query($sql);
        $r2 = $r->result_array();

        foreach($r2 as $k=>$v){
            $arr[] = $v['username'];
            if(count($arr)%100 == 0){//每次只能发100个
                $send_arr[] = $arr;//将满足100的数组放到新数组中
                $arr = '';
            }
        }
        
        $total_phone = count($r2);
        $x = $total_phone%100;
        $mod_list = array_slice($r2,'-'.$x);//从数组中倒数第x取值，这个值是不足100的情况

        foreach($mod_list as $k=>$v){
            $mod_arr[] = $v['username'];//将不足100的合并为一维数组
        }
        
        $send_arr[] = $mod_arr;//至此已把所有数据每100条放到$send_arr中
//print_r($send_arr);die;
    
        foreach($send_arr as $k=>$v){
            $send_phone = implode(',',$v);  //'18645666555,15919700177';
//echo $send_phone;die;
            $this->load->library('phone');
            $res = $this->phone->sendSMS($send_phone,$msg,"98653");
            print_r($res);
        }
print_r($send_arr);die;
}