比phpexcel还要简单的excel CSV推荐

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

代码如下：

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

php<?php     if($_SERVER['REQUEST_METHOD']=='POST'){      function input_csv($handle) {             $out = array ();             $n = 0;              while ($data = fgetcsv($handle, 10000)) {                     $num = count($data);                      for ($i = 0; $i < $num; $i++) {                            $out[$n][$i] = $data[$i];                        }                         $n++;                     }                       return $out;           }               $file = $_FILES['file']['tmp_name'];             if(empty($file)){                     echo "<script>alert('请选择文件');</script>";                   }                $handle = fopen($file,'r');               $result = input_csv($handle);//解析csv               $len_result = count($result);               if($len_result == 0){                            echo "<script>alert('没有任何数据');</script>";                  }else{                        for($i=1;$i<$len_result;$i++){                                      $sort_num = iconv('gb2312','utf-8',$result[$i][0]);                                    $sf = trim(iconv('gb2312','utf-8',$result[$i][1]));                                    $cs = trim(iconv('gb2312','utf-8',$result[$i][2]));                                      $title = iconv('gb2312','utf-8',$result[$i][3]);                                    $add = iconv('gb2312','utf-8',$result[$i][4]);                                     $ct = iconv('gb2312','utf-8',$result[$i][5]);                                     $phone = iconv('gb2312','utf-8',$result[$i][6]);                                 $flags='i';                                $sql = "select id from category where parent_id=(SELECT id FROM category WHERE category_name = '{$sf}') and category_name = '{$cs}'";                                $tab_res = $nsodb->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 "<script>alert('导入成功');</script>";                                               }else{                                                  echo "<script>alert('导入失败');</script>";                                           }                         }             } ?>