TP框架-导入与导出

导入数据

导入与导出的安装包360云盘中tp框架-导入与导出的安装包

<?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;6unset($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 "导入成功";}

导出数据

<?phpheader("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');