down_addr.php

来自「一个很好的同学录,PHP+TXT,没有数据库的网友的最好选择」· PHP 代码 · 共 26 行

<?
session_start();
if($_SESSION['power']<1) {$error="你没有这个权限!";$include("inc_error.php");}
else {
	if(!$_MYSQL_INC) include("conf_mysql.php");
	$Myres=mysql_query("select * from mc_member order by id",$Mylink);
	header("Content-type: application/txt");
	header("Content-Disposition: attachment; filename=地址簿.txt");
	$tmp=sprintf("%12s %8s %4s %10s %50s %50s %50s %6s %15s %15s %10s\r\n","用户名","姓名","性别","生日","Email","联系单位","通信地址","邮编","联系电话","手机号码","QQ号码");
	echo $tmp;
	while($mObj=mysql_fetch_object($Myres)){
		printf("%12s %8s %4s %10s %50s %50s %50s %6s %15s %15s %10s\r\n",
				$mObj->id,
				$mObj->name,
				($mObj->sex==0?"男":"女"),
				$mObj->birthday,
				$mObj->Email,
				$mObj->unit,
				$mObj->address,
				$mObj->postcode,
				$mObj->phone,
				$mObj->mobile,
				$mObj->QQ);
	}
}
?>