源码

php.ini配置对php上传文件大小的影响参数有:配置项可能值功能描述file_uploadsON确定服务器上的PHP脚本是否可以接受HTTP文件上传memory_limit8M设置脚本可以分配的最大内存量,防止失控的脚本独占服务器内存upload_max_filesize改为8M限制PHP处理上传文件的最大值,此值必须小于post_max_size值post_max_size改为16M限制通过POST方法可以接受的信息最大量php.ini配置信息可以在前台输入<?phpechophpinfo();?>进行查看php.ini目录信息。但如果要上传>8M的大体积文件,只设置上述四项还一定能行的通。进一步配置以下的参数max_execution_time=600;每个PHP页面运行的最大时间值(秒),默认30秒max_input_time=600;每个PHP页面接收数据所需的最大时间,默认60秒memory_limit=8m;每个PHP页面所吃掉的最大内存,默认8M把上述参数修改后,在网络所允许的正常情况下,就可以上传大体积文件了max_execution_time=600max_input_time=600memory_limit=32mfile_uploads=onupload_tmp_dir=/tmpupload_max_filesize=32mpost_max_size=32m//类似详解配置php.ini文件(以上传500M以下大小的文件为例)查找以下选项并修改->file_uploads=On;打开文件上传选项upload_max_filesize=500M;上传文件上限如果要上传比较大的文件,仅仅以上两条还不够,必须把服务器缓存上限调大,把脚本最大执行时间变长post_max_size=500M;post上限max_execution_time=1800;Maximumexecutiontimeofeachscript,inseconds脚本最大执行时间max_input_time=1800;Maximumamountoftimeeachscriptmayspendparsingrequestdatamemory_limit=128M;Maximumamountofmemoryascriptmayconsume(128MB)内存上限————————————————原文链接:https://blog.csdn.net/qq_38588845/java/article/details/80770264

源码

方法一:后台找到/dede/templets/diy_main.htm查找:<ahref="../plus/diy.php?action=list&diyid={dede:field.diyid/}"target="_blank"><imgsrc='images/gtk-tmp.png'title='预览'alt='预览'/>前台预览</a>在后面加上:&nbsp;|&nbsp;<ahref='diy_list.php?action=excel&diyid={dede:field.diyid/}'target="_blank">导出表单Excel</a>修改/dede/diy_list.php,在其中搜索:$action=isset($action)&&in_array($action,array('post','list','edit','check','delete'))?$action:'';修改为:$action=isset($action)&&in_array($action,array('post','list','edit','check','delete','excel'))?$action:'';再找到:else{showmsg('未定义操作',"-1");}在它前面添加:elseif($action=='excel'){ob_end_clean();//清除缓冲区,避免乱码header("Content-type:application/vnd.ms-excel");header("Content-Disposition:attachment;filename={$diy->name}_".date("Y-m-d").".xls");print(chr(0xEF).chr(0xBB).chr(0xBF));//清除bom$fieldlist=$diy->getFieldList();echo"<table><tr>";foreach($fieldlistas$field=>$fielddata){echo"<th>{$fielddata[0]}</th>";}echo"<th>状态</th>";echo"</tr>";$sql="SELECT*FROM{$diy->table}ORDERBYidDESC";$dsql->SetQuery($sql);$dsql->Execute('t');while($arr=$dsql->GetArray('t')){echo"<tr>";foreach($fieldlistas$key=>$field){echo"<td>".$arr[$key]."</td>";}$status=$arr['ifcheck']==1?'已审核':'未审核';echo"<td>".$status."</td>";echo"</tr>";}echo"</table>";}方法二,较麻烦,未亲测:1.首先在后台找到/dede/templets/diy_main.htm,查找:<ahref="../plus/diy.php?action=list&diyid={dede:field.diyid/}"target="_blank"><imgsrc='images/gtk-tmp.png'title='预览'alt='预览'/>前台预览</a>在后面加上:&nbsp;|&nbsp;<ahref="../plus/diy.php?action=daochu&diyid={dede:field.diyid/}"target="_blank">导出为EXCEL</a>2、核心内容修改plus/diy.php$action=isset($action)&&in_array($action,array('post','list','view'))?$action:'post';替换成:$action=isset($action)&&in_array($action,array('post','list','view','daochu'))?$action:'post';3、再在plus/diy.php最后一行下面新加代码:elseif($action=='daochu'){ob_end_clean();//清除缓冲区,避免乱码header("Content-type:application/vnd.ms-excel;");Header("Content-Disposition:attachment;filename={$diy->table}_".date("Y-m-d").".xls");print(chr(0xEF).chr(0xBB).chr(0xBF));//清除bom$query="desc`{$diy->table}`";$res=mysql_query($query);echo"<table><tr>";//导出表头(也就是表中拥有的字段)while($row=mysql_fetch_array($res)){$t_field[]=$row['Field'];//Field中的F要大写,否则没有结果/*echo"<th>".$row['Field']."</th>";*/if($row['Field']=='id'){echo"<th>ID</th>";}elseif($row['Field']=='gsm'){echo"<th>公司名</th>";}elseif($row['Field']=='xm'){echo"<th>姓名</th>";}elseif($row['Field']=='sj'){echo"<th>手机号码</th>";}elseif($row['Field']=='yx'){echo"<th>电子邮箱</th>";}else{echo"<th></th>";}}echo"</tr>";//导出数据$sql="select*from`{$diy->table}`";$res=mysql_query($sql);while($row=mysql_fetch_array($res)){echo"<tr>";foreach($t_fieldas$f_key){echo"<td>".$row[$f_key]."</td>";}echo"</tr>";}echo"</table>";}原文地址:https://blog.csdn.net/jklgfgdsr/article/details/79311950