미채택 완료

게시판 리스트의 내용 일부를 업데이트 하려는데 안되요

2016-07-10 (일) 08:37:03 2,948

그누보드 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&amp;bo_table=<?=$bo_table?>&amp;sca=<?=$sca?>&amp;wr_id=<?=$list[$i]['wr_id']?>&amp;wr_1=<?=$list[$i]['wr_1']?>&amp;wr_2=<?=$list[$i]['wr_2']?>&amp;wr_4=<?=$list[$i]['wr_4']?>&amp;wr_subject=<?=$list[$i]['subject']?>" class='btn s'>시작</a>
   &nbsp;<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);

?>

무엇이 문제일까요?ㅠㅠ 

|

답변을 작성하려면 로그인이 필요합니다.