게시글 엑셀다운로드시 오류가납니다. 채택완료
D2Bweb
9년 전
조회 6,250
</p><p><?</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>include_once("./_common.php");</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if($is_admin == 'super'){</p><p> </p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$excel_down = "g5_write_" . $_POST['bo_table']; //엑셀 다운로드 테이블</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$wr_id = $id = $_GET['wr_id']; </p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>//@mysql_query("SET CHARACTER SET utf8"); // 한글깨지면 주석해지</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$g5[title] = "엑셀 문서 다운로드"; </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>header( "Content-type: application/vnd.ms-excel" ); </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>header( "Content-Disposition: attachment; filename=".date("ymdH")."-참가목록.xls" ); </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>header( "Content-Description: PHP4 Generated Data" ); </p><p> </p><p> </p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$temp=mysql_fetch_array(mysql_query("select count(*) from $excel_down ")); </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$result=@mysql_query("select * from $excel_down order by wr_datetime desc");</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$number=$temp[0];</p><p>?></p><p> </p><p><html></p><p><head></p><p><meta http-equiv="Content-Type" content="text/html; charset=euc-kr"> </p><p><style type="text/css"></p><p> </p><p>.txt {mso-number-format:'\@'}</p><p> </p><p></style></p><p></head></p><p> </p><p><body></p><p><table border="1"> </p><p> <tr height="50"></p><p> <td colspan="13" style="font-size:20px; color:#ffffff; background:#666666;">참가신청 리스트</td></p><p> </tr></p><p> <tr></p><p> <td>번호</td></p><p> <td>참가분야</td></p><p> <td>참가구분</td></p><p> <td>참가자(대표자)성명</td></p><p> <td>생년월일</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td>소속</td></p><p> <td>휴대폰</td></p><p> <td>이메일</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td>주소</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td>참가 인원</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td>팀명</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td>작품명</td></p><p> <td>출품날짜</td></p><p> </tr></p><p> </p><p><? </p><p>while($data=mysql_fetch_array($result)) { </p><p> </p><p>//대표자정보</p><p>$representative = explode("|",$data[wr_3]);</p><p>$birth = $representative[0];</p><p>$belong = $representative[1];</p><p>$hp = $representative[2];</p><p> </p><p>//주소</p><p>$address = explode("|",$data[wr_4]);</p><p>$zip = $address[0];</p><p>$addr1 = $address[1];</p><p>$addr2 = $address[2];</p><p>$addr3 = $address[3];</p><p>$jibeon = $address[4];</p><p> </p><p>//팀정보</p><p>$teamA = explode("|",$data[wr_5]);</p><p>$team_persons = $teamA[0];</p><p>$team_name = $teamA[1];</p><p> </p><p>//공동참가자</p><p>$teamB = explode("|",$data[wr_6]);</p><p>$team_detail01 = $teamB[0];</p><p>$team_detail02 = $teamB[1];</p><p>$team_detail03 = $teamB[2];</p><p>$team_detail04 = $teamB[3];</p><p>$team_detail05 = $teamB[4];</p><p>$team_detail06 = $teamB[5];</p><p>$team_detail07 = $teamB[6];</p><p>$team_detail08 = $teamB[7];</p><p> </p><p>echo "</p><p> <tr> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td class='txt'>$number</td></p><p> <td class='txt'>".$data[ca_name]."</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td class='txt'>".$data[wr_2]."</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td class='txt'>".$data[wr_name]."</td></p><p> <td class='txt'>".$data[wr_email]."</td></p><p> <td class='txt'>".$data[wr_1]."</td></p><p> <td class='txt'>".$birth."</td></p><p> <td class='txt'>".$data[wr_5]."</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td class='txt'>".$data[wr_4]."</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td class='txt'>".$data[wr_6]."</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td class='txt'>".$data[wr_7]."</td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td class='txt'>".$data[wr_8]."</td></p><p> <td class='txt'>$data[wr_datetime]</td></p><p> </tr></p><p>";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$number--; </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>} </p><p>?></p><p></table> </p><p></body> </p><p></html></p><p> </p><p><?</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p> </p><p>?></p><p>
기존소스를 위와같이 수정해서 적용했는데..엑셀파일 열면 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in 도메인 on line 57 에러가 납니다.
어디가 잘못된걸까요..??
미리 감사드리며 도움요청드립니다.
댓글을 작성하려면 로그인이 필요합니다.
답변 1개
답변을 작성하려면 로그인이 필요합니다.
로그인
근데 데이터가 안넘어오네요..ㅠㅠ 손볼곳이 많은듯싶습니다.