게시판 셀렉트 박스 및 필드바꾸기 질문이요 ㅠ
본문
1.제목에다가 등록한 계정을 넣을 수있나요..?
2.필드6에서 선택을 한 후 수정을 누르면 DB는 들어가는데 목록창에는 계속 선택하세요가 뜨네요 ㅠ
관련자료 http://msmartbiz.com/cpa/bbs/board.php?bo_table=db
<div class="tbl_head01 tbl_wrap">
<table>
<caption><?php echo $board['bo_subject'] ?> 목록</caption>
<thead>
<tr>
<?php if ($is_checkbox) { ?>
<th scope="col" style="padding:0 7px;">
<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">No</th>
<th scope="col">Date</th>
<th scope="col">제목</th>
<th scope="col">필드1</th> <!-- 1 -->
<th scope="col">필드2</th> <!-- 2 -->
<th scope="col">필드3</th> <!-- 3 -->
<th scope="col">필드4</th> <!-- 4 -->
<th scope="col">필드5</th> <!-- 5 -->
<th scope="col">필드6</th>
<!--
<th scope="col">필드7</th>
<th scope="col">필드8</th>
<th scope="col">필드9</th>
<th scope="col">필드10</th>
-->
<th scope="col">수정</th>
</tr>
</thead>
<tbody>
<?php
for ($i=0; $i<count($list); $i++) {
$up_date = date("y/m/d", strtotime($list[$i]['wr_datetime']));
?>
<tr>
<?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]['num'];?></td><!-- 번호 -->
<td class="td_date" title="<?php echo $list[$i]['wr_datetime'] ?>"><a href="<?php echo $list[$i]['href'] ?>"><?php echo $up_date;?></a></td><!-- 등록일 -->
<td class="td_subject"><input type="text" name="wr_subject[]" value="<?php echo $list[$i]['subject'] ?>" id="wr_subject_<?php echo $i ?>tt" class="lists"></td><!-- 제목 -->
<td class="td_field" title="<?php echo $list[$i]['wr_1'] ?>"><input type="text" name="wr_1[]" value="<?php echo $list[$i]['wr_1'] ?>" id="wr_1_<?php echo $i ?>" class="lists"></td>
<td class="td_field" title="<?php echo $list[$i]['wr_2'] ?>"><input type="text" name="wr_2[]" value="<?php echo $list[$i]['wr_2'] ?>" id="wr_2_<?php echo $i ?>" class="lists"></td>
<td class="td_field" title="<?php echo $list[$i]['wr_3'] ?>"><input type="text" name="wr_3[]" value="<?php echo $list[$i]['wr_3'] ?>" id="wr_3_<?php echo $i ?>" class="lists"></td>
<td class="td_field" title="<?php echo $list[$i]['wr_4'] ?>"><input type="text" name="wr_4[]" value="<?php echo $list[$i]['wr_4'] ?>" id="wr_4_<?php echo $i ?>" class="lists"></td>
<td class="td_field" title="<?php echo $list[$i]['wr_5'] ?>"><input type="text" name="wr_5[]" value="<?php echo $list[$i]['wr_5'] ?>" id="wr_5_<?php echo $i ?>" class="lists"></td>
<td class="td_field" title="<?php echo $list[$i]['wr_6'] ?>">
<select name="wr_6[]" id="wr_6_<?php echo $i ?>" required itemname="소재지">
<option value="">선택하세요</option>
<option value="충남" <? if($write[wr_6] == "충남") echo " selected"; ?>>충남</option>
<option value="충북" <? if($write[wr_6] == "충북") echo " selected"; ?>>충북</option>
<option value="전남" <? if($write[wr_6] == "전남") echo " selected"; ?>>전남</option>
<option value="전북" <? if($write[wr_6] == "전북") echo " selected"; ?>>전북</option>
</select>
<!--
<select name="wr_6[]" id="wr_6_<?php echo $i ?>" required itemname="소재지">
<option name="wr_6[]" id="wr_6_<?php echo $i ?>" value='공백' <? if($write[wr_6] == 선택하세요) echo " selected "; ?>>선택하세요</option>
<option name="wr_6[]" id="wr_6_<?php echo $i ?>" value='충남' <? if($write[wr_6] == 충남) echo " selected "; ?>>충남</option>
<option name="wr_6[]" id="wr_6_<?php echo $i ?>" value='충북' <? if($write[wr_6] == 충북) echo " selected "; ?>>충북</option>
<option name="wr_6[]" id="wr_6_<?php echo $i ?>" value='전남' <? if($write[wr_6] == 전남) echo " selected "; ?>>전남</option>
<option name="wr_6[]" id="wr_6_<?php echo $i ?>" value='전북' <? if($write[wr_6] == 전북) echo " selected "; ?>>전북</option>
</select></td>
-->
<!--
<td class="td_field" title="<?php echo $list[$i]['wr_7'] ?>"><input type="text" name="wr_7[]" value="<?php echo $list[$i]['wr_7'] ?>" id="wr_7" class="lists"></td>
<td class="td_field" title="<?php echo $list[$i]['wr_8'] ?>"><input type="text" name="wr_8[]" value="<?php echo $list[$i]['wr_8'] ?>" id="wr_8" class="lists"></td>
<td class="td_field" title="<?php echo $list[$i]['wr_9'] ?>"><input type="text" name="wr_9[]" value="<?php echo $list[$i]['wr_9'] ?>" id="wr_9" class="lists"></td>
<td class="td_field" title="<?php echo $list[$i]['wr_10'] ?>"><input type="text" name="wr_10[]" value="<?php echo $list[$i]['wr_10'] ?>" id="wr_10" class="lists"></td>
-->
<td class="td_conf"><span id="flip_<?php echo $i ?>">수정</span></td>
<script>
$(document).ready(function(){
$("#flip_<?php echo $i ?>").click(function(){
var bo_table = "<?=$bo_table?>";
var wr_id = "<?php echo $list[$i]['wr_id'] ?>";
var value0 = $("#wr_subject_<?php echo $i ?>").val();
var value1 = $("#wr_1_<?php echo $i ?>").val();
var value2 = $("#wr_2_<?php echo $i ?>").val();
var value3 = $("#wr_3_<?php echo $i ?>").val();
var value4 = $("#wr_4_<?php echo $i ?>").val();
var value5 = $("#wr_5_<?php echo $i ?>").val();
var value6 = $("#wr_6_<?php echo $i ?>").val();
$.ajax({
type: "POST",
url: "<?php echo $board_skin_url?>/list_up.php",
data: { bo_table:bo_table, wr_id:wr_id, wr_subject:value0, wr_1:value1, wr_2:value2, wr_3:value3, wr_4:value4, wr_5:value5, wr_6:value6 },
success: function () {
//do somthing here
location.reload();
alert("수정되었습니다")
}
});
});
});
</script>
</tr>
<?php } ?>
<?php if (count($list) == 0) { echo '<tr><td colspan="'.$colspan.'" class="empty_table">게시물이 없습니다.</td></tr>'; } ?>
</tbody>
</table>
</div>