|
Server : Apache System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : tkt_travelbus ( 1137) PHP Version : 7.0.0p1 Disable Function : mysql_pconnect Directory : /tkt_travelbus/www/admin/member/ |
Upload File : |
<?
include "../include/top_proc.html";
// 엑셀 파일명 설정
$FileName = "회원목록";
$FileName = $FileName."_".Date("Ymd").".xls";
$FileName = urlencode($FileName); // UTF-8
// 엑셀 파일로 변환 헤더
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$FileName");
header("Content-Description: PHP4 Generated Data" );
//배열에 저장
$data = array();
$sql_where = stripslashes($sql_where);
$data = member_fetch($sql_where,"",0,1000);
?>
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 10">
<style>
<!--
table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
@page
{margin:1.0in .75in 1.0in .75in;
mso-header-margin:.5in;
mso-footer-margin:.5in;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo/>
</x:Print>
<x:Selected/>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
</x:ExcelWorkbook>
</xml><![endif]-->
<meta http-equiv=Content-Language content=ko>
</head>
<body>
<table cellspacing="0" cellpadding="2" bordercolor="#999999" bordercolordark="#FFFFFF" border="1">
<tr height="35">
<th align="center" bgcolor="#E7E7E7">No.</th>
<th align="center" bgcolor="#E7E7E7">ID</th>
<th align="center" bgcolor="#E7E7E7">이름</th>
<th align="center" bgcolor="#E7E7E7">이메일</th>
<th align="center" bgcolor="#E7E7E7">성별</th>
<th align="center" bgcolor="#E7E7E7">휴대폰번호</th>
<th align="center" bgcolor="#E7E7E7">이메일수신</th>
<th align="center" bgcolor="#E7E7E7">SMS수신</th>
<th align="center" bgcolor="#E7E7E7">가입일시</th>
</tr>
<?
for($i=0;$i<count($data);$i++){
$row = $data[$i];
$num = count($data)-$i;
?>
<tr>
<td align="center"> <?=$num?></td>
<td align="center"> <?=$row['mb_id']?></td>
<td align="center"> <?=$row['mb_nm']?></td>
<td align="center"> <?=$row['mb_email']?></td>
<td align="center"> <?=$row['mb_gend2']?></td>
<td align="center"> <?=$row['mb_phone']?></td>
<td align="center"> <?=$row['mb_email_yn']?></td>
<td align="center"> <?=$row['mb_sms_yn']?></td>
<td align="center"> <?=$row['ins_dt3']?></td>
</tr>
<?
}
?>
</table>
</body>
</html>