慧创WEB开发www.hcseo.com专注WEB开发 专注用户体验

为了便于记录查看，有时需要把后台大量查询出来的数据，导出成文档，作为存档记录

$keyword=trim($_REQUEST['keyword']);//根据查询，找寻对应数据

$txt_name=date("md")."-后台产品管理.txt";
$encoded_filename = urlencode($txt_name);  
$encoded_filename = str_replace("+", "%20", $encoded_filename);  //这样可支持中文名字

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 . '"');  
} 
 

$query_3 = "select * from products WHERE 1 $where  order by id desc";
$total_str_3 = @mysql_query ( $query_3 );
$total_num_3 = @mysql_num_rows ( $total_str_3 );
for($k = 0; $k < $total_num_3; $k ++) {
 $txt_import = mysql_fetch_array ( $total_str_3 );
 $str.=$txt_import['name']."\r\n";//此例只导出产品名，每一个换一行
}
echo $str;
exit;//加上退出语句，否则会把你后面的内容也一并输出