权限没有,则隐藏 function forum_list_access_filter($forumlist, $gid, $allow = 'allowread') { global $grouplist; if (empty($forumlist)) return array(); if (1 == $gid) return $forumlist; $forumlist_filter = $forumlist; $group = $grouplist[$gid]; foreach ($forumlist_filter as $fid => $forum) { if (empty($forum['accesson']) && empty($group[$allow]) || !empty($forum['accesson']) && empty($forum['accesslist'][$gid][$allow])) { unset($forumlist_filter[$fid]); } unset($forumlist_filter[$fid]['accesslist']); } return $forumlist_filter; } function forum_filter_moduid($moduids) { $moduids = trim($moduids); if (empty($moduids)) return ''; $arr = explode(',', $moduids); $r = array(); foreach ($arr as $_uid) { $_uid = intval($_uid); $_user = user_read($_uid); if (empty($_user)) continue; if ($_user['gid'] > 4) continue; $r[] = $_uid; } return implode(',', $r); } function forum_safe_info($forum) { //unset($forum['moduids']); return $forum; } function forum_filter($forumlist) { foreach ($forumlist as &$val) { unset($val['brief'], $val['announcement'], $val['seo_title'], $val['seo_keywords'], $val['create_date_fmt'], $val['icon_url'], $val['modlist']); } return $forumlist; } function forum_format_url($forum) { global $conf; if (0 == $forum['category']) { // 列表URL $url = url('list-' . $forum['fid'], '', FALSE); } elseif (1 == $forum['category']) { // 频道 $url = url('category-' . $forum['fid'], '', FALSE); } elseif (2 == $forum['category']) { // 单页 $url = url('read-' . trim($forum['brief']), '', FALSE); } if ($conf['url_rewrite_on'] > 1 && $forum['well_alias']) { if (0 == $forum['category'] || 1 == $forum['category']) { $url = url($forum['well_alias'], '', FALSE); } elseif (2 == $forum['category']) { // 单页 $url = ($forum['threads'] && $forum['brief']) ? url($forum['well_alias'] . '-' . trim($forum['brief']), '', FALSE) : url($forum['well_alias'], '', FALSE); } } return $url; } function well_forum_alias() { $forumlist = forum_list_cache(); if (empty($forumlist)) return ''; $key = 'forum-alias'; static $cache = array(); if (isset($cache[$key])) return $cache[$key]; $cache[$key] = array(); foreach ($forumlist as $val) { if ($val['well_alias']) $cache[$key][$val['fid']] = $val['well_alias']; } return array_flip($cache[$key]); } function well_forum_alias_cache() { global $conf; $key = 'forum-alias-cache'; static $cache = array(); // 用静态变量只能在当前 request 生命周期缓存,跨进程需要再加一层缓存:redis/memcached/xcache/apc if (isset($cache[$key])) return $cache[$key]; if ('mysql' == $conf['cache']['type']) { $arr = well_forum_alias(); } else { $arr = cache_get($key); if (NULL === $arr) { $arr = well_forum_alias(); !empty($arr) AND cache_set($key, $arr); } } $cache[$key] = empty($arr) ? '' : $arr; return $cache[$key]; } ?>php下载卡住,php
最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

php下载卡住,php

运维笔记admin87浏览0评论

php下载卡住,php

php下载卡住,php

嗨,我正在以excel格式导出我的mysql数据,目前我有14k记录,但问题是它卡住了@ 188kb,但是当我尝试将结果缩减为100条记录时,它不会中断下载.

这是我的代码:

function xlsBOF() {

echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);

return;

}

function xlsEOF() {

echo pack("ss", 0x0A, 0x00);

return;

}

function xlsWriteNumber($Row, $Col, $Value) {

echo pack("sssss", 0x203, 14, $Row, $Col, 0x0);

echo pack("d", $Value);

return;

}

function xlsWriteLabel($Row, $Col, $Value ) {

$L = strlen($Value);

echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L);

echo $Value;

return;

}

mysql_connect($dbhost,$dbuser,$dbpass);

//mysql_select_db($dbname) or die("Unable to select database");

$result = mysql_db_query($dbname, "select id, or_number, name, client_code, address, vehicle_info, vehicle_color, plate_num, sticker_type, application_date, amount_paid, traffic_violations, delivery_date, edited_by, phase, version FROM owner order by application_date desc");

// Send Header

header("Pragma: public");

header("Expires: 0");

header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

header("Content-Type: application/force-download");

header("Content-Type: application/octet-stream");

header("Content-Type: application/download");;

header("Content-Disposition: attachment;filename=epal.xls"); // à?à??à?‰à?§à??à??à??à?à??à??à?·à??à??à??à??à??à??

header("Content-Transfer-Encoding: binary ");

xlsBOF();

xlsWriteLabel(0,0,"Current SLVA Owner List:");

xlsWriteLabel(2,0,"#");

xlsWriteLabel(2,1,"OR #");

xlsWriteLabel(2,2,"Name");

xlsWriteLabel(2,3,"Client Code");

xlsWriteLabel(2,4,"Address");

xlsWriteLabel(2,5,"Vehicle Info");

xlsWriteLabel(2,6,"Vehicle Color");

xlsWriteLabel(2,7,"Plate #");

xlsWriteLabel(2,8,"Sticker Type");

xlsWriteLabel(2,9,"Application Date");

xlsWriteLabel(2,10,"Amount Paid");

xlsWriteLabel(2,11,"Traffic Violations");

xlsWriteLabel(2,12,"Delivery Date");

xlsWriteLabel(2,13,"Edited By");

xlsWriteLabel(2,14,"Phase");

xlsWriteLabel(2,15,"Version");

$xlsRow = 3;

while(list($id, $or_number, $name, $client_code, $address, $vehicle_info, $vehicle_color, $plate_num, $sticker_type, $application_date, $amount_paid, $traffic_violations, $delivery_date, $edited_by, $phase, $version) = mysql_fetch_row($result)) {

xlsWriteLabel($xlsRow,0, $id);

xlsWriteLabel($xlsRow,1,$or_number);

xlsWriteLabel($xlsRow,2,$name);

xlsWriteLabel($xlsRow,3,$client_code);

xlsWriteLabel($xlsRow,4,$address);

xlsWriteLabel($xlsRow,5,$vehicle_info);

xlsWriteLabel($xlsRow,6,$vehicle_color);

xlsWriteLabel($xlsRow,7,$plate_num);

xlsWriteLabel($xlsRow,8,$sticker_type);

xlsWriteLabel($xlsRow,9,$application_date);

xlsWriteLabel($xlsRow,10,$amount_paid);

xlsWriteLabel($xlsRow,11,$traffic_violations);

xlsWriteLabel($xlsRow,12,$delivery_date);

xlsWriteLabel($xlsRow,13,$edited_by);

xlsWriteLabel($xlsRow,14,$phase);

xlsWriteLabel($xlsRow,15,$version);

$xlsRow++;

}

xlsEOF();

exit();

我去了几个站点/线程,但仍然没有找到解决方案. :'(

发布评论

评论列表(0)

  1. 暂无评论