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

ÈçºÎͨ¹ýPHP½«excelµÄÊý¾Ýµ¼ÈëMySQLÖÐ

  ÈçºÎͨ¹ýPHP½«excelµÄÊý¾Ýµ¼ÈëMySQLÖÐ
    ÔÚ¿ª·¢PHP³ÌÐòʱ£¬ºÜ¶àʱºòÎÒÃÇ»áÓн«Êý¾ÝÅúÁ¿µ¼ÈëÊý¾Ý¿âµÄÐèÇó£¬ÈçѧÉúÐÅÏ¢ÅúÁ¿Ìí¼Óµ½Êý¾Ý¿âÖУ¬¶øÊÂÏÈÓÃexcel±àÅźã¬¶ÔexcelʵÐвÙ×÷£¬±ãÊÇÎÒÃDZȽϳ£ÓõÄÑ¡Ôñ·½Ê½¡£
     ÔÚ¶ÔexcelµÄ²Ù×÷ÖУ¬phpExcelReade±ãÊǺܶàÈ˵Ĺ²Í¬Ñ¡Ôñ¡£ÔÚ¾ßÌåʵÏÖÖУ¬ÎÒÃÇ¿ÉÒÔÒÔÎļþÉÏ´«·½Ê½½«excelÎļþÉÏ´«µ½·þÎñÆ÷ÖеÄij¸öλÖã¬Í¨¹ýÒÔϲÙ×÷½«excelÖеÄÊý¾Ýµ¼Èëµ½Êý¾Ý¿âºó£¬ÔÚ½«ÉÏ´«µÄÎļþɾ³ý¼´¿É¡£
´úÂëÈçÏ£º
   
    $dir=dirname(__FILE__);                       //»ñÈ¡µ±Ç°½Å±¾µÄ¾ø¶Ô·¾¶
    $dir=str_replace("\\","/",$dir)."/";
    $filename='uploadFile.xls'; //¿ÉÒÔ¶¨ÒåÒ»¸öÉÏ´«ºóµÄÎļþÃû³Æ
    $result=move_uploaded_file($_FILES['upload']['tmp_name'],$dir.$filename);//¼ÙÈçÉÏ´«µ½µ±Ç°Ä¿Â¼ÏÂ
    if($result)  //Èç¹ûÉÏ´«Îļþ³É¹¦£¬¾ÍÖ´Ðе¼Èëexcel²Ù×÷
    {
     require_once 'phpExcelReader/Excel/reader.php';
     $data = new Spreadsheet_Excel_Reader();
     $data->setOutputEncoding('utf-8');//ÉèÖÃÔÚÒ³ÃæÖÐÊä³öµÄ±àÂ뷽ʽ,¶ø²»ÊÇutf8
      //¸Ã·½·¨»á×Ô¶¯ÅжÏÉÏ´«µÄÎļþ¸ñʽ£¬²»·ûºÏÒªÇó»áÏÔʾ´íÎóÌáʾÐÅÏ¢(´íÎóÌáʾÐÅÏ¢Ôڸ÷½·¨ÄÚ²¿)¡£
     $data->read("$filename");  //¶ÁÈ¡ÉÏ´«µ½µ±Ç°Ä¿Â¼ÏÂÃû½Ð$filenameµÄÎļþ
     error_reporting(E_ALL ^ E_NOTICE);
     //Èç¹ûexcel±í´ø±êÌ⣬Ôò´Ó$i=2¿ªÊ¼£¬È¥µôexcel±íÖеıêÌⲿ·Ö(Òª½«$i<=¸ÄΪ$i<·ñÔò»á²åÈëÒ»Ìõ¶àÓàµÄ¿ÕÊý¾Ý)
     for ($i = 2; $i < $data->sheets[0]['numRows']; $i++)
     {
      $sql = "INSERT INTO user (stuid,class,name,sex,classNum,tel,addr,remark)


Ïà¹ØÎĵµ£º

mysql utf 8 ÂÒÂë½â¾ö======ÕýÈ·µÄ

mysql utf-8 ÂÒÂë½â¾ö
Êý¾Ý¿â 2009-09-15 12:34:33 ÔĶÁ327 ÆÀÂÛ0 ×ֺţº´óÖÐС
ÔÚÍøÉÏ¿´¹ýºÜ¶à½â¾ömysqlÂÒÂëµÄÌû×Ó£¬¿ÉÊÇдµÄ²»ÊÇÂÞÀïÂÞà¾͹ýÓÚ¸´ÔÓ¡£ÆäʵÂÒÂëûÄÇô¸´ÔÓ£¬ÊÇÍøÉϵĴóÏÀÃÇÏë¶àÁË¡£ÎÒÑо¿¹ýÒ»¶ÎÈÕ×Ó£¬×ܽá³öÒ»Ì××Ô¼ºµÄ½â¾ö·½°¸£¬Èç¹ûÄ㻹û½â¾öÂÒÂë¾ÍÓÃÎҵķ½·¨ÊÔһϡ£Îҵķ½°¸²»ÊÇ×îºÃµÄ£¬È´ÊÇ×î¼òµ¥Ò ......

ÔõÑù½øÐÐMysqlÔ¶³ÌÁ¬½Ó


 ÔõÑù½øÐÐMysqlÔ¶³ÌÁ¬½Ó
ÎÒÓÃ:
grant all privileges on *.* to ´´½¨µÄÓû§Ãû@localhost identified by "ÃÜÂë";
flush privileges; \* ˢиղŵÄÄÚÈÝ*\
========================
mysqlĬÈÏÊDz»ÔÊÐíÔ¶³ÌÁ¬½ÓµÄ£¬ÒòΪÓкܴóµÄ°²È«Òþ»¼¡£¡£
ËùÒÔÐèÒªÊÖ¶¯Ôö¼Ó¿ÉÒÔÔ¶³Ì·ÃÎÊÊý¾Ý¿âµÄÓû§¡£
ÏÂÃæÊÇÁ¬½Ó·½Ê½£º
# m ......

MySQLµÄLOCK TABLES/UNLOCK TABLES

LOCK TABLES/UNLOCK TABLES ¾ä·¨
LOCK TABLES tbl_name [AS alias] {READ [LOCAL] | [LOW_PRIORITY] WRITE}
[, tbl_name [AS alias] {READ [LOCAL] | [LOW_PRIORITY] WRITE} ...]
...
UNLOCK TABLES
LOCK TABLES Ϊµ±Ç°Ïß³ÌËø¶¨±í¡£UNLOCK TABLES Êͷŵ±Ç°Ïß³ÌÓµÓеÄËùÓÐËø¶¨¡£µ±Ï̷߳¢³öÁíÒ»¸ö LOCK TABLES£¬»òµ±Óë·þ ......

PHP/MYSQLʵÏÖ°´×Öĸ¼ìË÷

·½·¨Ò»£º½¨Ò»¸öÆ´Òô±í t_cosler £¬´æ·Åÿ¸ö×Öĸ¿ªÍ·µÄµÚÒ»¸öºº×ֵıàºÅºÍ×îºóÒ»¸öºº×ֵıàºÅ¡£   
BatchFile code+------+--------+-------+  
| f_PY | cBegin | cEnd  |  
+------+--------+-------+  
| A    |  45217 | 45252 | & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ