게시물 인쇄 버튼을 달았는데 에러가 나요 > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

게시물 인쇄 버튼을 달았는데 에러가 나요 정보

게시물 인쇄 버튼을 달았는데 에러가 나요

본문

인쇄버튼을 누르면 새창에 게시물 내용이 뜨고 인쇄설정창이 뜨게 했는데
아래처럼 에러가 나네요
아시는 분, 부탁 좀 드립니다


select wr_name, wr_4 from g4_write_reservation where wr_id = '28'

1146 : Table 'peacetown.g4_write_reservation' doesn't exist

error file : /skin/board/huwon/receipt.htm



----------------------------------------------------------------------------------------

새창 소스


<?
include_once("./_common.php");

$sql = " select wr_name, wr_4 from g4_write_reservation where wr_id = '$wr_id'";
$row = sql_fetch($sql);

$name = $row[wr_name];
$birth = explode("-",$row[wr_4]);
$birth1  = $birth[0];
$birth2  = $birth[1];
$birth3  = $birth[2];
$birth4  = $birth[3];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr" />
<title>Untitled Document</title>
<style>
.hu_tb_view{margin-top:10px; width:100%; line-height:24px; border-collapse:collapse; border:2px solid #999;}
.hu_tb_view th{padding:5px; width:110px; border:1px solid #ccc; font-size:12px; text-align:left; color:#363636; background-color:#efefef;}
.hu_tb_view td{padding:5px 5px 5px 10px; border:1px solid #ccc;}
</style>

</head>

<body onLoad="window.print()">
<table class="hu_tb_view"">
  <tr>
    <th>이 름</th>
    <td><?=$view[wr_name]?></td>
  </tr>
  <!--<tr>
<th>성 별</th><td><?=$view[wr_1]?></td>
</tr>-->
  <tr>
    <th>주민등록번호</th>
    <td><?=$view[wr_2]?></td>
  </tr>
  <tr>
    <th>생년월일</th>
    <td><?=$view[wr_4]?>
      (
        <?=$view[wr_3]?>
      )</td>
  </tr>
  <tr>
    <th>자택 전화번호</th>
    <td><? if (strlen($view[wr_6])>10) { ?>
        <?=$view[wr_6]?>
      <? } ?></td>
  </tr>
  <tr>
    <th>직장 전화번호</th>
    <td><? if (strlen($view[wr_8])>10) { ?>
        <?=$view[wr_8]?>
      <? } ?></td>
  </tr>
  <tr>
    <th>휴대전화</th>
    <td><?=$view[wr_7]?></td>
  </tr>
  <tr>
    <th>이메일</th>
    <td><?=$view[wr_email]?></td>
  </tr>
  <tr>
    <th>주 소</th>
    <td>우)
        <?=$view[wr_5]?>
        <?=$view[wr_subject]?></td>
  </tr>
  <tr>
    <th>이메일</th>
    <td><?=$view[wr_email]?></td>
  </tr>
  <?
$p_nine = explode("|",$view[wr_9]);
$nine01 = $p_nine[0];
$nine02 = $p_nine[1];
$nine03 = $p_nine[2];
$nine04 = $p_nine[3];
$nine05 = $p_nine[4];
$nine06 = $p_nine[5];
$nine07 = $p_nine[6];
?>
  <tr>
    <th>직장</th>
    <td><?=$nine01?></td>
  </tr>
  <tr>
    <th>종교</th>
    <td><?=$nine02?></td>
  </tr>
  <tr>
    <th>후원신청동기</th>
    <td><?=$nine03?>
        <? if ($nine03=="기타") echo " : ".$nine04; ?></td>
  </tr>
  <tr>
    <th>후원종류</th>
    <td><?=$nine05?>
        <? if ($nine05=="결연후원") echo " : ".$nine06; ?></td>
  </tr>
  <tr>
    <th>자동이체 은행정보</th>
    <td><?=$nine07?></td>
  </tr>
  <tr>
    <th>거래은행</th>
    <td><?=$view[wr_12]?></td>
  </tr>
  <tr>
    <th>계좌번호</th>
    <td><?=$view[wr_14]?>
      - 입금인 :
      <?=$view[wr_15]?></td>
  </tr>
  <tr>
    <th>이체일</th>
    <td><?=$view[wr_16]?></td>
  </tr>
  <tr>
    <th>후원금액</th>
    <td><?if($view[wr_17] == "금액선택"){ ?>
        <?=$view[wr_10]?>
        <?}else{?>
        <?=$view[wr_1]?>
      원
      <?}?>
    </td>
  </tr>
  <tr>
    <th>전하실 말씀</th>
    <td><?=$view[content];?></td>
  </tr>
</table>
</body>
</html>



----------------------------------------------------------------------------------------
view.skin  내용



<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
?>

<style>
.hu_tb_view{margin-top:10px; width:100%; line-height:24px; border-collapse:collapse; border:2px solid #999;}
.hu_tb_view th{padding:5px; width:110px; border:1px solid #ccc; font-size:12px; text-align:left; color:#363636; background-color:#efefef;}
.hu_tb_view td{padding:5px 5px 5px 10px; border:1px solid #ccc;}
</style>
<script language="javascript">
function PreviewForm(){     
    window.open('<?=$board_skin_path?>/receipt.htm?wr_id=<?=$view[wr_id]?>','printview','top=0,left=0,width=640,height=320,scrollbars=no');       
}
</script>
<div style="height:12px; line-height:1px; font-size:1px;">&nbsp;</div>

<!-- 게시글 보기 시작 -->
<table width="<?=$width?>" align="center" cellpadding="0" cellspacing="0"><tr><td>


<div style="clear:both; height:30px;">
    <div style="float:left; margin-top:6px;">
    <img src="<?=$board_skin_path?>/img/icon_date.gif" align=absmiddle border='0'>
    <span style="color:#888888;">작성일 : <?=date("y-m-d H:i", strtotime($view[wr_datetime]))?></span>
    </div>

    <!-- 링크 버튼 -->
    <div style="float:right;">
    <?
    ob_start();
    ?>
    <img src='<?=$board_skin_path?>/img/btn_print.gif' name="printview" align='absmiddle' id="printview" style="cursor:hand" onclick="PreviewForm()" />
    <? if ($copy_href) { echo "<a href=\"$copy_href\"><img src='$board_skin_path/img/btn_copy.gif' border='0' align='absmiddle'></a> "; } ?>
    <? if ($move_href) { echo "<a href=\"$move_href\"><img src='$board_skin_path/img/btn_move.gif' border='0' align='absmiddle'></a> "; } ?>

    <? if ($search_href) { echo "<a href=\"$search_href\"><img src='$board_skin_path/img/btn_list_search.gif' border='0' align='absmiddle'></a> "; } ?>
    <? echo "<a href=\"$list_href\"><img src='$board_skin_path/img/btn_list.gif' border='0' align='absmiddle'></a> "; ?>
    <? if ($update_href) { echo "<a href=\"$update_href\"><img src='$board_skin_path/img/btn_modify.gif' border='0' align='absmiddle'></a> "; } ?>
    <? if ($delete_href) { echo "<a href=\"$delete_href\"><img src='$board_skin_path/img/btn_delete.gif' border='0' align='absmiddle'></a> "; } ?>
    <? if ($reply_href) { echo "<a href=\"$reply_href\"><img src='$board_skin_path/img/btn_reply.gif' border='0' align='absmiddle'></a> "; } ?>
    <? if ($write_href) { echo "<a href=\"$write_href\"><img src='$board_skin_path/img/btn_write.gif' border='0' align='absmiddle'></a> "; } ?>
    <?
    $link_buttons = ob_get_contents();
    ob_end_flush();
    ?>
    </div>
</div>

<div style="border:1px solid #ddd; clear:both; height:34px;">
    <table border=0 cellpadding=0 cellspacing=0 width=100%>
    <tr>
        <td style="padding:8px 0 0 10px;">
            <div style="color:#505050; font-size:13px; font-weight:bold; word-break:break-all;">
            <? if ($is_category) { echo ($category_name ? "[$view[ca_name]] " : ""); } ?>
            <?//=cut_hangul_last(get_text($view[wr_subject]))?>
<?=$view[wr_name]?> 님의 후원신청내역입니다.
            </div>
        </td>
        <td align="right" style="padding:6px 6px 0 0; color:#888;" width=120>
            조회 : <?=number_format($view[wr_hit])?>
        </td>
    </tr>
    </table>
</div>

<div style="width:99%; color:#888; text-align:right;">
<? if ($is_ip_view) { echo "$ip"; } ?>
</div>

<tr>
    <td height="150" style="word-break:break-all; padding:10px;">

        <!-- 내용 출력 -->
<table class="hu_tb_view"">
<tr>
<th>이 름</th><td><?=$view[wr_name]?></td>
</tr>
<!--<tr>
<th>성 별</th><td><?=$view[wr_1]?></td>
</tr>-->
<tr>
<th>주민등록번호</th><td><?=$view[wr_2]?></td>
</tr>
<tr>
<th>생년월일</th><td><?=$view[wr_4]?>(<?=$view[wr_3]?>)</td>
</tr>
<tr>
<th>자택 전화번호</th><td><? if (strlen($view[wr_6])>10) { ?><?=$view[wr_6]?><? } ?></td>
</tr>
<tr>
<th>직장 전화번호</th><td><? if (strlen($view[wr_8])>10) { ?><?=$view[wr_8]?><? } ?></td>
</tr>
<tr>
<th>휴대전화</th><td><?=$view[wr_7]?></td>
</tr>
<tr>
<th>이메일</th><td><?=$view[wr_email]?></td>
</tr>
<tr>
<th>주 소</th><td>우)<?=$view[wr_5]?> <?=$view[wr_subject]?></td>
</tr>
<tr>
<th>이메일</th><td><?=$view[wr_email]?></td>
</tr>
<?
$p_nine = explode("|",$view[wr_9]);
$nine01 = $p_nine[0];
$nine02 = $p_nine[1];
$nine03 = $p_nine[2];
$nine04 = $p_nine[3];
$nine05 = $p_nine[4];
$nine06 = $p_nine[5];
$nine07 = $p_nine[6];
?>
<tr>
<th>직장</th><td><?=$nine01?></td>
</tr>
<tr>
<th>종교</th><td><?=$nine02?></td>
</tr>
<tr>
<th>후원신청동기</th><td><?=$nine03?> <? if ($nine03=="기타") echo " : ".$nine04; ?></td>
</tr>
<tr>
<th>후원종류</th><td><?=$nine05?> <? if ($nine05=="결연후원") echo " : ".$nine06; ?></td>
</tr>
<tr>
<th>자동이체 은행정보</th><td><?=$nine07?></td>
</tr>
<tr>
<th>거래은행</th><td><?=$view[wr_12]?></td>
</tr>
<tr>
<th>계좌번호</th><td><?=$view[wr_14]?> - 입금인 : <?=$view[wr_15]?></td>
</tr>
<tr>
<th>이체일</th><td><?=$view[wr_16]?></td>
</tr>
<tr>
<th>후원금액</th><td>
<?if($view[wr_17] == "금액선택"){ ?>
<?=$view[wr_10]?>
<?}else{?>
<?=$view[wr_1]?> 원
<?}?>
</td>
</tr>
<tr>
<th>전하실 말씀</th><td><?=$view[content];?></td>
</tr>
</table>
       
        <?//echo $view[rich_content]; // 과 같은 코드를 사용할 경우?>
        <!-- 테러 태그 방지용 --></xml></xmp><a href=""></a><a href=''></a>

        <? if ($nogood_href) {?>
        <div style="width:72px; height:55px; background:url(<?=$board_skin_path?>/img/good_bg.gif) no-repeat; text-align:center; float:right;">
        <div style="color:#888; margin:7px 0 5px 0;">비추천 : <?=number_format($view[wr_nogood])?></div>
        <div><a href="<?=$nogood_href?>" target="hiddenframe"><img src="<?=$board_skin_path?>/img/icon_nogood.gif" border='0' align="absmiddle"></a></div>
        </div>
        <? } ?>

        <? if ($good_href) {?>
        <div style="width:72px; height:55px; background:url(<?=$board_skin_path?>/img/good_bg.gif) no-repeat; text-align:center; float:right;">
        <div style="color:#888; margin:7px 0 5px 0;"><span style='color:crimson;'>추천 : <?=number_format($view[wr_good])?></span></div>
        <div><a href="<?=$good_href?>" target="hiddenframe"><img src="<?=$board_skin_path?>/img/icon_good.gif" border='0' align="absmiddle"></a></div>
        </div>
        <? } ?>

</td>
</tr>
<? if ($is_signature) { echo "<tr><td align='center' style='border-bottom:1px solid #E7E7E7; padding:5px 0;'>$signature</td></tr>"; } // 서명 출력 ?>
</table>
<br>

<?
// 코멘트 입출력
//include_once("./view_comment.php");
?>

<div style="height:1px; line-height:1px; font-size:1px; background-color:#ddd; clear:both;">&nbsp;</div>

<div style="clear:both; height:43px;">
    <div style="float:left; margin-top:10px;">
    <? if ($prev_href) { echo "<a href=\"$prev_href\" title=\"$prev_wr_subject\"><img src='$board_skin_path/img/btn_prev.gif' border='0' align='absmiddle'></a>&nbsp;"; } ?>
    <? if ($next_href) { echo "<a href=\"$next_href\" title=\"$next_wr_subject\"><img src='$board_skin_path/img/btn_next.gif' border='0' align='absmiddle'></a>&nbsp;"; } ?>
    </div>

    <!-- 링크 버튼 -->
    <div style="float:right; margin-top:10px;">
    <?=$link_buttons?>
    </div>
</div>

<div style="height:2px; line-height:1px; font-size:1px; clear:both;">&nbsp;</div>

</td></tr></table><br>

<script language="JavaScript">
function file_download(link, file) {
    <? if ($board[bo_download_point] < 0) { ?>if (confirm("'"+file+"' 파일을 다운로드 하시면 포인트가 차감(<?=number_format($board[bo_download_point])?>점)됩니다.\n\n포인트는 게시물당 한번만 차감되며 다음에 다시 다운로드 하셔도 중복하여 차감하지 않습니다.\n\n그래도 다운로드 하시겠습니까?"))<?}?>
    document.location.href=link;
}
</script>

<script language="JavaScript" src="<?="$g4[path]/js/board.js"?>"></script>
<script language="JavaScript">
window.onload=function() {
    resizeBoardImage(<?=(int)$board[bo_image_width]?>);
    drawFont();
}
</script>
<!-- 게시글 보기 끝 -->
  • 복사

댓글 전체

<th>이 름</th>
    <td><?=$view[wr_name]?></td> <---$view 변수를 만들지 않았으니 당연히 안 나옵니다
$view 를 모두 $write 로 바꾸세요

자세히 보니 $name, $birth 등은 쓰이지 않으니 아래코드는 전혀 필요없습니다
$sql = " select wr_name, wr_4 from g4_write_reservation where wr_id = '$wr_id'";
$row = sql_fetch($sql);

$name = $row[wr_name];
$birth = explode("-",$row[wr_4]);
$birth1  = $birth[0];
$birth2  = $birth[1];
$birth3  = $birth[2];
$birth4  = $birth[3];

/////////수정
    <th>전하실 말씀</th>
    <td><?=$view[content];?></td> <--- <?=nl2br($write[wr_content])?>
© SIRSOFT
현재 페이지 제일 처음으로