[常用修复工具]把pw_members会员用excel导出 [复制链接]

上一主题下一主题查看指定楼层

离线太史慈

只看楼主倒序阅读使用道具楼主发表于: 2011-05-18

保存成user_excel.php放到论坛根目录下，然后浏览器执行即可

<?php
require_once('global.php');
$excel_data = '';
$query = $db->query("SELECT m.username,md.onlineip FROM pw_members m LEFT JOIN pw_memberdata md USING(uid)");
while ($rt = $db->fetch_array($query)) {
$onlineip = explode("|",$rt['onlineip']);
//$rt['username'] = iconv("utf-8","gbk",$rt['username']);//编码啊！！！
$excel_data .= $rt['username']."\t".$onlineip[0]."\t\n";
}
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header ("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate");
header ("Pragma: no-cache");
header ("Content-type: application/x-msexcel");
header ("Content-Disposition: attachment; filename=EmplList.xls" );
header ("Content-Description: PHP/INTERBASE Generated Data" );
echo $excel_data;

[url=http://www.phpwind.com]phpwind[/url]

离线太史慈

只看该作者沙发发表于: 2011-05-18

txt格式导出

<?php
require_once('global.php');
$excel_data = '';
$query = $db->query("SELECT m.username,md.onlineip FROM pw_members m LEFT JOIN pw_memberdata md USING(uid)");
while ($rt = $db->fetch_array($query)) {
$onlineip = explode("|",$rt['onlineip']);
$rt['username'] = iconv("utf-8","gbk",$rt['username']);
$excel_data .= $rt['username']."\t".$onlineip[0]."\t\n";
}
$file_ending = "txt";
$dbTablename = "user_txt";
header("Content-Type: application/$file_type");
header("Accept-Ranges: bytes");
header("Content-Disposition: attachment; filename=$dbTablename.$file_ending");
header("Pragma: no-cache");
header("Expires: 0");
echo $excel_data;

[url=http://www.phpwind.com]phpwind[/url]


	关闭您还没有登录，快捷通道只有在登录后才能使用。立即登录还没有帐号？赶紧注册一个