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>
Ïà¹ØÎĵµ£º
PHPÓкܶàÖµµÃѧϰµÄµØ·½£¬ÕâÀïÎÒÃÇÖ÷Òª½éÉÜPHP SessionʹÓá£ÔÚPHP¿ª·¢ÖÐ¶Ô±ÈÆðCookie£¬session ÊÇ´æ´¢ÔÚ·þÎñÆ÷¶ËµÄ»á»°£¬Ïà¶Ô°²È«£¬²¢ÇÒ²»Ïñ Cookie ÄÇÑùÓд洢³¤¶ÈÏÞÖÆ£¬ÏÂÃæÎÒÃǾͼòµ¥½éÉÜ PHP SessionʹÓá£
¡¡¡¡ÓÉÓÚ Session ÊÇÒÔÎı¾ÎļþÐÎʽ´æ´¢ÔÚ·þÎñÆ÷¶ËµÄ£¬ËùÒÔ² ......
PHPСʵÀý-ÖÆ×÷ÁôÑÔ±¾
µÚÒ»²½£ºÔÚmysqlÖÐн¨Êý¾Ý¿âbbs È»ºóÖ´ÐÐsql´úÂë
CREATE TABLE `message` (
`id` tinyint(1) NOT NULL auto_increment,
`user` varchar(25) NOT NULL,
`title` varchar(50) NOT NULL,
`content` tinytext NOT NULL,
`lastdate` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT ......
»ù±¾¸ÅÄî
Ò»¸öÕýÔò±í´ïʽͨ³£±»³ÆÎªÒ»¸öģʽ (pattern)£¬ÎªÓÃÀ´ÃèÊö»òÕ߯¥ÅäһϵÁзûºÏij¸ö¾ä·¨¹æÔòµÄ×Ö·û´®¡£ÀýÈ磺Handel¡¢Händel ºÍ Haendel ÕâÈý¸ö×Ö·û´®£¬¶¼¿ÉÒÔÓÉ“H(a|ä|ae)ndel”Õâ¸öģʽÀ´ÃèÊö¡£´ó²¿·ÖÕýÔò±í´ïʽµÄÐÎʽ¶¼ÓÐÈçϵĽṹ£º
Ñ¡Ôñ| ÊúÖ±·Ö¸ô·û´ú±íÑ¡Ôñ¡£ÀýÈç“gray|grey&rd ......
×÷Ϊһ¸öÈ«ÐµĻ¥ÁªÍøÏîÄ¿£¬ÓÐʱºò»áÃæÁÙÒ»¸öÑ¡ÔñʲôÑùµÄ¿ª·¢ÓïÑÔµÄÎÊÌâ¡£
ÎÒ˵µÄÕâ¸öÓÐʱºò£¬ÆäʵÊÇÖ¸ÏÖÓеÄÍŶÓÖУ¬Ã»Óм¼Êõ¿ª·¢µÄ³ÉÔ±µÄÇé¿ö¡£Èç¹ûÒѾÓÐÁËÒ»¸ö»òÕß¶à¸ö¼¼Êõ¿ª·¢ÈËÔ±£¬µ±È»ÊÇÑ¡ÔñÏÖÓгÉÔ±×îÊìϤºÍ×îÉó¤µÄÓïÑÔÁË¡£
ÄÇô¶ÔÓÚÒ»¸ö»¹Ã»Óм¼Êõ³ÉÔ±µÄÍŶӣ¬Ó¦¸ÃÑ¡ÔñʲôÑùµÄ¿ª·¢ÓïÑÔÄØ£¿»Ø´ðÕâ¸öÎÊÌ⣬Ê×Ï ......
ÎÒÃÇÔÚдÓû§ÑéÖ¤Ò³Ãæ£¬Èç×¢²á£¬µÇ¼µÄʱºò£¬ÎªÁ˼ÓÇ¿Óû§µÇ¼µÄ°²È«ÐÔ£¬Ìí¼ÓÑéÖ¤ÂëÑéÖ¤¡£
ÑéÖ¤Âëͨ¹ýGDÉú³ÉPNGͼƬ£¬²¢°Ñ$randvalËæ»úÊý×Ö¸³¸ø$_SESSION['login_check_num']£¬ÔÚͨ¹ýÓû§ÊäÈëµÄ$_POST½øÐбȽϣ¬À´ÅжÏÊÇ·ñÕýÈ·¡£´ïµ½ÐèҪʵÏֵŦÄÜ£¬ÐèÒªÐÞ¸Äphp.iniÎļþ£¬Ê¹phpÖ§³ÖGD¿â¡£
<?php
//µ÷ÓôËÒ³Ãæ£¬Èç¹ûÏ ......