TP框架-导入与导出

导入数据

导入与导出的安装包360云盘中tp框架-导入与导出的安装包
[python] view plain copy

    <?php  
    //防止中文乱码  
    header('content-type:text/html;charset=utf-8');  
    include 'excel_reader.php';//引入导入文件  
    $data = new Spreadsheet_Excel_Reader(); //实力化类  
    $data->read('./xls/aaaa.xls'); //导入php数组形式  
    //print_r($data);  
    $arr= $data->sheets[0]['cells'];  
    //var_dump($arr);die;6  
    unset($arr[1]);  
    $pdo = new PDO('mysql:host=127.0.0.1;dbname=tp','root','root');  
    $pdo->exec("SET NAMES UTF8");  
    foreach($arr as $key=>$value){  
        $sql = "INSERT INTO login(username,pwd) VALUES ('{$value[1]}','{$value[2]}')";  
        $aa =$pdo->query($sql);  
    }  
    if($aa){  
        echo "导入成功";  
      
    }  




导出数据
[python] view plain copy

    <?php  
      
    header("content-type:text/html;charset=utf-8");  
    include 'excel_download.php';  
    $pdo = new PDO('mysql:host=127.0.0.1;dbname=pingtai','root','root');  
    $pdo ->exec("SET NAMES UTF8");  
    $arr = $pdo->query("SELECT * FROM privileges")->fetchAll(PDO::FETCH_ASSOC);  
    $title = array_keys($arr[1]);  
    $data = new Excel();  
    $data->addHeader($titie);  
    $data->addBody($arr);  
    $data->downLoad('aaa');