西部数码主机 | 阿里云主机| 虚拟主机 | 服务器 | 返回乐道官网
当前位置: 主页 > php教程 > php教程 >

PHP导入导出CSV

时间:2016-07-31 22:20来源:未知 作者:好模板 点击:
PHP导入导出CSV代码实例 一、建表 //建立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=M
PHP导入导出CSV代码实例

一、建表

//建立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;

二、导出CSV

//导出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);//将数据导出
    }

   /*
    *输出CSV文件
    *$filename:文件名称 $data:要写入的数据
    */
    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;
    }

三、导入CSV

//导入csv
    public function import()
    {
        if (!$_FILES['file']['name']){//判断是否为空
            echo '上传文件不能为空,请导入csv文件';exit;
        }

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

        if ($extension != 'csv') {//判断是否为csv文件
            echo '该文件不是csv文件,请导入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 "导入失败!";exit;
        }else{
            echo "导入完成!";exit;
        }
    }
(责任编辑:好模板)
顶一下
(0)
0%
踩一下
(0)
0%
------分隔线----------------------------
栏目列表
热点内容