특정보드 여분필드 추가가 하려합니다. 채택완료
보드의 write_update.php 에 아래처럼 추가
$sql = " update $write_table set
wr_tourok = '$wr_tourok', wr_11 = '$wr_11', wr_12 = '$wr_12',
wr_13 = '$wr_13',
wr_14 = '$wr_14',
wr_15 = '$wr_15' where wr_id = '$wr[wr_id]' ";
sql_query($sql);
----------------------------------이러면 수정에서는 등록하면 등록이 되는데요..
처음 등록은 저장이 안돼요.
bbs/write_update.php 에
$sql = " insert into $write_table =>여기에도 추가를 해줘야 할것 같은데요..
여기에 추가를 하면 다른 보드에도 오류 등 영향이 있겠죠?
그러면 특정 test 보드의 write_update.php 에
$sql = " insert into $write_table => 도 같이 작성해주는 방법이 있을까요?
감사합니다.
답변 2개
1. 해당 게시판만 사용하도록 skin을 따로 설정
2. 스킨폴더에 write_update.skin.php 화일 생성
3. 내용
$add_qry = "wr_tourok = '$wr_tourok',wr_11 = '$wr_11', wr_12= '$wr_12' ~~~~~";
sql_query("update $write_table set $add_qry where wr_id ='$wr_id' ");
?>
4. 질문에서 추가한 코드 삭제
댓글을 작성하려면 로그인이 필요합니다.
등록페이지에 hidden input 하나를 생성하고
추가된테이블을 대상으로 하는거라면 1 이라는 값을 넣어줍시다.
write_update.php 파일의 insert 부분으로 넘어와서..
</span></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;">if(trim($</span></font><span style="color: rgb(72, 72, 72); font-family: 돋움, Dotum, sans-serif; font-size: 14px; line-height: 25.203125px;">add_table</span><span style="font-size: 14px; line-height: 25.203125px; color: rgb(72, 72, 72); font-family: 돋움, Dotum, sans-serif;"></span><span style="font-size: 14px; line-height: 25.203125px; color: rgb(72, 72, 72); font-family: 돋움, Dotum, sans-serif;">)) {</span></p><p>$add_sql="</p><p><span style="font-size: 11pt; line-height: 1.5;">wr_tourok = '$wr_tourok',</span></p><p>wr_11 = '$wr_11',</p><p>wr_12 = '$wr_12',</p><p>wr_13 = '$wr_13',</p><p>wr_14 = '$wr_14',</p><p>wr_15 = '$wr_15', </p><p><span style="font-size: 11pt; line-height: 1.5;">";</span></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;">}</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;">
</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;">/*add_table 변수가 넘어온다면</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;">추가적인 sql구문을 변수에담고..</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;">하단 insert 문의 방해받지않는 위치에 넣어줍니다.</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;">맨끝에 넣지않은것은 쿼리의 종료구문때문입니다.</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;">뭐 위치야 상관없지요..</span></font></p><p><span style="color: rgb(72, 72, 72); font-family: 돋움, Dotum, sans-serif; font-size: 14px; line-height: 25.203125px;">*/</span></p><p><span style="color: rgb(72, 72, 72); font-family: 돋움, Dotum, sans-serif; font-size: 14px; line-height: 25.203125px;"> </span></p><p><span style="color: rgb(72, 72, 72); font-family: 돋움, Dotum, sans-serif; font-size: 14px; line-height: 25.203125px;"></span><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> $sql = " insert into $write_table</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> set wr_num = '$wr_num',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_reply = '$wr_reply',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_comment = 0,</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> ca_name = '$ca_name',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_option = '$html,$secret,$mail',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_subject = '$wr_subject',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_content = '$wr_content',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_link1 = '$wr_link1',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_link2 = '$wr_link2',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_link1_hit = 0,</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_link2_hit = 0,</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_hit = 0,</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_good = 0,</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_nogood = 0,</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> mb_id = '{$member['mb_id']}',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_password = '$wr_password',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_name = '$wr_name',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_email = '$wr_email',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_homepage = '$wr_homepage',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_datetime = '".G5_TIME_YMDHIS."',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_last = '".G5_TIME_YMDHIS."',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_ip = '{$_SERVER['REMOTE_ADDR']}',</span></font></p><p style="margin-left: 120px;"><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;">{</span></font><span style="font-size: 14.6666669845581px; line-height: 1.5;">$add_sql}</span><span style="font-size: 14px; line-height: 25.203125px; color: rgb(72, 72, 72); font-family: 돋움, Dotum, sans-serif;"></span></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_1 = '$wr_1',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_2 = '$wr_2',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_3 = '$wr_3',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_4 = '$wr_4',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_5 = '$wr_5',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_6 = '$wr_6',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_7 = '$wr_7',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_8 = '$wr_8',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_9 = '$wr_9',</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> wr_10 = '$wr_10' ";</span></font></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;"> sql_query($sql);</span></font></p><p><span style="color: rgb(72, 72, 72); font-family: 돋움, Dotum, sans-serif; font-size: 14px; line-height: 25.203125px;"> </span></p><p><span style="color: rgb(72, 72, 72); font-family: 돋움, Dotum, sans-serif; font-size: 14px; line-height: 25.203125px;">/*이렇게 하시면 원하시는 테이블만 insert시 추가 구문이 동작되게 가능합니다.</span></p><p><font color="#484848" face="돋움, Dotum, sans-serif"><span style="font-size: 14px; line-height: 25.203125px;">update 도 마찬가지 입니다.*/</span></font></p><p><span style="color: rgb(72, 72, 72); font-family: 돋움, Dotum, sans-serif; font-size: 14px; line-height: 25.203125px;">
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인