<?php
header("Content-type: text/html; charset=utf-8");
try{
$conn = new PDO("mysql:host=localhost;dbname=xxx","xxx","xxx");
$conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$conn->query("SET NAMES utf8");
}catch(PDOException $e){
echo"数据库连接失败".$e->getMessage();
}
$user = "select * from users";
$user = $conn->query($user)->fetchAll(PDO::FETCH_ASSOC);
if(!empty($user)){
foreach($user as $key => $val){
$data[$key]['nickname']=$val['uname'];
$data[$key]['mobile']=$val['mobile'];
}
}else{
$data = '暂无信息';
}
//第一步:处理中文文件名:
$ua = $_SERVER["HTTP_USER_AGENT"];
$filename = "用户信息.txt";
$encoded_filename = urlencode($filename);
$encoded_filename = str_replace("+","%20",$encoded_filename);
//第二步:生成TXT文件
header("Content-Type: application/octet-stream");
if (preg_match("/MSIE/",$_SERVER['HTTP_USER_AGENT'])){
header('Content-Disposition:attachment;filename="'.$encoded_filename.'"');
}elseif(preg_match("/Firefox/",$_SERVER['HTTP_USER_AGENT'])){
header('Content-Disposition:attachment;filename*="utf8'.$filename.'"');
}else{
header('Content-Disposition:attachment;filename="'.$filename.'"');
}
//第三步:输出内容
echo json_encode(array('data'=>$data));
/*file_put_contents($filename,json_encode($data),FILE_APPEND);
echo file_get_contents("$filename");*/
?>
php 生成txt文件并下载
最新推荐文章于 2022-05-17 23:21:52 发布