首页 > 代码库 > php数据库两个关联大表的大数组分页处理,防止内存溢出

php数据库两个关联大表的大数组分页处理,防止内存溢出

        $ret = self::$db->select($tables, $fields, $where, $bind);        if (!empty($ret)) {            $retIds = array();            $ids = array();            while (!empty($ret)) {                $_sub = array_splice($ret, 0, 10000); //每次取出10000个                foreach ($_sub as $v) {                    array_push($retIds, $v[‘pt_AccountKey‘]);                }                unset($_sub);                /*过滤非快速登陆类型*/                $place_holders = implode(‘,‘, array_fill(0, count($retIds), ‘?‘));                array_unshift($retIds, ‘autoregs‘);                $PT_Account = self::$db->select(‘PT_Account‘, ‘pt_AccountKey‘, ‘pt_RegisteSource=? AND pt_AccountKey IN (‘ . $place_holders . ‘)‘, $retIds);                if (!empty($PT_Account)) {                    array_push($ids, $v[‘pt_AccountKey‘]);                }            }            unset($ret);            if (!empty($ids)) {                $num = count($ids);                $_sub = array_splice($ids, $get[‘start‘], $get[‘limit‘]);                $place_holders = implode(‘,‘, array_fill(0, count($_sub), ‘?‘));                $where = ‘pt_AccountKey IN (‘ . $place_holders . ‘)‘;                $list = self::$db->select(‘PT_Account‘, ‘pt_AccountID,pt_Password‘, $where, $_sub);                $grid = array();                $grid[‘rows‘] = $list;                $grid[‘total‘] = $num;                return $grid;            }        }

  

php数据库两个关联大表的大数组分页处理,防止内存溢出