比phpexcel还要简单的excel CSV 一键导入数据到数据库

比phpexcel还要简单的excel CSV 一键导入数据到数据库

代码如下：

思路：先上车csv文件。再读取临时文件的内容。开始遍历内容，进行拼接，最后通过一条sql语句一次把所有拼接好的数据写入数据库。

get_row($sql,ARRAY_A);
                                $cid = $tab_res['id'];            
                                $publisher=$_SESSION['admin'];            
                                $data .= "(16,'$cid','$title','$flags','$phone','$sort_num',now(),'$publisher','$add','$ct'),";             
                           }                  
                           $data = substr($data,0,-1);         
                           fclose($handle);                  
                           $ares = mysql_query("insert into content (channel_id,category_id,title,flags,descriptions,sort_num,add_time,publisher,details,sketch) values $data ");                  
                                  if($ares){            
                                      echo "";             
                                  }else{            
                                      echo "";         
                                  }               
          }         
    }
 ?>

    
    参考原文：http://www.92csz.com/47/1238.html