一、建表

//建立user表
CREATE TABLE `user` (
    `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(32) NOT NULL,
    `sex` char(10) NOT NULL,
    `age` int(3) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
)ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

二、導(dǎo)出CSV

//導(dǎo)出csv
    public function export()
    {
        $str = '';
        $header = mb_convert_encoding('姓名鹰晨，性別，年齡\n',"GBK","UTF-8");
        $sql = 'SELECT * FROM `user`';
        $result = mysql_query($sql);
        while ($row = mysql_fetch_array($result)) {
            $name = mb_convert_encoding($row['name'],"GBK","UTF-8");
            $sex = mb_convert_encoding($row['sex'],"GBK","UTF-8");
            $age = $row['age'];
            $str .= $name.$sex.$age."\n";
        }
        $data = $header.$str;
        $filename = 'user_'.time().'.csv';
        $this->writeDataToCsv($filename, $data);//將數(shù)據(jù)導(dǎo)出
    }

   /*
    *輸出CSV文件
    *$filename:文件名稱 $data:要寫入的數(shù)據(jù)
    */
    public function writeDataToCsv($filename, $data)
    {
        header("Content-type:text/csv"); 
        header("Content-Disposition:attachment;filename=".$filename); 
        header('Cache-Control:must-revalidate,post-check=0,pre-check=0'); 
        header('Expires:0'); 
        header('Pragma:public');
        echo $data;
    }

三、導(dǎo)入CSV

//導(dǎo)入csv
    public function import()
    {
        if (!$_FILES['file']['name']){//判斷是否為空
            echo '上傳文件不能為空标捺，請導(dǎo)入csv文件';exit;
        }

        $extension = pathinfo($_FILES['file']['name'], PATHINFO_EXTENSION);//取后綴名

        if ($extension != 'csv') {//判斷是否為csv文件
            echo '該文件不是csv文件，請導(dǎo)入csv文件';exit;
        }
        
        $file_path = './upload/user_'.time().'.csv';
        $status = move_uploaded_file($_FILES['file']['tmp_name'], $file_path);//將文件保存到指定的路徑

        if (!$status) {
            echo "上傳失敗!";exit;
        }

        $handle = fopen($file_path, "r");
        $sql_str = '';
        while (($fileop = fgetcsv($handle, 1000, ",")) !== false) {
            $name = mb_convert_encoding($fileop[0], "UTF-8", "GBK");
            $sex = mb_convert_encoding($fileop[1], "UTF-8", "GBK");
            $age = $fileop[2];
            $str = "('".$name."', '".$sex."', $age), ";
            $sql_str .= $str;
        }
        $sqlstr = substr($sql_str, 0, strlen($sql_str)-2);//去除最后的空格和逗號
        fclose($handle);
        $sql = "INSERT INTO `user` (`name`, `sex`, `age`) VALUES $sqlstr";//sql語句
        $query = mysql_query($sql);
        if (!$query) {
            echo "導(dǎo)入失斎嗟帧亡容！";exit;
        }else{
            echo "導(dǎo)入完成！";exit;
        }
    }