Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÓÐûÓÐphp´úÂë¿ÉÒÔ½«excelת³ÉxmlµÄ

ÈçÌ⣬ÓÐûÓÐÕâÑùµÄphp´úÂë¡£ÎÒÏÖÔÚÏ뽫excelµÄÄÚÈݲåÈëmysqlÊý¾Ý¿â£¬Ï£Íû¿ÉÒÔ½«excelת³Éxml,È»ºó½âÎöxml²åÈëÊý¾Ý¿âÖС£Èç¹ûÓÐÕâÑùµÄ´úÂ룬ÉõÖÁÊÇÓÐÃûµÄ´úÂ룬һ¶¨Òª¸æËßÎÒ°¡¡£
ÏȶÁ excel => È»ºóÉú³É xml => Èë¿â

ÓÃPHP ExcelReader½«excelÖеÄÄÚÈݶÁÈ¡³öÀ´²åÈëÊý¾Ý¿â£¬Èç¹ûÒªÉú³Éxml
Äã¿ÉÒÔ¿´¿´Õâ¸öhttp://www.ibm.com/developerworks/cn/xml/x-xmlphp1.html

·Ç³£¸Ðл£¬²»¹ý³öÏÖÁËÒ»µãÎÊÌ⣬ÎÒµÄexcelÎļþÀïÓÐÖÐÎÄ£¬½âÎöÒÔºóÏÔʾÂÒÂë¡£²»Öªµ½¸ÃÔõô½â¾ö¡£

RT!

phpexcel ¶ÁÈ¡excel Éú³É xml ±£´æ¡£ÕâÑù¿ÉÒÔ²»£¿


Ïà¹ØÎÊ´ð£º

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

ÈçºÎÌá½»xmlÀàÐÍÊý¾Ý - .NET¼¼Êõ / ASP.NET

Êý¾Ý¿â±íÖÐÓÐÒ»ÁУ¨TranXml£©ÀàÐÍÊÇxml£¬´æ´¢µÄÊÇÀàËÆ
<fathernode>
  <a>aaa
  </a>
  <b>bbb
  </b>
</fathernode>
µÄÐÅÏ¢£¬²¢ÇÒͨ¹ý²éѯ·½· ......

phpʱ¼äÕýÔòÎÊÌâ - PHP / »ù´¡±à³Ì

PHP code:

$date = '2009-12-25';
$ptn = '/([\d]{4})[- \/](0?[\d]|1[0-2])[-\/ ](0?[\d]|[1-2][\d]|3[0-1])/';
if (preg_match($ptn,$date,$out))
{
print_r($out);exit();
}
½á¹ûΪ:
PHP code:
......

ÕÒÈË¿ª·¢PHP³é½±³ÌÐò

ÕÒÈË¿ª·¢PHP³é½±³ÌÐò 
ÓÐÒâÏòÕß¼ÓÎÒ
251414041
°ï¶¥ÁË£¡

結貼ÂÊÌ«µÍ

°ï¶¥¡£

How much?

¶¥

4Â¥µÄÎÊÁË£¬¶àÉÙÇ®

duoshao

°¥.............


Äã²»ÊÇÈÃÎÒ×öÁËÂ𣿡·¡·¡·Ôõà ......

MySQL´íÎó - PHP / »ù´¡±à³Ì

ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿

ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ

¿ÉÒÔÓÃÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ