{"id":417,"date":"2011-05-06T14:48:18","date_gmt":"2011-05-06T06:48:18","guid":{"rendered":"http:\/\/zduo.me\/blog\/?p=417"},"modified":"2015-11-06T13:21:33","modified_gmt":"2015-11-06T05:21:33","slug":"php%e5%af%bc%e5%87%baexcel%e6%96%87%e6%a1%a3","status":"publish","type":"post","link":"http:\/\/zduo.me\/blog\/?p=417","title":{"rendered":"php\u5bfc\u51faexcel\u6587\u6863"},"content":{"rendered":"
\r\nwhile($data_array=mysql_fetch_array($result)){\r\n\t$data[$i]=$data_array;\r\n\t$i++;\r\n}\r\n\r\n$title=array(\"game_name\",\"des\",\"url\",\"add_time\");\r\n$keys=array(\"game_name\",\"des\",\"url\",\"add_time\");\r\n\r\nexportToExcel($data,'aa.xls',$title,$keys);\r\n\r\nfunction exportToExcel($data,$filename,$title,$keys){\t\t\/\/$keys\u70badata\u4e2d\u8981\u5c0e\u51fa\u7684\u6578\u64da\u5217\r\n\theader('Content-type: text\/cvs');\r\n\theader(\"Content-Disposition: attachment; filename=\\\"$filename\\\"\");\r\n\t$top = '\u6578\u64da\u5c0e\u51fa\u6642\u9593\uff1a'.date('Y-m-d H:i:s');\r\n\t$table\t= '';\r\n\t$table .= '
<\/td>';\r\n\tforeach($title as $value){\r\n\t\t$table .= ''.$value.'<\/td>';\t\t\t\t\t\t\/\/\u5217\u6a19\u984c\r\n\t}\r\n\t$table .= '<\/thead>';\r\n\t$i =1;\r\n\tforeach($data as $value){\r\n\t\t$table .= '
'.$i.'<\/td>';\t\t\t\t\t\t\/\/\u5e8f\u865f\r\n\t\tforeach($keys as $key){\t\t\t\t\t\t\t\t\t\/\/\u6578\u64da\u5167\u5bb9\r\n\t\t\t$table .= ''.$value[$key].'<\/td>';\r\n\t\t}\r\n\t\t$table .= '<\/tr>';\r\n\t\t$i++;\r\n\t}\r\n\t$table .= '<\/table>';\r\n\t$top\t= iconv('utf-8','gbk',$top);\r\n\t$table\t= iconv('utf-8','gbk',$table);\r\n\techo $top;\r\n\techo $table;\r\n\texit;\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
while($data_array=mysql_fetch_array($result)){ $data[$i]=$data_array; $i++; } $title=array(“game_name”,”des”,”url”,”add_time”); $keys=array(“game_name”,”des”,”url”,”add_time”); exportToExcel($data,’aa.xls’,$title,$keys); function exportToExcel($data,$filename,$title,$keys){ \/\/$keys\u70badata\u4e2d\u8981\u5c0e\u51fa\u7684\u6578\u64da\u5217 header(‘Content-type: text\/cvs’); header(“Content-Disposition: attachment; filename=\\”$filename\\””); $top = ‘\u6578\u64da\u5c0e\u51fa\u6642\u9593\uff1a’.date(‘Y-m-d H:i:s’); $table = ”; $table .= ”; foreach($title as $value){ $table .= ”.$value.”; \/\/\u5217\u6a19\u984c } $table .= ”; $i =1; foreach($data as … \u7ee7\u7eed\u9605\u8bfb →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[73,166],"_links":{"self":[{"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=\/wp\/v2\/posts\/417"}],"collection":[{"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=417"}],"version-history":[{"count":3,"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=\/wp\/v2\/posts\/417\/revisions"}],"predecessor-version":[{"id":648,"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=\/wp\/v2\/posts\/417\/revisions\/648"}],"wp:attachment":[{"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=417"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}