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µÄÊ®Áù½øÖƱíʾÔòÊÇ“¿ªÊ¼”µÄ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¡£
Ïà¹ØÎĵµ£º
ÎÒÃǾ³£»áÓöµ½ÐèÒª±í¸´ÖƵÄÇé¿ö£¬È罫һ¸ötable1µÄÊý¾ÝµÄ²¿·Ö×ֶθ´ÖƵ½table2ÖУ¬»òÕß½«Õû¸ötable1¸´ÖƵ½table2ÖУ¬ÕâʱºòÎÒÃǾÍҪʹÓÃSELECT INTO ºÍ INSERT INTO SELECT ±í¸´ÖÆÓï¾äÁË¡£
1.INSERT INTO SELECTÓï¾ä
Óï¾äÐÎʽΪ£ºInsert into Table2(field1,field2,...) select value1,v ......
½â¾öÁËPlugin 'InnoDB' init function returned errorÎÊÌâºÍerror1405ÄǸö°²È«ÉèÖÃÃÜÂëµÇ½ÎÊÌ⣬ÎÒ¸öÈ˾õµÃ¹Ø¼üµãÔÚÓÚɾ³ýC:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\Ŀ¼ÏµÄÊý¾ÝÎļþ£¬µ±È»£¬ÎÒ²»¿ÉÄÜÔÚÖØÏÖÎÊÌâÇóÖ¤ÁË£¬²»¹ý¿´´ËÌùµÄÈË¿ÉÒÔ³¢ÊÔÒ»ÏÂÖ»×ö´Ë²½ÊÇ·ñÄܽâ¾öÎÊÌ⣬µ±È»»¹ÓÐÉ ......
ǰ¶Îʱ¼ä°²×°MySQL, ·Ç³£Ë³Àû, ºÜ¿ì¾Í°²×°ÁË, È»ºó¾¹ý¼òµ¥µÄÅäÖÃ. ½øÈëMySQLµÄ¿ØÖÆÌ¨, ÊäÈëÃÜÂë. È»ºó¾Í˳ÀûµØ½øÈëµ½Á˹¤×÷״̬.
µ«Êǵ±ÎÒµÚ¶þÌì½øÈëMySQLµÄ¿ØÖÆÌ¨, ÊäÈëÃÜÂëʱ, µÎµÄÒ»Éùºó,Õû¸ö¿ØÖÆÌ¨¾ÍÏûʧÁË.ÖØÐÂÊÔÁ˼¸´Î, ÎÊÌâÒÀ¾É. ¾ÍÉÏÍø°Ù¶ÈÒ»ÏÂ,·¢ÏÖÓв»ÉÙÈËÓöµ½Í¬ÑùµÄÎÊÌâ, ºÜ¶àÈ˶¼ËµÊ±my.iniÅäÖôíÎó, ÓÚÊÇ´ò¿ ......
Linux + JDK + Tomcat + MySQL + JDBC °²×°ÊÖ¼Ç
Ò»¡¢Red Hat Linux
1.·ÖÇø
| swap & ......
±éÀúĿ¼Îļþ£¬Ìæ»»±àÂ벿·Ö£¬É¾³ýÔÎļþ£¬ÔÙÖØÐÂתÂëÔÎļþÄÚÈÝ£¬ÖØÐÂÉú³ÉÐÂÎļþ¡£
function explorerdir($sDir){
static $aTempArr=array();
$dp=opendir($sDir);
while ($sFileName = readdir($dp)){
if ($sFileName !='.' && $sFileName !='..'){
......