여분필드 질문좀 드립니다
본문
위링크 게시판스킨을 사용중입니다
write.skin.php부분에서 wr_30 여분필드를 사용을할려고합니다
그런데 리스트 부분에 출력이 되지않는데 왜그런지 아시는분들 소중한 답변좀 부탁드리겠습니다 bbs폴더에서 write.php,write_update.phpfor ($i=1; $i<=30; $i++) 여분필드 추가는 했습니다
list.php부분
<li><?php echo $list[$i]['wr_30'] ?></li>
write.skin.php부분
<tr>
<th scope="row"><label for="wr_30">상품가격</label></th>
<td><input type="text" name="wr_30" value="<?php echo $wr_30 ?>" class="frm_input required" id="wr_30" size="50" maxlength="100"></td>
</tr>
write.skin.php 전체소스
<?php
if (!defined('_GNUBOARD_')) exit; // 개별 페이지 접근 불가
//갱신 쿼리
$sql = " select * from {$g5['board_table']} where bo_table = '{$_REQUEST['bo_table']}'";
$result = sql_query($sql);
for($i = 0; $row = sql_fetch_array($result); $i++){
$GDTBoard_explode_arr1 = explode("|", $row['bo_10']);
// 번호
$total_write_db_num = $row['bo_count_write'];
$total_notice_num_explode = $row['bo_notice'];
$bo_use_category = $row['bo_use_category'];
$bo_category_list = explode("|",$row['bo_category_list']);
}
?>
<link rel="stylesheet" href="<?php echo $board_skin_url ?>/style.css">
<section id="bo_w">
<h2 id="container_title"><?php echo $g5['title'] ?></h2>
<!-- 게시물 작성/수정 시작 { -->
<form name="fwrite" id="fwrite" action="<?php echo $action_url ?>" onsubmit="return fwrite_submit(this);" method="post" enctype="multipart/form-data" autocomplete="off" style="width:<?php echo $width; ?>">
<input type="hidden" name="uid" value="<?php echo get_uniqid(); ?>">
<input type="hidden" name="w" value="<?php echo $w ?>">
<input type="hidden" name="bo_table" value="<?php echo $bo_table ?>">
<input type="hidden" name="wr_id" value="<?php echo $wr_id ?>">
<input type="hidden" name="sca" value="<?php echo $sca ?>">
<input type="hidden" name="sfl" value="<?php echo $sfl ?>">
<input type="hidden" name="stx" value="<?php echo $stx ?>">
<input type="hidden" name="spt" value="<?php echo $spt ?>">
<input type="hidden" name="sst" value="<?php echo $sst ?>">
<input type="hidden" name="sod" value="<?php echo $sod ?>">
<input type="hidden" name="page" value="<?php echo $page ?>">
<?php
$option = '';
$option_hidden = '';
if ($is_notice || $is_html || $is_secret || $is_mail) {
$option = '';
if ($is_notice) {
$option .= "\n".'<input type="checkbox" id="notice" name="notice" value="1" '.$notice_checked.'>'."\n".'<label for="notice">공지</label>';
}
if ($is_html) {
if ($is_dhtml_editor) {
$option_hidden .= '<input type="hidden" value="html1" name="html">';
} else {
$option .= "\n".'<input type="checkbox" id="html" name="html" onclick="html_auto_br(this);" value="'.$html_value.'" '.$html_checked.'>'."\n".'<label for="html">html</label>';
}
}
if ($is_secret) {
if ($is_admin || $is_secret==1) {
$option .= "\n".'<input type="checkbox" id="secret" name="secret" value="secret" '.$secret_checked.'>'."\n".'<label for="secret">비밀글</label>';
} else {
$option_hidden .= '<input type="hidden" name="secret" value="secret">';
}
}
if ($is_mail) {
$option .= "\n".'<input type="checkbox" id="mail" name="mail" value="mail" '.$recv_email_checked.'>'."\n".'<label for="mail">답변메일받기</label>';
}
}
echo $option_hidden;
?>
<div class="tbl_frm01 tbl_wrap">
<table>
<tbody>
<?php if ($is_name) { ?>
<tr>
<th scope="row"><label for="wr_name">이름<strong class="sound_only">필수</strong></label></th>
<td><input type="text" name="wr_name" value="<?php echo $name ?>" id="wr_name" required class="frm_input required" size="10" maxlength="20"></td>
</tr>
<?php } ?>
<?php if ($is_password) { ?>
<tr>
<th scope="row"><label for="wr_password">패스워드<strong class="sound_only">필수</strong></label></th>
<td><input type="password" name="wr_password" id="wr_password" <?php echo $password_required ?> class="frm_input <?php echo $password_required ?>" maxlength="20"></td>
</tr>
<?php } ?>
<?php if ($is_email) { ?>
<tr>
<th scope="row"><label for="wr_email">이메일</label></th>
<td><input type="text" name="wr_email" value="<?php echo $email ?>" id="wr_email" class="frm_input email" size="50" maxlength="100"></td>
</tr>
<?php } ?>
<?php if ($is_homepage) { ?>
<tr>
<th scope="row"><label for="wr_homepage">홈페이지</label></th>
<td><input type="text" name="wr_homepage" value="<?php echo $homepage ?>" id="wr_homepage" class="frm_input" size="50"></td>
</tr>
<?php } ?>
<?php if ($option) { ?>
<tr>
<th scope="row">옵션</th>
<td><?php echo $option ?></td>
</tr>
<?php } ?>
<?php if ($is_category) { ?>
<tr>
<th scope="row"><label for="ca_name">지역<strong class="sound_only">필수</strong></label></th>
<td>
<?php
for($i = 0; $i < count($bo_category_list); $i++){
if($bo_category_list[$i]){
$required_class_on = "true";
}
}
if($required_class_on){
$required_class = 'required class="required"';
}
?>
<select name="ca_name" id="ca_name" <?php echo $required_class ?> onchange="location.href=this.value">
<option value="">지역</option>
<?php
for($i = 0; $i<count($bo_category_list); $i++){
if($bo_category_list[$i]){
?>
<option value="<?php echo G5_BBS_URL?>/write.php?bo_table=<?php echo $_REQUEST['bo_table']?>&sca1=<?php echo $bo_category_list[$i]?>" <?php if($_REQUEST['sca1'] == $bo_category_list[$i]){ echo 'selected="selected"';}?>><?php echo $bo_category_list[$i]?></option>
<?php
}
}
?>
</select>
<?php
if($_REQUEST['sca1']){
for($i = 0; $i < count($bo_category_list); $i++){
if($bo_category_list[$i] == $_REQUEST['sca1']){
$GDTMutiCaName = "MutiCa".$i;
}
}
$sql = " select * from {$g5['board_table']} where bo_table = '{$_REQUEST['bo_table']}'";
$result = sql_query($sql);
for($i = 0; $row = sql_fetch_array($result); $i++){
$wr_9_GDTMutiCaName = explode("|",$row[$GDTMutiCaName]);
}
?>
<select name="wr_9" id="wr_9">
<option value="">지역</option>
<?php
for($i = 0; $i < count($wr_9_GDTMutiCaName); $i++){
if($wr_9_GDTMutiCaName[$i]){
?>
<option value="<?php echo $wr_9_GDTMutiCaName[$i] ?>"><?php echo $wr_9_GDTMutiCaName[$i] ?></option>
<?php
}
}
?>
</select>
<?php
}
?>
</td>
</tr>
<?php } ?>
<tr>
<th scope="row"><label for="wr_subject">플래너이름<strong class="sound_only">필수</strong></label></th>
<td>
<div id="autosave_wrapper">
<input type="text" name="wr_subject" value="<?php echo $subject ?>" id="wr_subject" required class="frm_input required" size="50" maxlength="255">
<?php if ($is_member) { // 임시 저장된 글 기능 ?>
<script src="<?php echo G5_JS_URL; ?>/autosave.js"></script>
<button type="button" id="btn_autosave" class="btn_frmline">임시 저장된 글 (<span id="autosave_count"><?php echo $autosave_count; ?></span>)</button>
<div id="autosave_pop">
<strong>임시 저장된 글 목록</strong>
<div><button type="button" class="autosave_close"><img src="<?php echo $board_skin_url; ?>/img/btn_close.gif" alt="닫기"></button></div>
<ul></ul>
<div><button type="button" class="autosave_close"><img src="<?php echo $board_skin_url; ?>/img/btn_close.gif" alt="닫기"></button></div>
</div>
<?php } ?>
</div>
</td>
</tr>
<tr>
<th scope="row"><label for="wr_20">상품가격</label></th>
<td><input type="text" name="wr_20" value="<?php echo $wr_20 ?>" class="frm_input required" id="wr_20" size="50" maxlength="100"></td>
</tr>
<tr>
<th scope="row"><label for="wr_21">소개글</label></th>
<td><input type="text" name="wr_21" value="<?php echo $write ?>" id="wr_21" class="frm_input" size="50"></td>
</tr>
<tr>
<th scope="row"><label for="wr_content">내용<strong class="sound_only">필수</strong></label></th>
<td class="wr_content">
<?php if($write_min || $write_max) { ?>
<!-- 최소/최대 글자 수 사용 시 -->
<p id="char_count_desc">이 게시판은 최소 <strong><?php echo $write_min; ?></strong>글자 이상, 최대 <strong><?php echo $write_max; ?></strong>글자 이하까지 글을 쓰실 수 있습니다.</p>
<?php } ?>
<?php echo $editor_html; // 에디터 사용시는 에디터로, 아니면 textarea 로 노출 ?>
<?php if($write_min || $write_max) { ?>
<!-- 최소/최대 글자 수 사용 시 -->
<div id="char_count_wrap"><span id="char_count"></span>글자</div>
<?php } ?>
</td>
</tr>
<tr>
<th scope="row"><label for="wr_10">동영상 링크</label></th>
<td><input type="text" name="wr_10" value="<?php echo $write['wr_10'] ?>" id="wr_10" class="frm_input" size="50"> * 유튜브/다음팟만 가능합니다.</td>
</tr>
<?php for ($i=1; $is_link && $i<=G5_LINK_COUNT; $i++) { ?>
<tr>
<th scope="row"><label for="wr_l
답변 1
wr_30까지 사용하시려면 mysql 에서 게시판 여분필드가 1~30 까지 다 있는거죠.
adm/sql_write.sql 에서도 여분필드 30까지 추가해주시구요.
mysql접속하셔서 출력하시려는 여분필드를 확인해보세요.
저도 필드 추가해서 잘 사용하고 있는데요.
