DB 엑셀로 내려받으려고 합니다. 채택완료
phpmyadmin 에서
http://akira1207.dothome.co.kr/myadmin/sql.php?db=akira1207&token=3bb023c63b826ac1d51a97037a04ba73&table=g5_fmail&pos=0" title="보기: (527 행(레코드))" id="akira1207.g5_fmail" style="text-decoration: none; color: rgb(0, 0, 0); font-family: sans-serif; font-size: 10.496px; line-height: normal; white-space: nowrap; background: rgb(208, 220, 224);">g5_fmail 라는 테이블의 DB를 엑셀파일로 받아보려고합니다.
그누보드 관리자 페이지에서 엑셀 받아보는게 있긴한데 눌러서 다운을 받으면 내용이 하나도 안나오네요 ㅠㅠ
</strong></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><?</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$sub_menu = "600100";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>include_once("./_common.php");</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>auth_check($auth[$sub_menu], "r");</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>
</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$sql_common = " FROM g5_fmail WHERE 1 ";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>if ($sfl && $stx) $sql_common .= " AND INSTR(`".$sfl."`, '".$stx."') ";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>
</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$sql="SELECT * ".$sql_common." ORDER BY seq desc ";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$result = sql_query($sql);</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>
</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>
</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$printStr = "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"<a href="<a href="http://www.w3.org/TR/REC-html40\" target="_blank" rel="noopener noreferrer">http://www.w3.org/TR/REC-html40\</a>"><a href="http://www.w3.org/TR/REC-html40\" target="_blank" rel="noopener noreferrer">http://www.w3.org/TR/REC-html40\</a></a>">\n<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"<a href="<a href="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\" target="_blank" rel="noopener noreferrer">http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\</a>"><a href="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\" target="_blank" rel="noopener noreferrer">http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\</a></a>">\n<html>\n<head>\n<meta http-equiv=Content-Type content=\"text/html; charset=utf-8\">\n<meta name=ProgId content=Excel.Sheet>\n<style id=\"Classeur1_16681_Styles\">\n TD{border-color:silver;mso-number-format:General;}\n</style>\n </head>\n\n<body>\n<div id=\"Classeur1_16681\" align=center x:publishsource=\"Excel\">\n<table x:str border=1 cellpadding=0 cellspacing=0 width=100% style=\"border-collapse:collapse;border-color:silver\">\n";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$printStr .= "<tr>\n<th nowrap style=\"background:lightcyan;color:navy;text-align:center;font-weight:bold;\">번호</th>";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$printStr .= "<th nowrap style=\"background:lightcyan;color:navy;text-align:center;font-weight:bold;\">이름</th>";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$printStr .= "<th nowrap style=\"background:lightcyan;color:navy;text-align:center;font-weight:bold;\">연락처</th>";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$printStr .= "<th nowrap style=\"background:lightcyan;color:navy;text-align:center;font-weight:bold;\">생년월일</th>";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$printStr .= "<th nowrap style=\"background:lightcyan;color:navy;text-align:center;font-weight:bold;\">기대출</th>";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$printStr .= "<th nowrap style=\"background:lightcyan;color:navy;text-align:center;font-weight:bold;\">희망금액</th>";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$printStr .= "<th nowrap style=\"background:lightcyan;color:navy;text-align:center;font-weight:bold;\">대출상품</th>";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$printStr .= "<th nowrap style=\"background:lightcyan;color:navy;text-align:center;font-weight:bold;\">상태</th>";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$printStr .= "<th nowrap style=\"background:lightcyan;color:navy;text-align:center;font-weight:bold;\">아이피</th>";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$printStr .= "<th nowrap style=\"background:lightcyan;color:navy;text-align:center;font-weight:bold;\">접수일</th>";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$printStr .= "</tr>\n";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$i = 1;</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>while($row = mysql_fetch_array($result)){</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span>$printStr .= "</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span><tr>\n</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span><td style=\"mso-number-format:'\#\,\#\#0';text-align:right\" nowrap>".$i."</td>\n</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span><td style=\"text-align:center\" nowrap>".$row['name']."</td>\n</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span><td style=\"text-align:center\" nowrap>".$row['tel']."</td>\n</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span><td style=\"text-align:center\" nowrap>".($row['birth']!='0000-00-00' ? $row['birth']:' ')."</td>\n</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span><td style=\"text-align:center\" nowrap>".$row['loan_use']."</td>\n</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span><td style=\"text-align:center\" nowrap>".($row['amt']>0 ? number_format($row['amt']).'만원':null)."</td>\n</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span><td style=\"text-align:center\" nowrap>".$row['flag']."</td>\n</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span><td style=\"text-align:center\" nowrap>".$row['sts']."</td>\n</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span><td style=\"text-align:center\" nowrap>".$row['ip']."</td>\n</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span><td style=\"mso-number-format:'Short Date';text-align:center\" nowrap>".substr($row['w_dt'],0,10)."</td>\n</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span></tr>\n</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span>";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b><span class="Apple-tab-span" style="white-space:pre"> </span>$i++;</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>}</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$printStr .= "</table>\n</div>\n</body>\n</html>\n";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$filename = "온라인문의_".date("Y_m_d").".xls";</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$filename = preg_replace('/\./', '%2e', $filename, substr_count($filename, '.') - 1);</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>$filename = iconv("UTF-8", "EUC-KR", $filename);</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>header("Content-type: application/vnd.ms-excel;charset=utf-8");</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>header("Content-Length: ".strlen($printStr)); </b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>header("Content-Disposition: attachment; filename=".$filename);</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>header("Content-Description: PHP4 Generated Data" );</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>header("Content-Transfer-Encoding: text/plain");</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>header("Cache-Control: must-revalidate, post-check=0,pre-check=0");</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>header("Pragma: no-cache");</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>header("Expires: 0");</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>exit($printStr);</b></span></font></p><p><font color="#7f7f7f" face="돋움, Dotum, sans-serif"><span style="font-size: 12px; line-height: normal;"><b>?></b></span></font></p><p> </p><p> </p><p><strong style="color: rgb(127, 127, 127); font-family: 돋움, Dotum, sans-serif; font-size: 12px; line-height: normal;">
이렇게 양식이 있는데 엑셀로 내려받으면 내용은 아무것도 안보이네요... 경로가 잘못된건지
아니면 다른게 문제인지 모르겠습니다. 도와주세요 ㅠ
답변 3개
답변을 작성하려면 로그인이 필요합니다.
로그인