phpÊä³öcsvºÍexcelÁ½ÖÖ·½·¨
1£¬¶¨Òåheader()Í·²¿Êä³ö¸ñʽ
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:finlename=php.xls");
vnd.ms-excel -----¶¨ÒåÊä³öÎļþ¸ñ
php.xls ---------¶¨ÒåÊä³öµÄÎļþÃû
2£¬Êä³ö±àÂëºÍÖ§³ÖµÄ¸ñʽ
(1) Ö§³ÖÆÕͨ¸ñʽµÄcsvÎı¾¹æ·¶£¬ÒÔ¿Õ¸ñºÍ»»ÐÐÀ´Ê¶±ð
³£Óãº\t \nÌî³ä¿Õ°×ºÍ»»ÐÐ
(2) Ö§³Ö¼òµ¥µÄhtml´úÂëºÍ±í¸ñ¹æ·¶
³£Óãºtable¹æ·¶£¬±í¸ñºÏ²¢¹æ·¶£¬Font±êÇ©¹æ·¶
===================================================
¼òµ¥µÄÀý×Ó£º
<?php
header("Content-type:application/vnd.ms-excel");
header("Content-Dispositon:finlename=php.xls");
//ÕâÊÇÒ»¸öcvsÎı¾¹æ·¶
/*
echo "A1\t B1\t C1\n";
echo "A2\t B2\t C2\n";
echo "A3\t B3\t C3\n";
*/
?>
<!--ÕâÊÇhtml´úÂëºÍ±í¸ñ¹æ·¶-->
<table border="1">
<tr>
<td>id</td>
<td><font color="red">Óû§Ãû</font></td>
<td>ÃÜÂë</td>
</tr>
<tr>
<td>1</td>
<td>mmm</td>
<td>23</td>
</tr>
<tr>
<td>2</td>
<td>ggg</td>
<td>32</td>
</tr>
<tr>
<td>=A2+A3</td>
<td></td>
<td>=SUM(C2:C3)</td>
</tr>
</table>
Ïà¹ØÎĵµ£º
Submitted by gouki
on 2008, December 28, 9:00 PM. PHP
ÎÄÕµÄÄÚÈÝдµÄ²»´í£¬ËùÒÔ×ªÔØÒ»Ï¡£
ÔÎÄ£ºhttp://xinsync.xju.edu.cn/index.php/archives/2946
ÄÚÈÝÈçÏ£º
XML/HTML´úÂë
¹ýÈ¥µ±ÔËÐÐÒ»¸ö´óµÄwebÓ¦ÓÃʱºòÒâζ×ÅÔËÐÐÒ»¸ö´óÐ͵Äweb·þÎñÆ÷¡£ÒòΪÄãµÄÓ¦ÓÃÎüÒýÁË´óÁ¿µÄÓû§£¬Ä㽫²»µÃ²»ÔÚÄãµÄ·þÎñÆ÷ÀïÔ ......
»ù±¾¸ÅÄî
Ò»¸öÕýÔò±í´ïʽͨ³£±»³ÆÎªÒ»¸öģʽ (pattern)£¬ÎªÓÃÀ´ÃèÊö»òÕ߯¥ÅäһϵÁзûºÏij¸ö¾ä·¨¹æÔòµÄ×Ö·û´®¡£ÀýÈ磺Handel¡¢Händel ºÍ Haendel ÕâÈý¸ö×Ö·û´®£¬¶¼¿ÉÒÔÓÉ“H(a|ä|ae)ndel”Õâ¸öģʽÀ´ÃèÊö¡£´ó²¿·ÖÕýÔò±í´ïʽµÄÐÎʽ¶¼ÓÐÈçϵĽṹ£º
Ñ¡Ôñ| ÊúÖ±·Ö¸ô·û´ú±íÑ¡Ôñ¡£ÀýÈç“gray|grey&rd ......
¡¡¡¡ÕâÊÇÒ»¸ö¾³£±»Ìá³öµÄÎÊÌ⣬²¢ÇÒËüºÜÈÝÒ×°ÑÈËÃÇ´øÈëÕùÂÛLinux»¹ÊÇWindowsµÄÆç;¡£ÕâÑùµÄÕùÂÛÊÂʵÉÏ·´Ó³³öÁ˶ÔÓÚÏ໥¾ºÕùµÄWeb¿ª·¢¼¼ÊõÒª½øÐв¢ÐзÖÎöÊǶàôÀ§ÄѵÄÒ»¼þÊÂÇ飬¶øÕâÒ»ÄѶÈͬʱÒòΪ¿ª·¢ÈËÔ±¶ÔÈκοɱȽϲÙ×÷ϵͳµÄ²»Í¬Òâ¼û¶ø´ó´óÔö¼Ó¡£
¡¡¡¡ËùÒÔÓëÆä¼ÌÐø²ÎÓëµ½ÕâÑùµÄÕùÂÛÖУ¬ÎÒÃÇ»¹²»ÈçÀ´¿´¿´Ã¿Ò»Ïî¼¼Êõ¶Ô ......
1¡¢·Ö±ð°²×°Èý¸ö»·¾³£¬²¢ÉèÖò»Í¬¶Ë¿Ú
PHP:80
JSP:8080
ASP:8081
2¡¢ÉèÖÃ/Apache2/conf/httpd.conf
È¥µôÒÔÏÂÈýÐÐǰµÄ×¢ÊÍ£º
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_connect_module modules/mod_proxy_connect.so
LoadModule proxy_http_module modules/mod_proxy_http.so
¼ÓÈëÒÔϼ¸ÐУº ......
Õâ¾ÍÒª´ÓË«ÒýºÅºÍµ¥ÒýºÅµÄ×÷Óý²Æð£º
Ë«ÒýºÅÀïÃæµÄ×ֶλᾹý±àÒëÆ÷½âÊÍÈ»ºóÔÙµ±×÷HTML´úÂëÊä³ö£¬µ«Êǵ¥ÒýºÅÀïÃæµÄ²»ÐèÒª½âÊÍ£¬Ö±½ÓÊä³ö¡£ÀýÈ磺
$abc='I love u';
echo $abc //½á¹ûÊÇ:I love u
echo '$abc' //½á¹ûÊ ......