¹ØÓÚPHP µ¼³ö³ÉEXECLµÄÎÊÌ⣡
ÎÒ¸Õ²ÅдÁËÒ»¸ö³ÌÐò¾ÍÊÇ µ¼³öEXECLÎļþ£¡µ«ÊÇÓÉÓÚÊý¾ÝÌ«´ó£¿ÀÏÊDZ¨´í¡°Allowed memory size of 20971520 bytes exhausted (tried to allocate 48 bytes)¡±
¾ÍÊÇÓõô20971520ÄÚ´æ »¹ÓÐ 48 bytesÄÚ´æÉêÇë²»µ½£¡
ÎÒÊÇÏȰÑÊý¾Ý¿â´ÓÊý¾Ý¿âÕÒ³öÀ´£¬±ä³ÉÊý×飡ȻºóÔÚµ¼³ÉEXECL¡£
ÓÐûÈËÆäËû°ì·¨ ¾ÍÊÇ»»¸ö˼·½â¾ö Õâ¸öµ¼³ÉEXECLµÄÎÊÌ⣡
Èç¹û²»Çå³þµÄ¿ÉÒÔ¼ÌÐøÎÊ£¡ÎÒ¿ÉÄÜ˵µÄ²»Çå³þ
×Ô¼º¶¥!
ÄãÊÇÈçºÎ×öµÄ£¬×îºÃÓдúÂë
ΪʲôҪ¡°±ä³ÉÊý×é"?
±ß¶Á±ßд²»ÐÐÂð£¿
ÎÒÖ±½Ó´ÓÊý¾Ý¿âÀïÃæ¶Á³öÀ´µÄ£¡
PHP code:
if(isset($_GET["copy"]))//µã»÷COPY°´Å¥
{
$ip=$_SG['db']->fetch_all("select * from main_info".$where);//´ÓÊý¾ÝÀïÃæÑ¡Ôñ ±ä³ÉÊý×é
require_once ('./include/class.excel.php');//ÔØÈëexcelÀà
$xls = new Excel;//ʵÀý»¯ÏÂ
$xls->addArray($ip);//µ÷ÓÃÀà·½·¨
$xls->generateXML ("mytest");//µ÷ÓÃÀà·½·¨
}
excelÀàÊÇûÎÊÌâµÄ£¡ ¹Ø¼üÎÊÌâÊÇ ÎÒ°Ñ20MµÄÊý¾Ý±ä³ÉÊý×飡 Õâ¸öÊý¾ÝÌ«´óÁË ÄÚ´æµô²»¶®£¡
Õâ¸ö·½·¨Ì«²îÁË£¡
±ß¶Á±ßд£¿ ÄܾßÌå˵˵Âð£¿
1.php.ini°Ñmemory_limit¸Ä´óµã
Ïà¹ØÎÊ´ð£º
¶Ôphp²»ÊǺÜÁ˽â дÁ˸ö¼òµ¥µÄÀý×Ó
ÏÖÓÃc#µ÷ÓÃphpдµÄ webservice£¨soap WSDL£©iis6.0+php5.2.8
webserviceÈçÏÂ
<?php
class WebService
{
public function Logout()
{
//header('Co ......
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿ÉÄÜÊÇÒòΪ¸ÃÕ¾µãûÓÐÄãÏëÒªµÄä¯ÀÀÆ ......
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
ÎÒÔÚmySqlÖÐÓÐÒ»×ֶοɴæhtml±êÇ©£¬±ÈÈç˵ÀïÃæÓÐa±êÇ©
µ«ÊÇÎÒÊäÈë²éѯÌõ¼þaµÄʱºò²¢²»Ïë²é³öÕâÌõ¼Ç¼£¬Ò²¾ÍÊÇ˵²éѯµÄʱºò²»¿¼ÂDZêÇ©,Ö»¿¼ÂÇÄÚÈÝ¡£
ÇëÎÊ´ó¼ÒÔõÑù½â¾ö£¿
¿ÉÒÔÔÙŪһ¸ö×Ö¶ÎÀ´±£´æ¹ýÂ˱êÇ©ºóµÄÄÚÈÝ¡£ ......