{"id":30332,"date":"2024-11-25T17:12:49","date_gmt":"2024-11-25T09:12:49","guid":{"rendered":"https:\/\/fwq.ai\/blog\/30332\/"},"modified":"2024-11-25T17:12:49","modified_gmt":"2024-11-25T09:12:49","slug":"dedecms%e7%bb%87%e6%a2%a6%e6%80%8e%e4%b9%88%e8%87%aa%e5%ae%9a%e4%b9%89%e8%a1%a8%e5%8d%95%e5%af%bc%e5%87%ba%e5%88%b0excel","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/30332\/","title":{"rendered":"dedecms\u7ec7\u68a6\u600e\u4e48\u81ea\u5b9a\u4e49\u8868\u5355\u5bfc\u51fa\u5230excel"},"content":{"rendered":"

\"dedecms\u7ec7\u68a6\u600e\u4e48\u81ea\u5b9a\u4e49\u8868\u5355\u5bfc\u51fa\u5230excel\u63d2\u56fe\"<\/strong><\/p>\n

\u7ec7\u68a6\u600e\u4e48\u81ea\u5b9a\u4e49\u8868\u5355\u5bfc\u51fa\u5230excel?<\/strong><\/p>\n

\u4fee\u65392\u4e2a\u6587\u4ef6\uff0c\u8ba9\u7ec7\u68a6\u81ea\u5b9a\u4e49\u8868\u5355\u81ea\u7531\u5bfc\u51fa\u5230Excel\u8868\u683c\u91cc\u3002<\/p>\n

\u63a8\u8350\u5b66\u4e60\uff1a<\/p>\n

\u4fee\u6539\u6559\u7a0b\u5982\u4e0b\uff1a<\/p>\n

1\u3001dede empletsdiy_main.htm \u627e\u5230<\/p>\n

\u524d\u53f0\u9884\u89c8<\/p>\n

<a>\u5bfc\u51fa\u8868\u5355Excel<\/a><\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
2\u3001dedediy_list.php \u627e\u5230<\/p>\n
array('post', 'list', 'edit', 'check', 'delete'))<\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
\u6539\u6210<\/p>\n
array('post', 'list', 'edit', 'check', 'delete', 'excel'))<\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
\u7ee7\u7eed\u627e\u5230<\/p>\n
else\n{\n    showmsg('\u672a\u5b9a\u4e49\u64cd\u4f5c', \"-1\");\n}<\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
\u5728\u5b83\u7684\u4e0a\u9762\u52a0\u5165<\/p>\n
else if($action == 'excel')\n{\nheader(\"Content-type:application\/vnd.ms-excel\");\nheader(\"Content-Disposition:attachment;filename={$diy-&gt;name}_\".date(\"Y-m-d\").\".xls\");\n$fieldlist = $diy-&gt;getFieldList();\necho \"<\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n\n\n\n    “; foreach($fieldlist as $field=>$fielddata) { echo ” <\/p>\n\n    “; foreach($fieldlist as $key => $field) { echo ” <\/p>\n
{$fielddata[0]}<\/th>\n
“; } echo ” <\/p>\n
\u72b6\u6001<\/th>\n
“; echo ”
\n  <\/tr>\n
“; $sql = “SELECT * FROM {$diy->table} ORDER BY id DESC”; $dsql->SetQuery($sql); $dsql->Execute(‘t’); while($arr = $dsql->GetArray(‘t’)) { echo ” <\/p>\n
“.$arr[$key].”<\/td>\n
“; } $status = $arr[‘ifcheck’] == 1 ? ‘\u5df2\u5ba1\u6838’ : ‘\u672a\u5ba1\u6838’; echo ” <\/p>\n
“.$status.”<\/td>\n
“; echo ”
\n  <\/tr>\n
“; } echo ”
\n <\/tbody>\n<\/table>\n
“; } <\/p>\n
\u4ee5\u4e0a\u5c31\u662f\u7ec7\u68a6\u600e\u4e48\u81ea\u5b9a\u4e49\u8868\u5355\u5bfc\u51fa\u5230excel\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
\u7ec7\u68a6\u600e\u4e48\u81ea\u5b9a\u4e49\u8868\u5355\u5bfc\u51fa\u5230excel? \u4fee\u65392\u4e2a\u6587\u4ef6\uff0c\u8ba9\u7ec7\u68a6\u81ea\u5b9a\u4e49\u8868\u5355\u81ea\u7531\u5bfc\u51fa\u5230Excel\u8868\u683c\u91cc\u3002 \u63a8\u8350\u5b66\u4e60\uff1a \u4fee\u6539\u6559\u7a0b\u5982\u4e0b\uff1a 1\u3001dede empletsdiy_main.htm \u627e\u5230 \u524d\u53f0\u9884\u89c8 <a>\u5bfc\u51fa\u8868\u5355Excel<\/a> \u767b\u5f55\u540e\u590d\u5236 2\u3001dedediy_list.php \u627e\u5230 array(‘post’, ‘list’, ‘edit’, ‘check’, ‘delete’)) \u767b\u5f55\u540e\u590d\u5236 \u6539\u6210 array(‘post’, ‘list’, ‘edit’, ‘check’, ‘delete’, ‘excel’)) \u767b\u5f55\u540e\u590d\u5236 \u7ee7\u7eed\u627e\u5230 else {     showmsg(‘\u672a\u5b9a\u4e49\u64cd\u4f5c’, “-1”); } \u767b\u5f55\u540e\u590d\u5236 \u5728\u5b83\u7684\u4e0a\u9762\u52a0\u5165 else if($action == ‘excel’) { header(“Content-type:application\/vnd.ms-excel”); header(“Content-Disposition:attachment;filename={$diy-&gt;name}_”.date(“Y-m-d”).”.xls”); $fieldlist = $diy-&gt;getFieldList(); echo ” \u767b\u5f55\u540e\u590d\u5236 “; foreach($fieldlist as $field=>$fielddata) { echo ” {$fielddata[0]} “; } echo ” \u72b6\u6001 “; echo ” “; $sql = “SELECT * FROM {$diy->table} ORDER BY id DESC”; $dsql->SetQuery($sql); $dsql->Execute(‘t’); while($arr = $dsql->GetArray(‘t’)) { echo ” “; foreach($fieldlist as $key => $field) { echo ” “.$arr[$key].” “; […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-30332","post","type-post","status-publish","format-standard","hentry","category-cms"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/30332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=30332"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/30332\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=30332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=30332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=30332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}