그누보드 - 글쓰기에서 전화번호 분할 입력 + 추가필드 활용 (2008/07/03 수정)

글쓰기에서 전화번호 분할 입력 + 추가필드 활용 (2008/07/03 수정) 정보

글쓰기에서 전화번호 분할 입력 + 추가필드 활용 (2008/07/03 수정)

본문

2007.09.17 핸드폰 013 추가
2008.03.12 목록페이지에서 사용하기 추가
2008.07.03 구분기호를 "-" 에서 "|" 로 변경 ... 주소내용중 "-"값 존재

##################################################
write.skin.php 상단부분에 아래의 내용을 활용

<?
//전화번호, 팩스, 핸드폰, 성별, 주소
$wr1   = explode("|",$write[wr_1]);
$tel1 = $wr1[0];
$tel2 = $wr1[1];
$tel3 = $wr1[2];
$fax1 = $wr1[3];
$fax2 = $wr1[4];
$fax3 = $wr1[5];
$hp1   = $wr1[6];
$hp2   = $wr1[7];
$hp3   = $wr1[8];
$sex   = $wr1[9];
$zip1 = $wr1[10];
$zip2 = $wr1[11];
$addr1 = $wr1[12];
$addr2 = $wr1[13];
?>

<? // 추가필드 ?>
<tr>
    <td style='padding-left:20px; height:30px;'>· 전화번호</td>
    <td style='padding-left:0px;'>
<select name='tel1' class='ed' itemname='전화번호'>
        <option value='02' <? if($tel1 == "02") echo "selected"; ?>>02</option>
        <option value='031' <? if($tel1 == "031") echo "selected"; ?>>031</option>
        <option value='032' <? if($tel1 == "032") echo "selected"; ?>>032</option>
        <option value='033' <? if($tel1 == "033") echo "selected"; ?>>033</option>
        <option value='041' <? if($tel1 == "041") echo "selected"; ?>>041</option>
        <option value='042' <? if($tel1 == "042") echo "selected"; ?>>042</option>
        <option value='043' <? if($tel1 == "043") echo "selected"; ?>>043</option>
        <option value='051' <? if($tel1 == "051") echo "selected"; ?>>051</option>
        <option value='052' <? if($tel1 == "052") echo "selected"; ?>>052</option>
        <option value='053' <? if($tel1 == "053") echo "selected"; ?>>053</option>
        <option value='054' <? if($tel1 == "054") echo "selected"; ?>>054</option>
        <option value='055' <? if($tel1 == "055") echo "selected"; ?>>055</option>
        <option value='061' <? if($tel1 == "061") echo "selected"; ?>>061</option>
        <option value='062' <? if($tel1 == "062") echo "selected"; ?>>062</option>
        <option value='063' <? if($tel1 == "063") echo "selected"; ?>>063</option>
        <option value='064' <? if($tel1 == "064") echo "selected"; ?>>064</option>
        <option value='070' <? if($tel1 == "070") echo "selected"; ?>>070</option>
        <option value='0502' <? if($tel1 == "0502") echo "selected"; ?>>0502</option>
        <option value='0505' <? if($tel1 == "0505") echo "selected"; ?>>0505</option>
      </select> -
      <input name='tel2' class=ed value='<?=$tel2?>' type='text' size='4' maxlength='4' onkeydown='onlyNumber(this);' itemname='전화번호 두번째자리'> -
      <input name='tel3' class=ed value='<?=$tel3?>' type='text' size='4' maxlength='4' onkeydown='onlyNumber(this);' itemname='전화번호 세번째자리'></td>
</tr>
<tr><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
<tr>
    <td style='padding-left:20px; height:30px;'>· 팩스번호</td>
    <td style='padding-left:0px;'>
<select name='fax1' class='ed' itemname='팩스번호'>
        <option value='02' <? if($fax1 == "02") echo "selected"; ?>>02</option>
        <option value='031' <? if($fax1 == "031") echo "selected"; ?>>031</option>
        <option value='032' <? if($fax1 == "032") echo "selected"; ?>>032</option>
        <option value='033' <? if($fax1 == "033") echo "selected"; ?>>033</option>
        <option value='041' <? if($fax1 == "041") echo "selected"; ?>>041</option>
        <option value='042' <? if($fax1 == "042") echo "selected"; ?>>042</option>
        <option value='043' <? if($fax1 == "043") echo "selected"; ?>>043</option>
        <option value='051' <? if($fax1 == "051") echo "selected"; ?>>051</option>
        <option value='052' <? if($fax1 == "052") echo "selected"; ?>>052</option>
        <option value='053' <? if($fax1 == "053") echo "selected"; ?>>053</option>
        <option value='054' <? if($fax1 == "054") echo "selected"; ?>>054</option>
        <option value='055' <? if($fax1 == "055") echo "selected"; ?>>055</option>
        <option value='061' <? if($fax1 == "061") echo "selected"; ?>>061</option>
        <option value='062' <? if($fax1 == "062") echo "selected"; ?>>062</option>
        <option value='063' <? if($fax1 == "063") echo "selected"; ?>>063</option>
        <option value='064' <? if($fax1 == "064") echo "selected"; ?>>064</option>
        <option value='0502' <? if($fax1 == "0502") echo "selected"; ?>>0502</option>
        <option value='0505' <? if($fax1 == "0505") echo "selected"; ?>>0505</option>
      </select> -
      <input name='fax2' class=ed value='<?=$fax2?>' type='text' size='4' maxlength='4' onkeydown='onlyNumber(this);' itemname='팩스번호 두번째자리'> -
      <input name='fax3' class=ed value='<?=$fax3?>' type='text' size='4' maxlength='4' onkeydown='onlyNumber(this);' itemname='팩스번호 세번째자리'></td></tr>
<tr><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
<tr>
    <td style='padding-left:20px; height:30px;'>· 휴대전화</td>
    <td style='padding-left:0px;'>
<select name='hp1' class='ed' itemname='휴대전화'>
        <option value='010' <? if($hp1 == "010") echo "selected"; ?>>010</option>
        <option value='011' <? if($hp1 == "011") echo "selected"; ?>>011</option>
        <option value='013' <? if($hp1 == "013") echo "selected"; ?>>013</option>
        <option value='016' <? if($hp1 == "016") echo "selected"; ?>>016</option>
        <option value='017' <? if($hp1 == "017") echo "selected"; ?>>017</option>
        <option value='018' <? if($hp1 == "018") echo "selected"; ?>>018</option>
        <option value='019' <? if($hp1 == "019") echo "selected"; ?>>019</option>
      </select> -
      <input name='hp2' class=ed value='<?=$hp2?>' type='text' size='4' maxlength='4' onkeydown='onlyNumber(this);' itemname='휴대전화 두번째자리'> -
      <input name='hp3' class=ed value='<?=$hp3?>' type='text' size='4' maxlength='4' onkeydown='onlyNumber(this);' itemname='휴대전화 세번째자리'></td></tr>
<tr><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
<tr>
    <td style='padding-left:20px; height:30px;'>· 주소</td>
    <td><input size="4" class=ed name="zip1" itemname="우편번호 앞자리" readonly value="<?=$zip1?>"> -
<input size="4" class=ed name="zip2" itemname="우편번호 뒷자리" readonly value="<?=$zip2?>">
<a href="javascript:;" onclick="win_zip('fwrite', 'zip1', 'zip2', 'add1', 'add2');"><img src="<?=$board_skin_path?>/img/btn_post.gif" border="0" align="absmiddle" /></a><br />
<input name="add1" class=ed type="text" style="width:100%" value="<?=$add1?>" readonly /><br />
<input name="add2" class=ed type="text" style="width:100%" value="<?=$add2?>" /></td></tr>
<tr><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
<tr>
    <td style='padding-left:20px; height:30px;'>· 성별</td>
    <td>
<input type="radio" name="sex" value="남" <?=$sex=="남"?"checked":""?>>남
<input type="radio" name="sex" value="여" <?=$sex=="여"?"checked":"";?>>여</td></tr>
<tr><td colspan="2" height="1" bgcolor="#e7e7e7"></td></tr>
<tr>
    <td style='padding-left:20px; height:30px;'>· 추가2</td>
    <td><input class="hp_skin_field" style="width:100%;" name="wr_2" id="wr_2" itemname="추가2" value="<?=$write["wr_2"]?>"></td></tr>
<tr><td colspan="2" height="1" bgcolor="#e7e7e7"></td></tr>
<tr>
    <td style='padding-left:20px; height:30px;'>· 추가3</td>
    <td><input class="hp_skin_field" style="width:100%;" name="wr_3" id="wr_3" itemname="추가3" value="<?=$write["wr_3"]?>"></td></tr>
<tr><td colspan="2" height="1" bgcolor="#e7e7e7"></td></tr>
<tr>
    <td style='padding-left:20px; height:30px;'>· 추가4</td>
    <td><input class="hp_skin_field" style="width:100%;" name="wr_4" id="wr_4" itemname="추가4" value="<?=$write["wr_4"]?>"></td></tr>
<tr><td colspan="2" height="1" bgcolor="#e7e7e7"></td></tr>
<tr>
    <td style='padding-left:20px; height:30px;'>· 추가5</td>
    <td><input class="hp_skin_field" style="width:100%;" name="wr_5" id="wr_5" itemname="추가5" value="<?=$write["wr_5"]?>"></td></tr>
<tr><td colspan="2" height="1" bgcolor="#e7e7e7"></td></tr>
<tr>
    <td style='padding-left:20px; height:30px;'>· 추가6</td>
    <td><input class="hp_skin_field" style="width:100%;" name="wr_6" id="wr_6" itemname="추가6" value="<?=$write["wr_6"]?>"></td></tr>
<tr><td colspan="2" height="1" bgcolor="#e7e7e7"></td></tr>
<tr>
    <td style='padding-left:20px; height:30px;'>· 추가7</td>
    <td><input class="hp_skin_field" style="width:100%;" name="wr_7" id="wr_7" itemname="추가7" value="<?=$write["wr_7"]?>"></td></tr>
<tr><td colspan="2" height="1" bgcolor="#e7e7e7"></td></tr>
<tr>
    <td style='padding-left:20px; height:30px;'>· 추가8</td>
    <td><input class="hp_skin_field" style="width:100%;" name="wr_8" id="wr_8" itemname="추가8" value="<?=$write["wr_8"]?>"></td></tr>
<tr><td colspan="2" height="1" bgcolor="#e7e7e7"></td></tr>
<tr>
    <td style='padding-left:20px; height:30px;'>· 추가9</td>
    <td><input class="hp_skin_field" style="width:100%;" name="wr_9" id="wr_9" itemname="추가9" value="<?=$write["wr_9"]?>"></td></tr>
<tr><td colspan="2" height="1" bgcolor="#e7e7e7"></td></tr>
<tr>
    <td style='padding-left:20px; height:30px;'>· 추가10</td>
    <td><input class="hp_skin_field" style="width:100%;" name="wr_10" id="wr_10" itemname="추가10" value="<?=$write["wr_10"]?>"></td></tr>
<tr><td colspan="2" height="1" bgcolor="#e7e7e7"></td></tr>
<? //추가필드 끝 ?>

##################################################
write_update.skin.php 에 아래의 내용을 활용

<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가

// 자신만의 코드를 넣어주세요.

//전화번호, 성별, 주소
$wr_1 = "$tel1|$tel2|$tel3|$fax1|$fax2|$fax3|$hp1|$hp2|$hp3|$sex|$zip1|$zip2|$add1|$add2";
$sql1 = " update $write_table set wr_1 = '$wr_1' where wr_id = '$wr_id' ";
sql_query($sql1);
?>

##################################################
view.skin.php 에 아래의 내용을 활용
<?
//전화번호, 팩스, 핸드폰, 성별, 주소
$wr1 = explode("|",$view[wr_1]);
$tel1 = $wr1[0];
$tel2 = $wr1[1];
$tel3 = $wr1[2];
$fax1 = $wr1[3];
$fax2 = $wr1[4];
$fax3 = $wr1[5];
$hp1 = $wr1[6];
$hp2 = $wr1[7];
$hp3 = $wr1[8];
$hp3 = $wr1[9];
$zip1 = $wr1[10];
$zip2 = $wr1[11];
$add1 = $wr1[12];
$add2 = $wr1[13];
?>

<? // 추가필드 ?>
<tr><td width="100%" bgcolor="#FFFFFF" align="center">
<table width="100%" border="0" cellpadding="5" cellspacing="0">
    <col width="70" />
    <col />
    <tr><td style="padding:6 0 6 10;">전화번호</td><td bgcolor="#FFFFFF"><?=$tel1?>-<?=$tel2?>-<?=$tel3?></td></tr>
    <tr><td height="1" bgcolor="#E7E7E7" colspan="2"></td></tr>
    <tr><td style="padding:6 0 6 10;">팩스번호</td><td><?=$fax1?>-<?=$fax2?>-<?=$fax3?></td></tr>
    <tr><td height="1" bgcolor="#E7E7E7" colspan="2"></td></tr>
    <tr><td style="padding:6 0 6 10;">핸드폰</td><td><?=$hp1?>-<?=$hp2?>-<?=$hp3?></td></tr>
    <tr><td height="1" bgcolor="#E7E7E7" colspan="2"></td></tr>
    <tr><td style="padding:6 0 6 10;">성별</td><td><?=$sex?></td></tr>
    <tr><td height="1" bgcolor="#E7E7E7" colspan="2"></td></tr>
    <tr><td style="padding:6 0 6 10;">주소</td><td >(<?=$zip1?>-<?=$zip2?>) <?=$add1?> <?=$add2?></td></tr>
    <tr><td height="1" bgcolor="#E7E7E7" colspan="2"></td></tr>
    <tr><td style="padding:6 0 6 10;">추가2</td><td><?=$view[wr_2]?></td></tr>
    <tr><td height="1" bgcolor="#E7E7E7" colspan="2"></td></tr>
    <tr><td style="padding:6 0 6 10;">추가3</td><td><?=$view[wr_3]?></td></tr>
    <tr><td height="1" bgcolor="#E7E7E7" colspan="2"></td></tr>
    <tr><td style="padding:6 0 6 10;">추가4</td><td><?=$view[wr_4]?></td></tr>
    <tr><td height="1" bgcolor="#E7E7E7" colspan="2"></td></tr>
    <tr><td style="padding:6 0 6 10;">추가5</td><td><?=$view[wr_5]?></td></tr>
    <tr><td height="1" bgcolor="#E7E7E7" colspan="2"></td></tr>
    <tr><td style="padding:6 0 6 10;">추가6</td><td><?=$view[wr_6]?></td></tr>
    <tr><td height="1" bgcolor="#E7E7E7" colspan="2"></td></tr>
    <tr><td style="padding:6 0 6 10;">추가7</td><td><?=$view[wr_7]?></td></tr>
    <tr><td height="1" bgcolor="#E7E7E7" colspan="2"></td></tr>
    <tr><td style="padding:6 0 6 10;">추가8</td><td><?=$view[wr_8]?></td></tr>
    <tr><td height="1" bgcolor="#E7E7E7" colspan="2"></td></tr>
    <tr><td style="padding:6 0 6 10;">추가9</td><td><?=$view[wr_9]?></td> </tr>
    <tr><td height="1" bgcolor="#E7E7E7" colspan="2"></td></tr>
    <tr><td style="padding:6 0 6 10;">추가10</td><td><?=$view[wr_10]?></td></tr>
    <tr><td height="1" bgcolor="#E7E7E7" colspan="2"></td></tr>
</table>
</td></tr>
<? //추가필드 끝 ?>

##################################################
list.skin.php 에 내용 활용하기


<? for ($i=0; $i<count($list); $i++) { ?>

아래쪽에 코드 추가

<?
//전화번호, 팩스, 핸드폰, 성별, 주소
$wr1 = explode("|",$view[wr_1]);
$tel1 = $wr1[0];
$tel2 = $wr1[1];
$tel3 = $wr1[2];
$fax1 = $wr1[3];
$fax2 = $wr1[4];
$fax3 = $wr1[5];
$hp1 = $wr1[6];
$hp2 = $wr1[7];
$hp3 = $wr1[8];
$hp3 = $wr1[9];
$zip1 = $wr1[10];
$zip2 = $wr1[11];
$add1 = $wr1[12];
$add2 = $wr1[13];
?>

전화: <?=$tel1?>-<?=$tel2?>-<?=$tel3?><br>
팩스: <?=$fax1?>-<?=$fax2?>-<?=$fax3?><br>
핸드폰: <?=$hp1?>-<?=$hp2?>-<?=$hp3?><br>

댓글 6개

지앤미 자기소개 아이디로 검색 전체게시물 회원게시물

자기소개 아이디로 검색 전체게시물 회원게시물

07.04.29 04:43:50

수고하셨습니다....

아래 쿼리문 부분은 write.skin.php가 아닌 write_update.****.php 정도로 수정하셔야 겠습니다.

그리고 쿼리부분을 좀 줄이시려면

http://sir.co.kr/bbs/board.php?bo_table=g4_tiptech&wr_id=10366 를 참조하십시오....

즐거운 휴일 되세요....^^

해피정 홈페이지 자기소개 아이디로 검색 전체게시물 회원게시물

홈페이지 자기소개 아이디로 검색 전체게시물 회원게시물

07.05.01 04:23:57

지적감사합니다. 제가 실수를 했었네요.
write.php --> write.skin.php
write.skin.php --> write_update.skin.php 으로 수정했습니다.

GunENE 자기소개 아이디로 검색 전체게시물 회원게시물

자기소개 아이디로 검색 전체게시물 회원게시물

10.01.07 15:39:40

정말 유용한 팁입니다..ㅎㅎ 감사^^

줌씨아 자기소개 아이디로 검색 전체게시물 회원게시물

자기소개 아이디로 검색 전체게시물 회원게시물

10.02.07 23:32:08

list.skin.php 에 내용 활용하기 부분이 틀려서 수정해 드립니다.

<?
//전화번호, 팩스, 핸드폰, 성별, 주소
$wr1 = explode("|",$list[$i][wr_1]); <--- 이 부분을 이렇게 해 줘야 나타납니다.
$tel1 = $wr1[0];
이하생략~~~
?>

전화: <?=$tel1?>-<?=$tel2?>-<?=$tel3?>