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

php ½âÎö excel ´æ´¢µ½ mysql ÂÒÂë


±àÂëÊǸöºÜ»ù´¡µÄÎÊÌ⣬ҲÊÇ´ó¼ÒºÜÈÝÒ׺öÂÔµÄÎÊÌ⣬д´úÂë֮ǰ¶à¶à¿¼ÂÇ£¬ÒÔºó»áÉٺܶàÂé·³¡£
PHP·¢Õ¹Á˲»ÉÙ£¬ÏÖÔÚpearÓÃÆðÀ´ºÜ·½±ã£¬ÆäÖоÍÓÐÏà¹ØµÄclassÀ´¶ÁÈ¡ExcelÎļþÀïÃæµÄÄÚÈÝ£¬Èç¹û²»ÏëʹÓÃpearµÄ»°£¬¿ÉÒÔ¿¼ÂÇʹÓÃexcel_class.php£¬googleһϣ¬¿ÉÒÔÕÒµ½Õâ¸öclassµÄsource codeÏÂÔØ£¬Ò²ÄÜÕÒµ½»ù±¾µÄexample code£¬ÓÃÆðÀ´ºÜ·½±ã¡£
ÐèҪעÒâµÄÊÇ£¬´ÓExcelÀïÃæ¶ÁÈ¡³öÀ´µÄÊôÓÚUTF-16LE±àÂ룬Èç¹ûÔÚÒÆ¶¯Ó¦ÓÃÖÐʹÓÃexcel_class£¬ÔòÐèҪעÒ⣬ÒòΪͨ³£ÊÖ»ú¶¼ÊÇÖ§³ÖUTF-8±àÂ룬ÆäÖоÍÉæ¼°µ½±àÂëµÄת»»¡£
ÀýÈçÎÒʹÓÃ
echo $return[Sheet2][0][0];
À´ÏÔʾµÚ1ÐеÚ1ÁÐÀïÃæµÄÄÚÈÝ£¬Ô­±¾ÄÚÈÝÊÇ“¿ªÊ¼”£¬Ê¹ÓÃPHPÔÚwebÉÏÏÔʾµÄʱºòҲȷʵÊÇ“¿ªÊ¼”£¬µ«ÊÇ²é¿´ÍøÒ³µÄÔ´´úÂëÊÇ
&#24320&#22987
ÆäÖÐ&#ÊÇΪÁËÔÚÍøÒ³ÉÏÏÔʾ£¬24320ºÍ22987µÄÊ®Áù½øÖƱíʾÔòÊÇ“¿ªÊ¼”µÄUTF-16LE±àÂë¡£
ÄÇôÎÒÃÇÐèÒª×öµÄ¾ÍÊǽ«Õâ¸öUTF-16LE±àÂëת»»ÎªUTF-8±àÂë¡£
Ê×ÏÈ´ò¿ªexcel_class.php£¬ÕÒµ½º¯Êýuc2html£¬ ½«º¯ÊýÖеĴúÂë×¢Ê͵ô£¬Ö±½Ó½«²ÎÊý·µ»Ø£¬ ¼´¸Äº¯Êý²»×öÈκβÙ×÷¡£
function uc2html($str) {
  return $str;
}
½ÓÏÂÀ´Ê¹ÓÃPHPÖÐÌṩµÄº¯Êýmb_convert_encodingÀ´½«UTF-16LEת»»³ÉUTF-8¡£
echo mb_convert_encoding($return[Sheet2][0][0], 'UTF-8', 'UTF-16LE');
µ½´Ë£¬¼´Íê³ÉÁËUTF-16LEµ½UTF-8µÄת»»¡£
ÐèҪעÒâµÄÊÇ£¬´ÓExcelÀïÃæ¶ÁÈ¡³öÀ´µÄÊôÓÚUTF-16LE±àÂ룬Èç¹ûÔÚÒÆ¶¯Ó¦ÓÃÖÐʹÓÃexcel_class£¬ÔòÐèҪעÒ⣬ÒòΪͨ³£ÊÖ»ú¶¼ÊÇÖ§³ÖUTF-8±àÂ룬ÆäÖоÍÉæ¼°µ½±àÂëµÄת»»¡£
ÀýÈçÎÒʹÓÃ
echo $return[Sheet2][0][0];
À´ÏÔʾµÚ1ÐеÚ1ÁÐÀïÃæµÄÄÚÈÝ£¬Ô­±¾ÄÚÈÝÊÇ“¿ªÊ¼”£¬Ê¹ÓÃPHPÔÚwebÉÏÏÔʾµÄʱºòҲȷʵÊÇ“¿ªÊ¼”£¬µ«ÊÇ²é¿´ÍøÒ³µÄÔ´´úÂëÊÇ
¿ªÊ¼
ÆäÖÐ&#ÊÇΪÁËÔÚÍøÒ³ÉÏÏÔʾ£¬24320ºÍ22987µÄÊ®Áù½øÖƱíʾÔòÊÇ“¿ªÊ¼”µÄUTF-16LE±àÂë¡£
ÄÇôÎÒÃÇÐèÒª×öµÄ¾ÍÊǽ«Õâ¸öUTF-16LE±àÂëת»»ÎªUTF-8±àÂë¡£
Ê×ÏÈ´ò¿ªexcel_class.php£¬ÕÒµ½º¯Êýuc2html£¬ ½«º¯ÊýÖеĴúÂë×¢Ê͵ô£¬Ö±½Ó½«²ÎÊý·µ»Ø£¬ ¼´¸Äº¯Êý²»×öÈκβÙ×÷¡£
function uc2html($str) {
return $str;
}
UnicodeÊÇ"UTF-16LE"£¬ÎÒ¿ÉÒÔͨ¹ý£º
mb_convert_encoding($str, "UTF-16LE", "UTF-8")
»òÕß
iconv("UTF-8", "UTF-16LE", $str)
½«UTF-8ת»»ÎªUnicode¡£
 


Ïà¹ØÎĵµ£º

mysql¸´ÖƱí

ÎÒÃǾ­³£»áÓöµ½ÐèÒª±í¸´ÖƵÄÇé¿ö£¬È罫һ¸ötable1µÄÊý¾ÝµÄ²¿·Ö×ֶθ´ÖƵ½table2ÖУ¬»òÕß½«Õû¸ötable1¸´ÖƵ½table2ÖУ¬ÕâʱºòÎÒÃǾÍҪʹÓÃSELECT INTO ºÍ INSERT INTO SELECT ±í¸´ÖÆÓï¾äÁË¡£
1.INSERT INTO SELECTÓï¾ä
      Óï¾äÐÎʽΪ£ºInsert into Table2(field1,field2,...) select value1,v ......

WindowsÏÂMySQL֨װÒýÆðÎÊÌâµÄ½â¾ö

½â¾öÁËPlugin 'InnoDB' init function returned errorÎÊÌâºÍerror1405ÄǸö°²È«ÉèÖÃÃÜÂëµÇ½ÎÊÌ⣬ÎÒ¸öÈ˾õµÃ¹Ø¼üµãÔÚÓÚɾ³ýC:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\Ŀ¼ÏµÄÊý¾ÝÎļþ£¬µ±È»£¬ÎÒ²»¿ÉÄÜÔÚÖØÏÖÎÊÌâÇóÖ¤ÁË£¬²»¹ý¿´´ËÌùµÄÈË¿ÉÒÔ³¢ÊÔÒ»ÏÂÖ»×ö´Ë²½ÊÇ·ñÄܽâ¾öÎÊÌ⣬µ±È»»¹ÓÐÉ ......

MySqlµÄ·þÎñÆô¶¯²»ÁË

ǰ¶Îʱ¼ä°²×°MySQL, ·Ç³£Ë³Àû, ºÜ¿ì¾Í°²×°ÁË, È»ºó¾­¹ý¼òµ¥µÄÅäÖÃ. ½øÈëMySQLµÄ¿ØÖÆÌ¨, ÊäÈëÃÜÂë. È»ºó¾Í˳ÀûµØ½øÈëµ½Á˹¤×÷״̬.
µ«Êǵ±ÎÒµÚ¶þÌì½øÈëMySQLµÄ¿ØÖÆÌ¨, ÊäÈëÃÜÂëʱ, µÎµÄÒ»Éùºó,Õû¸ö¿ØÖÆÌ¨¾ÍÏûʧÁË.ÖØÐÂÊÔÁ˼¸´Î, ÎÊÌâÒÀ¾É. ¾ÍÉÏÍø°Ù¶ÈÒ»ÏÂ,·¢ÏÖÓв»ÉÙÈËÓöµ½Í¬ÑùµÄÎÊÌâ, ºÜ¶àÈ˶¼ËµÊ±my.iniÅäÖôíÎó, ÓÚÊÇ´ò¿ ......

Linux + JDK + Tomcat + MySQL + JDBC °²×°ÊÖ¼Ç

Linux + JDK + Tomcat + MySQL + JDBC °²×°ÊÖ¼Ç
Ò»¡¢Red Hat Linux
1.·ÖÇø
           
                        | swap  & ......

php»ù´¡Ó¦ÓãºphpÅúÁ¿×ª»»Îļþ±àÂë

±éÀúĿ¼Îļþ£¬Ìæ»»±àÂ벿·Ö£¬É¾³ýÔ­Îļþ£¬ÔÙÖØÐÂתÂëÔ­ÎļþÄÚÈÝ£¬ÖØÐÂÉú³ÉÐÂÎļþ¡£
function explorerdir($sDir){

static $aTempArr=array();
$dp=opendir($sDir);
while ($sFileName = readdir($dp)){

if ($sFileName !='.' && $sFileName !='..'){

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