게시판 리스트의 내용 일부를 업데이트 하려는데 안되요
그누보드 5를 사용하고 있구요
저번에도 리스트화면에서 수정이라는 버튼을 클릭하면 apply.php라는 페이지를 통해
게시판 테이블 DB에 update를 이용해 여분 필드에 추가하려고 하는데 잘 안돼요
-- 리스트 list.skin.php --
<?php
if (!defined('_GNUBOARD_')) exit; // 개별 페이지 접근 불가
// 선택옵션으로 인해 셀합치기가 가변적으로 변함
$colspan = 17;
if ($is_checkbox) $colspan++;
if ($is_good) $colspan++;
if ($is_nogood) $colspan++;
// add_stylesheet('css 구문', 출력순서); 숫자가 작을 수록 먼저 출력됨
add_stylesheet('<link rel="stylesheet" href="'.$board_skin_url.'/style.css">', 2);
?>
<h2 id="container_title"><?php echo $board['bo_subject'] ?><span class="sound_only"> 목록</span></h2>
<!-- 게시판 목록 시작 { -->
<div id="bo_list" style="width:<?php echo $width; ?>">
<!-- 게시판 카테고리 시작 { -->
<?php if ($is_category) { ?>
<nav id="bo_cate">
<h2><?php echo $board['bo_subject'] ?> 카테고리</h2>
<ul id="bo_cate_ul">
<?php echo $category_option ?>
</ul>
</nav>
<?php } ?>
<!-- } 게시판 카테고리 끝 -->
<!-- 게시판 페이지 정보 및 버튼 시작 { -->
<div class="bo_fx">
<div id="bo_list_total">
<span>Total <?php echo number_format($total_count) ?>건</span>
<?php echo $page ?> 페이지
</div>
<?php if ($rss_href || $write_href) { ?>
<ul class="btn_bo_user">
<?php if ($admin_href) { ?><li><a href="<?php echo $admin_href ?>" class="btn_admin">관리자</a></li><?php } ?>
</ul>
<?php } ?>
</div>
<!-- } 게시판 페이지 정보 및 버튼 끝 -->
<form name="fboardlist" id="fboardlist" action="./board_list_update.php" onsubmit="return fboardlist_submit(this);" method="post">
<input type="hidden" name="bo_table" value="<?php echo $bo_table ?>">
<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="sca" value="<?php echo $sca ?>">
<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 ?>">
<input type="hidden" name="sw" value="">
<div class="tbl_head01 tbl_wrap">
<table>
<thead>
<tr>
<?php if ($is_checkbox) { ?>
<th scope="col">
<label for="chkall" class="sound_only">현재 페이지 게시물 전체</label>
<input type="checkbox" id="chkall" onclick="if (this.checked) all_checked(true); else all_checked(false);">
</th>
<?php } ?>
<th scope="col">번호</th>
<th scope="col">코드</th>
<th scope="col">업체명</th>
<th scope="col"><?php echo subject_sort_link('wr_4', $qstr2, 1) ?>RACK</a></th>
<th scope="col">모델명</th>
<th scope="col">FIX규격</th>
<th scope="col">POINT</th>
<th scope="col">조합</th>
<th scope="col">필름일자</th>
<th scope="col"><?php echo subject_sort_link('wr_9', $qstr2, 1) ?>제작일자</a></th>
<th scope="col">검사밀도</th>
<th scope="col">검사단위</th>
<th scope="col">검사유형</th>
<th scope="col">시작/종료</th>
<th scope='col'>시작시간</th>
<th scope='col'>종료시간</th>
<th scope='col'>진행여부</th>
</tr>
</thead>
<tbody>
<?php
for ($i=0; $i<count($list); $i++) {
?>
<form name="st_ad" method="post">
<tr class="<?php if ($list[$i]['is_notice']) echo "bo_notice"; ?>">
<?php if ($is_checkbox) { ?>
<td class="td_chk">
<label for="chk_wr_id_<?php echo $i ?>" class="sound_only"><?php echo $list[$i]['subject'] ?></label>
<input type="checkbox" name="chk_wr_id[]" value="<?php echo $list[$i]['wr_id'] ?>" id="chk_wr_id_<?php echo $i ?>">
</td>
<?php } ?>
<td class="td_num"><?php echo $list[$i]['wr_1']; ?></td>
<td class="td_num"><?php echo $list[$i]['wr_2'] ?></td>
<td class="td_date"><?php echo $list[$i]['wr_3'] ?></td>
<td class="td_num"><?php echo $list[$i]['wr_4'] ?></td>
<td class="td_subject">
<a href="<?php echo $list[$i]['href'] ?>"><?php echo $list[$i]['subject'] ?></a>
<?php
// if ($list[$i]['link']['count']) { echo '['.$list[$i]['link']['count']}.']'; }
// if ($list[$i]['file']['count']) { echo '<'.$list[$i]['file']['count'].'>'; }
if (isset($list[$i]['icon_new'])) echo $list[$i]['icon_new'];
if (isset($list[$i]['icon_hot'])) echo $list[$i]['icon_hot'];
if (isset($list[$i]['icon_file'])) echo $list[$i]['icon_file'];
if (isset($list[$i]['icon_link'])) echo $list[$i]['icon_link'];
if (isset($list[$i]['icon_secret'])) echo $list[$i]['icon_secret'];
?>
</td>
<td class="td_date"><?php echo $list[$i]['wr_6'] ?></td>
<td class="td_date"><?php echo $list[$i]['wr_7'] ?></td>
<td class="td_date"><?php echo $list[$i]['wr_11'] ?></td>
<td class="td_date"><?php echo $list[$i]['wr_9'] ?></td>
<td class="td_date"><?php echo $list[$i]['wr_18'] ?></td>
<td class="td_date"><?php echo $list[$i]['wr_19'] ?></td>
<td class="td_num"><?php echo $list[$i]['wr_21'] ?></td>
<td class="td_num"><?php echo $list[$i]['wr_22'] ?></td>
<td class="td_date">
<a href="./apply.php?mode=camUpdate&w=u&bo_table=<?=$bo_table?>&sca=<?=$sca?>&wr_id=<?=$list[$i]['wr_id']?>&wr_1=<?=$list[$i]['wr_1']?>&wr_2=<?=$list[$i]['wr_2']?>&wr_4=<?=$list[$i]['wr_4']?>&wr_subject=<?=$list[$i]['subject']?>" class='btn s'>시작</a>
<input type='button' class="btn " name="end" value='종료' onClick='cam_end()'>
</td>
<td class="td_date"><?php echo $list[$i]['wr_26'] ?></td>
<td class="td_date"><?php echo $list[$i]['wr_27'] ?></td>
<td class="td_date"><?php echo $list[$i]['wr_25'] ?></td>
</tr>
<?php } ?>
<?php if (count($list) == 0) { echo '<tr><td colspan="'.$colspan.'" class="empty_table">게시물이 없습니다.</td></tr>'; } ?>
</tbody>
</table>
</div>
<br>
<?php if ($list_href || $is_checkbox || $write_href) { ?>
<div class="bo_fx">
<?php if ($is_checkbox) { ?>
<ul class="btn_bo_adm">
<li><input type="submit" name="btn_submit" value="선택삭제" onclick="document.pressed=this.value"></li>
<li><input type="submit" name="btn_submit" value="선택복사" onclick="document.pressed=this.value"></li>
<li><input type="submit" name="btn_submit" value="선택이동" onclick="document.pressed=this.value"></li>
</ul>
<?php } ?>
<?php if ($list_href || $write_href) { ?>
<ul class="btn_bo_user">
<?php if ($list_href) { ?><li><a href="<?php echo $list_href ?>" class="btn_b01">리스트</a></li><?php } ?>
<?php if ($write_href) { ?><li><a href="<?php echo $write_href ?>" class="btn_b02">신규등록</a></li><?php } ?>
</ul>
<?php } ?>
</div>
<?php } ?>
</div>
</form>
<?php if($is_checkbox) { ?>
<noscript>
<p>자바스크립트를 사용하지 않는 경우<br>별도의 확인 절차 없이 바로 선택삭제 처리하므로 주의하시기 바랍니다.</p>
</noscript>
<?php } ?>
<!-- 페이지 -->
<?php echo $write_pages; ?>
<!-- 게시판 검색 시작 { -->
<fieldset id="bo_sch">
<legend>게시물 검색</legend>
<form name="fsearch" method="get">
<input type="hidden" name="bo_table" value="<?php echo $bo_table ?>">
<input type="hidden" name="sca" value="<?php echo $sca ?>">
<input type="hidden" name="sop" value="and">
<label for="sfl" class="sound_only">검색대상</label>
<select name="sfl" id="sfl">
<option value="wr_subject"<?php echo get_selected($sfl, 'wr_subject', true); ?>>제목</option>
<option value="wr_content"<?php echo get_selected($sfl, 'wr_content'); ?>>내용</option>
<option value="wr_subject||wr_content"<?php echo get_selected($sfl, 'wr_subject||wr_content'); ?>>제목+내용</option>
<option value="mb_id,1"<?php echo get_selected($sfl, 'mb_id,1'); ?>>아이디</option>
<option value="wr_name,1"<?php echo get_selected($sfl, 'wr_name,1'); ?>>작업자</option>
</select>
<label for="stx" class="sound_only">검색어<strong class="sound_only"> 필수</strong></label>
<input type="text" name="stx" value="<?php echo stripslashes($stx) ?>" required id="stx" class="frm_input required" size="50" maxlength="200">
<input type="submit" value="검색" class="btn_submit">
</form>
</fieldset>
<!-- } 게시판 검색 끝 -->
<script>
function camUpdate(bo_table,sca,wr_id, wr_1, wr_2, wr_4, wr_subject) {
var bo_table = '<?=$bo_table?>';
var sca = '<?=$sca?>';
var wr_id = f.wr_id.value;
var wr_1 = f.wr_1.value;
var wr_2 = f.wr_2.value;
var wr_4 = f.wr_4.value;
f.action = './apply.php?bo_table='+bo_table+'&wr_id='+wr_id+'&wr_1='+wr_1+'&wr_2='+wr_2+'&wr_4='+wr_4+'&wr_subject='+wr_subject+'&sca='+sca;
f.submit();
}
</script>
<?php if ($is_checkbox) { ?>
<script>
function cam_start() {
var wr_subject = f.wr_subject.value[0];
var wr_1 = f.wr_1.value[0];
var wr_2 = f.wr_2.value[0];
var wr_4 = f.wr_4.value[0];
f.action = './apply.php?bo_table='+bo_table+'&wr_id='+wr_id+'&wr_1='+wr_1+'&wr_2='+wr_2+'&wr_4='+wr_4+'&wr_subject='+wr_subject+'&sca='+sca;
f.submit();
}
function all_checked(sw) {
var f = document.fboardlist;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]")
f.elements[i].checked = sw;
}
}
function fboardlist_submit(f) {
var chk_count = 0;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]" && f.elements[i].checked)
chk_count++;
}
if (!chk_count) {
alert(document.pressed + "할 게시물을 하나 이상 선택하세요.");
return false;
}
if(document.pressed == "선택복사") {
select_copy("copy");
//f.action = "./board_list_update.php";
//return;
}
if(document.pressed == "선택이동") {
select_copy("move");
//f.action = "./board_list_update.php";
//return;
}
if(document.pressed == "선택삭제") {
if (!confirm("선택한 게시물을 정말 삭제하시겠습니까?\n\n한번 삭제한 자료는 복구할 수 없습니다\n\n답변글이 있는 게시글을 선택하신 경우\n답변글도 선택하셔야 게시글이 삭제됩니다."))
return false;
f.removeAttribute("target");
f.action = "./board_list_update.php";
}
if(document.pressed == "시작") {
if (!confirm("선택한 게시물을 정말 시작하시겠습니까?"))
return false;
f.action = "<?=$board_skin_url?>/apply.php";
//select_ste("cam_start");
}
if(document.pressed == "완료") {
if (!confirm("선택한 게시물을 정말 완료하시겠습니까?"))
return false;
f.action = "<?=$board_skin_url?>/apply.php";
//select_ste("cam_end");
}
return true;
}
// 선택한 게시물 복사 및 이동
function select_copy(sw) {
var f = document.fboardlist;
if (sw == "copy")
str = "복사";
else
str = "이동";
var sub_win = window.open("", "move", "left=50, top=50, width=500, height=550, scrollbars=1");
f.sw.value = sw;
f.target = "move";
f.action = "./move.php";
f.submit();
}
/*
var camUpdate = function(bo_table,sca,wr_id,wr_1,wr_2,wr_4,wr_subject){ //이곳에 필요한 변수들을 전부 불러옵니다
$.ajax({
type:"post",
url:"./apply.php",
data:
{ //상단에 입력된 값을 대입
action : 'cam_update',
bo_table : bo_table,
sca : sca,
wr_id : wr_id,
wr_1 : wr_1,
wr_2 : wr_2,
wr_4 : wr_4,
wr_subject : wr_subject
},
dataType:"html",
success:function(res){
if(res == 1)
alert("저장");
else
alert("실패");
}
});
}
function camUpdate() {
alert("성공");
var obj = JSON.parse('<?= $list_json; ?>');
var bo_table = '<?=$bo_table?>';
var sca = '<?=$sca?>';
var wr_1 = obj[0]['wr_1'];
var wr_2 = obj[1]['wr_2'];
var wr_4 = obj[2]['wr_4'];
var wr_subject = obj[3]['subject'];
//f.action = './apply.php?bo_table='+bo_table+'&wr_id='+wr_id+'&wr_1='+wr_1+'&wr_2='+wr_2+'&wr_4='+wr_4+'&wr_subject='+wr_subject+'&sca='+sca;
//f.submit();
}
*/
</script>
<?php } ?>
<!-- } 게시판 목록 끝 -->
-- apply.php --
<?php
include_once('./_common.php');
$wr_subject = substr($wr_subject,0,255);
$wr_subject = preg_replace("#[\\\]+$#", "", $wr_subject);
$row = sql_fetch(" select * from $write_table where wr_subject = '$wr_subject' ");
if($mode == "camUpdate" && $wr_subject == $row['wr_subject'] ) {
$wr_subject = substr($wr_subject,0,255);
$wr_subject = preg_replace("#[\\\]+$#", "", $wr_subject);
$wr_25 = "시작";
$wr_26 = date("Y-m-d H:i:s");
sql_query(" update {$write_table} set $wr_25 = '$wr_25', $wr_26 = '$wr_26' where bo_table = '$bo_table' ");
}
goto_url('./board.php?bo_table='.$bo_table.'&sca='.$sca);
?>
무엇이 문제일까요?ㅠㅠ
답변 1개
답변을 작성하려면 로그인이 필요합니다.