게시판 내용을 엑셀로 출력하는거 문의드려요~ 정보
게시판 내용을 엑셀로 출력하는거 문의드려요~본문
안녕하세요
검색이란 검색은 다해보고 맘에들게 엑셀출력할수 있게 구축은 했었는데...
끝내 포기했네요.. ㅠㅠ 그놈에 날자가 먼지 ㅠㅠ
그래서 회원db에서 엑셀로 출력하는걸 수정해서 만들고 있는데요
검색버튼을 눌러도 아무런 반응이 없네요... 왜그럴까요? ㅠㅠ
제꺼 list.skin.php 에는
<a href='<?=$board_skin_path?>/excel_all.php?bo_table=<?=$bo_table?>' target='_blank'>Excel 테스트</a>
이렇게 설정하고
excel_all.php는 이렇게 수정을 했습니다.
<?
if ($sv =="yes") {
if ($ms =="excel"){
$g4[title] = "엑셀 문서 다운로드";
header( "Content-type: application/vnd.ms-excel" );
header( "Content-Disposition: attachment; filename=today.xls" );
} else if ($ms =="power"){
$g4[title] = "파워포인트 문서 다운로드";
header( "Content-type: application/vnd.ms-powerpoint" );
header( "Content-Disposition: attachment; filename=today.ppt" );
} else if ($ms =="word"){
$g4[title] = "워드 문서 다운로드";
header( "Content-type: application/vnd.ms-word" );
header( "Content-Disposition: attachment; filename=today.doc" );
} else if ($ms =="memo"){
$g4[title] = "메모 문서 다운로드";
header( "Content-type: application/vnd.ms-notepad" );
header( "Content-Disposition: attachment; filename=today.txt" );
} else {
$g4[title] = "엑셀 문서 다운로드";
header( "Content-type: application/vnd.ms-excel" );
header( "Content-Disposition: attachment; filename=today.xls" );
}
header( "Content-Description: PHP Generated Data" );
// 다운로드 모드에서의 넘어온 값에 대한처리
if($code =="1"){
$m_que = "$g4[write_today_table] order by wr_subject desc";
}else if($code =="2"){
$m_que = "$g4[write_today_table] order by ca_name desc";
}else if($code =="3"){
$m_que = "$g4[write_today_table] order by wr_name desc";
}else if($code =="4"){
$m_que = "$g4[write_today_table] order by wr_datetime desc";
}else if($code =="5"){
$m_que = "$g4[write_today_table] order by wr_content desc";
}else if($code =="6"){
$m_que = "$g4[write_today_table] order by wr_1 desc";
}else if($code =="7"){
$m_que = "$g4[write_today_table] order by wr_2 desc";
}else if($code =="8"){
}
$result = mysql_query("select * from $m_que");
$temp = mysql_fetch_array(mysql_query("select count(*) from $g4[write_today_table] $m_que"));
$number=$temp[0]
?>
<html>
<head>
<title><?=$g4[title]?> -페이지-</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
.txt {mso-number-format:'\@'}
</style>
</head>
<body>
<table width=100% cellpadding=0 cellspacing=0 border=1>
<tr align=center height=25 bgcolor=999999>
<td style=font-weight:bold;>번호</td>
<td style=font-weight:bold;>제목</td>
<td style=font-weight:bold;>파트명</td>
<td style=font-weight:bold;>이름</td>
<td style=font-weight:bold;>작성일</td>
<td style=font-weight:bold;>주요이슈 (주간계획/현 주요문제점/비고)</td>
<td style=font-weight:bold;>금일 실적</td>
<td style=font-weight:bold;>명일 계획</td>
</tr>
<?
while($data=mysql_fetch_array($result))
{
echo"
<tr align=center height=24>
<td>$number</td>
<td>$data[wr_subject]</td>
<td>$data[ca_name]</td>
<td>$data[wr_name]</td>
<td class='txt'>$data[wr_datetime]</td>
<td class='txt'>$data[wr_content]</td>
<td class='txt'>$data[wr_1]</td>
<td class='txt'>$data[wr_2]</td>
</tr>";
$number--;
}
echo "
</table>
</body>
</html>";
}
?>
<html>
<head>
<title><?=$g4[title]?> -페이지-</title>
<? if (!$ks) { ?>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
<? } else { ?>
<meta http-equiv="Content-Type" content="text/html; charset=<?=$ks?>">
<? } ?>
<style type="text/css">
.txt {mso-number-format:'\@'}
</style>
</head>
<body>
<form name=search_member method=get action=<?=$PHP_SELF?>>
<table width=850 cellpadding=1 cellspacing=1 border=1>
<tr height=20 bgcolor=eeeeee>
<td>
<select name='sv'>
<option value='no'>웹에서바로보기</option>
<option value='yes'>다운로드받기</option>
</select>
<select name='ks'>
<option value='euc-kr'>언어선택</option>
<option value='euc-kr'>한국어</option>
<option value='utf-8'>유니코드</option>
<option value='euc-jp'>일본어</option>
<option value='gb2312'>중국어</option>
<option value='iso-8859-1'>영어</option>
</select>
<select name='ms'>
<option value=''>파일선택</option>
<option value='excel'>엑셀파일</option>
<option value='power'>파워포인트</option>
<option value='word'>워드문서</option>
<option value='memo'>워드패드</option>
</select>
<select name='code'>
<option value='1'>분류(정렬)선택</option>
<option value='2'>제목</option>
<option value='3'>파트명</option>
<option value='4'>이름</option>
<option value='5'>작성일</option>
<option value='6'>주요이슈사항</option>
<option value='7'>금일실적</option>
<option value='8'>명일계획</option>
</select>
검색or레벨지정: <input type=text name='name' size=12 maxlength=22 value=''>
<input type=submit class=submit value=보기/다운로드>
</form>
</td>
<td>
<form name=search_member2 method=get action=<?=$PHP_SELF?>>
<input type=hidden name='sv' value=''>
<input type=hidden name='ks' value=''>
<input type=hidden name='ms' value=''>
<input type=hidden name='code' value=''>
<input type=hidden name='name' value=''>
<input type=submit class=submit value=초기화>
</form>
</td>
</tr>
</table>
<?
if ($sv =="no") {
// 웹상에서 바로보기 이며 넘어온 값에 대한처리
if($code =="1"){
$m_que = "$g4[write_today_table] order by wr_subject desc";
}else if($code =="2"){
$m_que = "$g4[write_today_table] order by ca_name desc";
}else if($code =="3"){
$m_que = "$g4[write_today_table] order by wr_name desc";
}else if($code =="4"){
$m_que = "$g4[write_today_table] order by wr_datetime desc";
}else if($code =="5"){
$m_que = "$g4[write_today_table] order by wr_content desc";
}else if($code =="6"){
$m_que = "$g4[write_today_table] order by wr_1 desc";
}else if($code =="7"){
$m_que = "$g4[write_today_table] order by wr_2 desc";
}else if($code =="8"){
}
$result = mysql_query("select * from $m_que");
$temp = mysql_fetch_array(mysql_query("select count(*) from $g4[write_today_table] $m_que"));
$number=$temp[0]
?>
<table width=2000 cellpadding=0 cellspacing=0 border=1>
<tr align=center height=25 bgcolor=999999>
<td style=font-weight:bold;>번호</td>
<td style=font-weight:bold;>제목</td>
<td style=font-weight:bold;>파트명</td>
<td style=font-weight:bold;>이름</td>
<td style=font-weight:bold;>작성일</td>
<td style=font-weight:bold;>주요이슈 (주간계획/현 주요문제점/비고)</td>
<td style=font-weight:bold;>금일 실적</td>
<td style=font-weight:bold;>명일 계획</td>
</tr>
<?
while($data=mysql_fetch_array($result))
{
echo"
<tr align=center height=24>
<td>$number</td>
<td>$data[wr_subject]</td>
<td>$data[ca_name]</td>
<td>$data[wr_name]</td>
<td class='txt'>$data[wr_datetime]</td>
<td class='txt'>$data[wr_content]</td>
<td class='txt'>$data[wr_1]</td>
<td class='txt'>$data[wr_2]</td>
</tr>";
$number--;
}
echo "</table>";
}
?>
</body>
</html>
근데 중요한거는 클릭해도 반응이 없어요 ㅠㅠ
고수님들 도움좀 요청드려요 하루종일 머리꺠질거 같아요 흑흑...
검색이란 검색은 다해보고 맘에들게 엑셀출력할수 있게 구축은 했었는데...
끝내 포기했네요.. ㅠㅠ 그놈에 날자가 먼지 ㅠㅠ
그래서 회원db에서 엑셀로 출력하는걸 수정해서 만들고 있는데요
검색버튼을 눌러도 아무런 반응이 없네요... 왜그럴까요? ㅠㅠ
제꺼 list.skin.php 에는
<a href='<?=$board_skin_path?>/excel_all.php?bo_table=<?=$bo_table?>' target='_blank'>Excel 테스트</a>
이렇게 설정하고
excel_all.php는 이렇게 수정을 했습니다.
<?
if ($sv =="yes") {
if ($ms =="excel"){
$g4[title] = "엑셀 문서 다운로드";
header( "Content-type: application/vnd.ms-excel" );
header( "Content-Disposition: attachment; filename=today.xls" );
} else if ($ms =="power"){
$g4[title] = "파워포인트 문서 다운로드";
header( "Content-type: application/vnd.ms-powerpoint" );
header( "Content-Disposition: attachment; filename=today.ppt" );
} else if ($ms =="word"){
$g4[title] = "워드 문서 다운로드";
header( "Content-type: application/vnd.ms-word" );
header( "Content-Disposition: attachment; filename=today.doc" );
} else if ($ms =="memo"){
$g4[title] = "메모 문서 다운로드";
header( "Content-type: application/vnd.ms-notepad" );
header( "Content-Disposition: attachment; filename=today.txt" );
} else {
$g4[title] = "엑셀 문서 다운로드";
header( "Content-type: application/vnd.ms-excel" );
header( "Content-Disposition: attachment; filename=today.xls" );
}
header( "Content-Description: PHP Generated Data" );
// 다운로드 모드에서의 넘어온 값에 대한처리
if($code =="1"){
$m_que = "$g4[write_today_table] order by wr_subject desc";
}else if($code =="2"){
$m_que = "$g4[write_today_table] order by ca_name desc";
}else if($code =="3"){
$m_que = "$g4[write_today_table] order by wr_name desc";
}else if($code =="4"){
$m_que = "$g4[write_today_table] order by wr_datetime desc";
}else if($code =="5"){
$m_que = "$g4[write_today_table] order by wr_content desc";
}else if($code =="6"){
$m_que = "$g4[write_today_table] order by wr_1 desc";
}else if($code =="7"){
$m_que = "$g4[write_today_table] order by wr_2 desc";
}else if($code =="8"){
}
$result = mysql_query("select * from $m_que");
$temp = mysql_fetch_array(mysql_query("select count(*) from $g4[write_today_table] $m_que"));
$number=$temp[0]
?>
<html>
<head>
<title><?=$g4[title]?> -페이지-</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
.txt {mso-number-format:'\@'}
</style>
</head>
<body>
<table width=100% cellpadding=0 cellspacing=0 border=1>
<tr align=center height=25 bgcolor=999999>
<td style=font-weight:bold;>번호</td>
<td style=font-weight:bold;>제목</td>
<td style=font-weight:bold;>파트명</td>
<td style=font-weight:bold;>이름</td>
<td style=font-weight:bold;>작성일</td>
<td style=font-weight:bold;>주요이슈 (주간계획/현 주요문제점/비고)</td>
<td style=font-weight:bold;>금일 실적</td>
<td style=font-weight:bold;>명일 계획</td>
</tr>
<?
while($data=mysql_fetch_array($result))
{
echo"
<tr align=center height=24>
<td>$number</td>
<td>$data[wr_subject]</td>
<td>$data[ca_name]</td>
<td>$data[wr_name]</td>
<td class='txt'>$data[wr_datetime]</td>
<td class='txt'>$data[wr_content]</td>
<td class='txt'>$data[wr_1]</td>
<td class='txt'>$data[wr_2]</td>
</tr>";
$number--;
}
echo "
</table>
</body>
</html>";
}
?>
<html>
<head>
<title><?=$g4[title]?> -페이지-</title>
<? if (!$ks) { ?>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
<? } else { ?>
<meta http-equiv="Content-Type" content="text/html; charset=<?=$ks?>">
<? } ?>
<style type="text/css">
.txt {mso-number-format:'\@'}
</style>
</head>
<body>
<form name=search_member method=get action=<?=$PHP_SELF?>>
<table width=850 cellpadding=1 cellspacing=1 border=1>
<tr height=20 bgcolor=eeeeee>
<td>
<select name='sv'>
<option value='no'>웹에서바로보기</option>
<option value='yes'>다운로드받기</option>
</select>
<select name='ks'>
<option value='euc-kr'>언어선택</option>
<option value='euc-kr'>한국어</option>
<option value='utf-8'>유니코드</option>
<option value='euc-jp'>일본어</option>
<option value='gb2312'>중국어</option>
<option value='iso-8859-1'>영어</option>
</select>
<select name='ms'>
<option value=''>파일선택</option>
<option value='excel'>엑셀파일</option>
<option value='power'>파워포인트</option>
<option value='word'>워드문서</option>
<option value='memo'>워드패드</option>
</select>
<select name='code'>
<option value='1'>분류(정렬)선택</option>
<option value='2'>제목</option>
<option value='3'>파트명</option>
<option value='4'>이름</option>
<option value='5'>작성일</option>
<option value='6'>주요이슈사항</option>
<option value='7'>금일실적</option>
<option value='8'>명일계획</option>
</select>
검색or레벨지정: <input type=text name='name' size=12 maxlength=22 value=''>
<input type=submit class=submit value=보기/다운로드>
</form>
</td>
<td>
<form name=search_member2 method=get action=<?=$PHP_SELF?>>
<input type=hidden name='sv' value=''>
<input type=hidden name='ks' value=''>
<input type=hidden name='ms' value=''>
<input type=hidden name='code' value=''>
<input type=hidden name='name' value=''>
<input type=submit class=submit value=초기화>
</form>
</td>
</tr>
</table>
<?
if ($sv =="no") {
// 웹상에서 바로보기 이며 넘어온 값에 대한처리
if($code =="1"){
$m_que = "$g4[write_today_table] order by wr_subject desc";
}else if($code =="2"){
$m_que = "$g4[write_today_table] order by ca_name desc";
}else if($code =="3"){
$m_que = "$g4[write_today_table] order by wr_name desc";
}else if($code =="4"){
$m_que = "$g4[write_today_table] order by wr_datetime desc";
}else if($code =="5"){
$m_que = "$g4[write_today_table] order by wr_content desc";
}else if($code =="6"){
$m_que = "$g4[write_today_table] order by wr_1 desc";
}else if($code =="7"){
$m_que = "$g4[write_today_table] order by wr_2 desc";
}else if($code =="8"){
}
$result = mysql_query("select * from $m_que");
$temp = mysql_fetch_array(mysql_query("select count(*) from $g4[write_today_table] $m_que"));
$number=$temp[0]
?>
<table width=2000 cellpadding=0 cellspacing=0 border=1>
<tr align=center height=25 bgcolor=999999>
<td style=font-weight:bold;>번호</td>
<td style=font-weight:bold;>제목</td>
<td style=font-weight:bold;>파트명</td>
<td style=font-weight:bold;>이름</td>
<td style=font-weight:bold;>작성일</td>
<td style=font-weight:bold;>주요이슈 (주간계획/현 주요문제점/비고)</td>
<td style=font-weight:bold;>금일 실적</td>
<td style=font-weight:bold;>명일 계획</td>
</tr>
<?
while($data=mysql_fetch_array($result))
{
echo"
<tr align=center height=24>
<td>$number</td>
<td>$data[wr_subject]</td>
<td>$data[ca_name]</td>
<td>$data[wr_name]</td>
<td class='txt'>$data[wr_datetime]</td>
<td class='txt'>$data[wr_content]</td>
<td class='txt'>$data[wr_1]</td>
<td class='txt'>$data[wr_2]</td>
</tr>";
$number--;
}
echo "</table>";
}
?>
</body>
</html>
근데 중요한거는 클릭해도 반응이 없어요 ㅠㅠ
고수님들 도움좀 요청드려요 하루종일 머리꺠질거 같아요 흑흑...
댓글 전체
list.skin.php
--------------------------------------------------------------
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
?>
<table border=0 width="100%" cellspacing="0" cellpadding="0">
<form method='post' action="<?=$board_skin_path?>/excel_all.php">
<input type='hidden' name='bo_table' value='<?=$bo_table?>'>
<tr>
<td><input type="text" name="datetime" size="10" maxlength="10"></td>
</tr>
<tr>
<td><input type="submit" value="출력"><input type="reset" value="삭제"></td>
</tr>
</form>
</table>
--------------------------------------------------------------
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
?>
<table border=0 width="100%" cellspacing="0" cellpadding="0">
<form method='post' action="<?=$board_skin_path?>/excel_all.php">
<input type='hidden' name='bo_table' value='<?=$bo_table?>'>
<tr>
<td><input type="text" name="datetime" size="10" maxlength="10"></td>
</tr>
<tr>
<td><input type="submit" value="출력"><input type="reset" value="삭제"></td>
</tr>
</form>
</table>
excel.php 에
$temp=mysql_fetch_array(mysql_query("select count(*) from g4_write_$bo_table where left(wr_datetime,10)='$datetime' "));
$result=mysql_query("select * from g4_write_$bo_table where left(wr_datetime,10)='$datetime' ");
$temp=mysql_fetch_array(mysql_query("select count(*) from g4_write_$bo_table where left(wr_datetime,10)='$datetime' "));
$result=mysql_query("select * from g4_write_$bo_table where left(wr_datetime,10)='$datetime' ");
해바리님 이쪽 소스는 너무 손댈게 많은듯 해요 ^^;;
이건 포기해야 할거 같아요 ㅠㅠ
이건 포기해야 할거 같아요 ㅠㅠ
