그누보드 회원을 엑셀파일로 정보
그누보드 회원을 엑셀파일로본문
그누보드 회원을 엑셀파일로 못하나요?
댓글 전체
adm/member_excle.php 이게 엑셀저장소스인데 없으신가여?
<?
$sub_menu = "200100";
include_once("./_common.php");
if( !$is_admin ) alert("관리자만 이용이 가능합니다.");
if ($w == 'u')
check_demo();
auth_check($auth[$sub_menu], "w");
//check_token();
Header("Content-Type: application/octet-stream");
Header("Content-Disposition: attachment; filename=member_list_".date('Ymd').".csv");
Header("Pragma: no-cache");
Header("Expires: 0");
echo "회원번호, 회원아이디, 비밀번호, 회원이름, 닉네임, 메일, 레벨, 주민번호, 핸드폰, 전화, 포인트, 가입일\n";
$sql = "select mb_no, mb_id, mb_password, mb_name, mb_nick, mb_email, mb_level, mb_jumin, mb_hp, mb_tel, mb_point, mb_datetime from $g4[member_table] where mb_level < 10 limit 1000";
$result = mysql_query($sql);
while ($row=mysql_fetch_array($result)) {
//print_r2($row);
echo "$row[mb_no],";
echo "$row[mb_id],";
echo "$row[mb_password],";
echo "$row[mb_name],";
echo "$row[mb_nick],";
echo "$row[mb_email],";
echo "$row[mb_level],";
echo "$row[mb_jumin],";
echo "$row[mb_hp],";
echo "$row[mb_tel],";
echo "$row[mb_point],";
echo "$row[mb_datetime],";
echo "\n";
}
echo "\n";
?>
$sub_menu = "200100";
include_once("./_common.php");
if( !$is_admin ) alert("관리자만 이용이 가능합니다.");
if ($w == 'u')
check_demo();
auth_check($auth[$sub_menu], "w");
//check_token();
Header("Content-Type: application/octet-stream");
Header("Content-Disposition: attachment; filename=member_list_".date('Ymd').".csv");
Header("Pragma: no-cache");
Header("Expires: 0");
echo "회원번호, 회원아이디, 비밀번호, 회원이름, 닉네임, 메일, 레벨, 주민번호, 핸드폰, 전화, 포인트, 가입일\n";
$sql = "select mb_no, mb_id, mb_password, mb_name, mb_nick, mb_email, mb_level, mb_jumin, mb_hp, mb_tel, mb_point, mb_datetime from $g4[member_table] where mb_level < 10 limit 1000";
$result = mysql_query($sql);
while ($row=mysql_fetch_array($result)) {
//print_r2($row);
echo "$row[mb_no],";
echo "$row[mb_id],";
echo "$row[mb_password],";
echo "$row[mb_name],";
echo "$row[mb_nick],";
echo "$row[mb_email],";
echo "$row[mb_level],";
echo "$row[mb_jumin],";
echo "$row[mb_hp],";
echo "$row[mb_tel],";
echo "$row[mb_point],";
echo "$row[mb_datetime],";
echo "\n";
}
echo "\n";
?>
