카운터 자동 증가하는 부분에 질문 있습니다.
본문
게시판 글쓰기 write.skin.php에서 wr_1과 wr_4에 글 쓸때마다 자동으로 숫자가 증가되게끔을
원해서 어느분께서 알려주셨었는데요...이걸 응용해야 하는데 여기서 궁금한게 있어요
<?php
if($w == "") {
$sql = " SELECT COUNT(DISTINCT `wr_parent`) AS `cnt` FROM {$write_table} ";
$row = sql_fetch($sql);
$wr_count1 = $row['cnt']+1;
$wr_count2 = $row['cnt']+1;
}
if ($w == "u") {
$wr_count1 = $wr_1;
$wr_count2 = $wr_4;
}
?>
DB 쿼리문에서 빨간색 글씨 cnt는 어느 테이블에서 가져온 건가요?? 아님 명령어인가요???
지금 제가 변경하려는 건 셀렉트 박스(필드는 wr_2 / 파란색 글씨)의 선택에 따라 wr_1,wr_4 숫자를 증가해야하거든요...ㅠㅠ
소스는 아래에 올려보겠습니다.
<?php
if (!defined('_GNUBOARD_')) exit; // 개별 페이지 접근 불가
// add_stylesheet('css 구문', 출력순서); 숫자가 작을 수록 먼저 출력됨
//add_stylesheet('<link rel="stylesheet" href="'.$board_skin_url.'/style.css">', 10);
?>
<link rel="stylesheet" type="text/css" href="../calendar/style.css" />
<link rel="stylesheet" type="text/css" href="../calendar/jquery.datetimepicker.css"/>
<link rel="stylesheet" type="text/css" href="../css/table.css">
<script type="text/javascript" src="../calendar/calendar.js"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<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">
<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;
?>
<table cellspacing='0'>
<tr class='even'>
<td class='num'>NO</td>
<td class='num'>업체코드</td>
<td class='name'>업체명</td>
<td class='num'>RACK</td>
<td class='model'>모델명</td>
<td class='model'>추가모델명</td>
<td class='num'>TYPE</td>
<td class='arr'>FIX규격</td>
<td class='time'>Test Point</td>
<td class='day'>납기일자</td>
<td class='day'>필름일자</td>
<td class='num'>수량</td>
<td class='sel'>조합</td>
<td class='ar2'>배열</td>
<td class='sel'>층수</td>
<td class='time'>검사회수</td>
</tr>
<?php
if($w == "") {
$sql = " SELECT COUNT(DISTINCT `wr_parent`) AS `cnt` FROM {$write_table} ";
$row = sql_fetch($sql);
if($wr_3 == "101") {
$wr_count1 = $row['cnt']+1;
$wr_count2 = $row['cnt']+1;
}
if($wr_3 == "102") {
$wr_count1 = $row['cnt']+1;
$wr_count2 = $row['cnt']+1;
}
}
if ($w == "u") {
$wr_count1 = $wr_1;
$wr_count2 = $wr_4;
}
?>
<tr>
<td><input type="text" name="wr_1" value="<?php echo $wr_count1 ?>" id="wr_1" required class="num" maxlength="20"></td>
<td>
<select class="selc" name="wr_2" id="wr_2" value="<?php echo $wr_2 ?>" onchange="chkcode()" class='selc' required>
<option value="">업체코드</option>
<option value="002" <?php if($wr_2 == "002") echo "selected=\"selected\""; ?> label="002" />002</option>
<option value="101" <?php if($wr_2 == "101") echo "selected=\"selected\""; ?> label="101" />101</option>
<option value="102" <?php if($wr_2 == "102") echo "selected=\"selected\""; ?> label="102" />102</option>
<option value="103" <?php if($wr_2 == "103") echo "selected=\"selected\""; ?> label="103" />103</option>
<option value="104" <?php if($wr_2 == "104") echo "selected=\"selected\""; ?> label="104" />104</option>
<option value="105" <?php if($wr_2 == "105") echo "selected=\"selected\""; ?> label="105" />105</option>
<option value="106" <?php if($wr_2 == "106") echo "selected=\"selected\""; ?> label="106" />106</option>
<option value="107" <?php if($wr_2 == "107") echo "selected=\"selected\""; ?> label="107" />107</option>
<option value="108" <?php if($wr_2 == "108") echo "selected=\"selected\""; ?> label="108" />108</option>
<option value="109" <?php if($wr_2 == "109") echo "selected=\"selected\""; ?> label="109" />109</option>
</select>
</td>
<td><input type="text" name="wr_3" value="<?php echo $wr_3; ?>" id="wr_3" required class="name" maxlength="20"></td>
<td><input type="text" name="wr_4" value="<?php echo $wr_count2 ?>" id="wr_4" required class="num" maxlength="20"></td>
<td><input type="text" name="wr_subject" value="<?php echo $subject ?>" id="wr_subject" required class="model" maxlength="255"></td>
<td><input type="text" name="wr_5" value="<?php echo $wr_5 ?>" id="wr_5" class="model"></td>
<td>
<?php if ($is_category) { ?>
<select name="ca_name" id="ca_name" required class="selc" >
<option value="">선택하세요</option>
<?php echo $category_option ?>
</select>
<? } ?>
</td>
<td>
<select class="selc" name="wr_6" id="wr_6" value="<?php echo $wr_6 ?>" required>
<option value="">규격 선택</option>
<option value="US-SS" <?php if($wr_6 == "US-SS") echo "selected=\"selected\""; ?> label="US-SS" />US-SS</option>
<option value="US-S" <?php if($wr_6 == "US-S") echo "selected=\"selected\""; ?> label="US-S" />US-S</option>
<option value="US-M" <?php if($wr_6 == "US-M") echo "selected=\"selected\""; ?> label="US-M"/>US-M</option>
<option value="UD-SS" <?php if($wr_6 == "UD-SS") echo "selected=\"selected\""; ?> label="UD-SS" />UD-SS</option>
<option value="UD-S" <?php if($wr_6 == "UD-S") echo "selected=\"selected\""; ?> label="UD-S" />UD-S</option>
<option value="UD-M" <?php if($wr_6 == "UD-M") echo "selected=\"selected\""; ?> label="UD-M"/>UD-M</option>
</select>
</td>
<td><input type="text" name="wr_7" value="<?php echo $wr_7 ?>" id="wr_7" class="name" maxlength="20" required></td>
<td><input type="text" name="wr_8" value="<?=$wr_8 ?>" id="wr_8" required class="day date-picker" maxlength="12"></td>
<td><input type="text" name="wr_9" value="<?php echo $wr_9 ?>" id="wr_9" required class="day date-picker" maxlength="12"></td>
<td><input type="text" name="wr_10" value="<?php echo $wr_10 ?>" id="wr_10" class="num" maxlength="20" required></td>
<td>
<select class="selc" name="wr_11" id="wr_11" value="<?php echo $wr_11 ?>" required>
<option value="">조합종류</option>
<option value="1종조합" <?php if($wr_11 == "1종조합") echo "selected=\"selected\""; ?> label="1종조합" />1종조합</option>
<option value="2종조합" <?php if($wr_11 == "2종조합") echo "selected=\"selected\""; ?> label="2종조합 "/>2종조합</option>
<option value="3종조합" <?php if($wr_11 == "3종조합") echo "selected=\"selected\""; ?> label="3종조합" />3종조합</option>
<option value="4종조합" <?php if($wr_11 == "4종조합") echo "selected=\"selected\""; ?> label="4종조합" />4종조합</option>
<option value="5종조합" <?php if($wr_11 == "5종조합") echo "selected=\"selected\""; ?> label="5종조합" />5종조합</option>
<option value="5종조합이상" <?php if($wr_11 == "상5종조합이상") echo "selected=\"selected\""; ?> label="5종조합이상" />5종조합이상</option>
</select>
</td>
<td>
<input type="text" name="wr_12" value="<?=$wr_12 ?>" id="wr_12" required class="ar" maxlength="3" >연
<input type="text" name="wr_13" value="<?=$wr_13 ?>" id="wr_13" required class="ar" maxlength="3">조
<input type="text" name="wr_14" value="<?=$wr_14 ?>" id="wr_14" required class="ar" maxlength="3">배열
</td>
<td><input type="text" name="wr_15" value="<?=$wr_16 ?>" id="wr_15" required class="num" maxlength="3"></td>
<td><input type="text" name="wr_16" value="<?=$wr_16 ?>" id="wr_16" required class="num">회</td>
</tr>
</table>
<table cellspacing='0' style='margin-top:0px;'>
<tr class='even'>
<td class='name'>작업자</td>
<td class='day'>작업일자</td>
<td class='sel'>검사밀도</td>
<td class='mil'>Adjane Value</td>
<td class='sel'>검사단위</td>
<td class='sel'>검사유형</td>
</tr>
<tr>
<td><input type="text" name="wr_17" value="<?=$wr_17 ?>" id="wr_17" required class="name" maxlength="20"></td>
<td><input type="text" name="wr_18" value="<?php echo $wr_18 ?>" id="wr_18" required class="day date-picker" maxlength="12"></td>
<td>
<select class="selc" name="wr_19" id="wr_19" value="<?php echo $wr_19 ?>" required>
<option value="">검사밀도</option>
<option value="50mil" <?php if($wr_19 == "50mil") echo "selected=\"selected\""; ?> label="50mil" />50mil</option>
<option value="70mil" <?php if($wr_19 == "70mil") echo "selected=\"selected\""; ?> label="70mil" />70mil</option>
<option value="100mil" <?php if($wr_19 == "100mil") echo "selected=\"selected\""; ?> label="100mil" />100mil</option>
</select>
</td>
<td><input type="text" name="wr_20" value="<?php echo $wr_20 ?>" id="wr_20" class='num' required maxlength="12">mil[mm] </td>
<td>
<select class="selc" name="wr_21" id="wr_21" value="<?php echo $wr_21 ?>" required>
<option value="">검사단위</option>
<option value="PNL" <?php if($wr_21 == "PNL") echo "selected=\"selected\""; ?> label="PNL" />PNL</option>
<option value="KIT" <?php if($wr_21 == "KIT") echo "selected=\"selected\""; ?> label="KIT" />KIT</option>
<option value="PCS" <?php if($wr_21 == "PCS") echo "selected=\"selected\""; ?> label="PCS" />PCS</option>
</select>
</td>
<td>
<select class="selc" name="wr_22" id="wr_22" value="<?php echo $wr_22 ?>" required>
<option value="">검사유형</option>
<option value="신규" <?php if($wr_22 == "신규") echo "selected=\"selected\""; ?> label="신규" />신규</option>
<option value="기존" <?php if($wr_22 == "기존") echo "selected=\"selected\""; ?> label="기존 "/>기존</option>
<option value="재검" <?php if($wr_22 == "재검") echo "selected=\"selected\""; ?> label="재검" />재검</option>
</select>
</td>
</tr>
</table>
<table style='margin-top:60px;'>
<tr><td class='text-area1'>참고사항<strong class="sound_only">필수</strong></td></tr>
<tr>
<td class="text-area2">
<?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>
</table>
<div class="btn_confirm">
<input type="submit" value="등록" id="" accesskey="s" class="bt">
<input type="button" value="취소" id="" class="btn_cls" onClick='javascript:location.href="./board.php?bo_table=<?php echo $bo_table ?>"' class="btn_cls">
</div>
</form>
<script src="../calendar/jquery.js"></script>
<script src="../calendar/jquery.datetimepicker.js"></script>
<script type="text/javascript">
$('#datetimepicker1').datetimepicker({
datepicker:false,
format:'H:i',
step:5
});
$('#datetimepicker2').datetimepicker({
datepicker:false,
format:'H:i',
step:5
});
<?php if($write_min || $write_max) { ?>
// 글자수 제한
var char_min = parseInt(<?php echo $write_min; ?>); // 최소
var char_max = parseInt(<?php echo $write_max; ?>); // 최대
check_byte("wr_content", "char_count");
$(function() {
$("#wr_content").on("keyup", function() {
check_byte("wr_content", "char_count");
});
});
<?php } ?>
function html_auto_br(obj)
{
if (obj.checked) {
result = confirm("자동 줄바꿈을 하시겠습니까?\n\n자동 줄바꿈은 게시물 내용중 줄바뀐 곳을<br>태그로 변환하는 기능입니다.");
if (result)
obj.value = "html2";
else
obj.value = "html1";
}
else
obj.value = "";
}
function fwrite_submit(f)
{
<?php echo $editor_js; // 에디터 사용시 자바스크립트에서 내용을 폼필드로 넣어주며 내용이 입력되었는지 검사함 ?>
var subject = "";
var content = "";
$.ajax({
url: g5_bbs_url+"/ajax.filter.php",
type: "POST",
data: {
"subject": f.wr_subject.value,
"content": f.wr_content.value
},
dataType: "json",
async: false,
cache: false,
success: function(data, textStatus) {
subject = data.subject;
content = data.content;
}
});
if (subject) {
alert("제목에 금지단어('"+subject+"')가 포함되어있습니다");
f.wr_subject.focus();
return false;
}
if (content) {
alert("내용에 금지단어('"+content+"')가 포함되어있습니다");
if (typeof(ed_wr_content) != "undefined")
ed_wr_content.returnFalse();
else
f.wr_content.focus();
return false;
}
if (document.getElementById("char_count")) {
if (char_min > 0 || char_max > 0) {
var cnt = parseInt(check_byte("wr_content", "char_count"));
if (char_min > 0 && char_min > cnt) {
alert("내용은 "+char_min+"글자 이상 쓰셔야 합니다.");
return false;
}
else if (char_max > 0 && char_max < cnt) {
alert("내용은 "+char_max+"글자 이하로 쓰셔야 합니다.");
return false;
}
}
}
<?php echo $captcha_js; // 캡챠 사용시 자바스크립트에서 입력된 캡챠를 검사함 ?>
document.getElementById("btn_submit").disabled = "disabled";
return true;
}
</script>
</section>
<!-- } 게시물 작성/수정 끝 -->
<link rel="stylesheet" type="text/css" href="../css/selectlist.css">
<script src="http://code.jquery.com/jquery-1.11.2.min.js"></script>
<script type="text/javascript" src="../js/jquery.selectlist.js"></script>
<script type="text/javascript">
/*
$(function(){
$('select').selectlist({
zIndex: 10,
width: 120,
height: 25
});
})
*/
</script>
답변 1
SELECT COUNT(DISTINCT `wr_parent`) AS `cnt` FROM {$write_table} ";
select count = 갯수를 찾는다.
(distinct 'wr_parent') = wr_parent이 중복되지 않는것을
as 'cnt' = cnt라는 곳에 갯수를 담는다.
from {$write_table} = $write_table(현재 게시판에서)
그렇기때문에
$wr_count1 = $row['cnt']+1;
이렇게 하단에 cnt로 뿌려오는것이지요