function getUsers() { //用户ID、手机号、设备号(未绑定缺省)、配额类型、流量有效期 // r_memberbd,r_cardorder $page = 1; $size = 15; if ($_GET['page'] != "") { $page = $_GET['page']; // echo $page; } if ($_GET['size'] != "") { $size = $_GET['size']; } $startn = ($page - 1) * $size; import("ORG.Util.Page1"); $sum = 1000; $pageOb = new Page($page, $size, $sum); // $start=$pageOb->getStartStr(); $m = new Model(); if ($_GET['title'] != '') { $ccid = $_GET['title']; $sql = "select mb.uid,mb.weixinid,mb.CCID,mb.tel,rs.deadTime,rs.`type`,rs.tel as tel1 from r_memberbd as mb left join r_simhard as rs on mb.CCID = rs.CCID where mb.CCID='{$ccid}'"; } else { $sql = "select mb.uid,mb.weixinid,mb.CCID,mb.tel,rs.deadTime,rs.`type`,rs.tel as tel1 from r_memberbd as mb left join r_simhard as rs on mb.CCID = rs.CCID order by rs.deadTime desc limit {$startn},{$size}"; } $arr = $m->query($sql); // var_dump($arr); $pageStr = $pageOb->getPagestr1(3); $arr = array('page' => $pageStr, 'data' => $arr); // var_dump($arr);exit; $data = json_encode($arr); // var_dump($data);exit; echo $data; }