PHP读取CSV(Excel)文件

<?php
    // 连接数据库
    mysql_connect('localhost','root','root'); 
    mysql_select_db('test');

    // 操作csv
    $handle = fopen ('test.csv','r');
    $sql="insert into `test` (`id`,`name`,`sex`,`nation`) values ('',";
        while ($data = fgetcsv ($handle)) {
           $num = count ($data);
           for ($i=0; $i<$num; $i++) {
               if($i == $num-1){
                   $sql .= "'".$data[$i]."')";
                   break;
                }
               $sql .= "'".$data[$i]."',";
           }
            mysql_query($sql);
            $sql="insert into `test` (`id`,`name`,`sex`,`nation`) values ('',";
        }

    fclose ($handle);

cvs_detail.php

<?php
    // 定义获取时间函数
    function getmicrotime(){
        list($usec, $sec) = explode(' ',microtime());
        return ((float)$usec + (float)$sec);
    }

    $time_start = getmicrotime();


    // 连接数据库

    /*
    include("database_class.php");
    $db = new Database;
    */

    mysql_connect('localhost','root','root'); 
    mysql_select_db('test');

    // 操作csv
    $handle = fopen ('test.csv','r');
    $sql="insert into `test` (`id`,`name`,`sex`,`nation`) values ('',";
        while ($data = fgetcsv ($handle)) {
           $num = count ($data);
           for ($i=0; $i<$num; $i++) {
               if($i == $num-1){
                   $sql .= "'".$data[$i]."')";
                   break;
                }
               $sql .= "'".$data[$i]."',";
           }

            print '<br>';
            echo $sql.'<br>';

            mysql_query($sql);

            echo 'sql语句执行成功！<br>';
            $sql="insert into `test` (`id`,`name`,`sex`,`nation`) values ('',";
        }

    fclose ($handle);

    // 显示执行时间
    $time_end = getmicrotime();
    $time = $time_end - $time_start;
    echo "程式执行时间：".$time."秒<br>";

    // 显示数据库结果
    $result = mysql_query('select * from `test`');
    while($row = mysql_fetch_array($result)){
        echo $row['id'],'<br>',$row['name'],'<br>',$row['sex'],'<br>',$row['nation'],'<br>';
    }
?> 

转载于:https://www.cnblogs.com/hxworm/articles/2582133.html