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;
            }
        }

  

posted @ 2015-01-16 15:25  zenghansen  阅读(348)  评论(0编辑  收藏  举报