write_update.skin에 쿼리를 추가하려고합니다. 정보
write_update.skin에 쿼리를 추가하려고합니다.
본문
제가 ca_name2~4 까지 필드를 추가하면서
bbs/wirte_update.php 의 쿼리를 추가해 줬습니다.
추가 항목은요
$sql = " insert into $write_table
set wr_num = '$wr_num',
wr_reply = '$wr_reply',
wr_comment = 0,
ca_name = '$ca_name',
ca_name2_1 = '$ca_name2_1',
ca_name2_2 = '$ca_name2_2',
ca_name2_3 = '$ca_name2_3',
ca_name2_4 = '$ca_name2_4',
wr_option = '$html,$secret,$mail',
wr_subject = '$wr_subject',
wr_content = '$wr_content',
wr_link1 = '$wr_link1',
wr_link2 = '$wr_link2',
wr_link1_hit = 0,
wr_link2_hit = 0,
wr_trackback = '$wr_trackback',
wr_hit = 0,
wr_good = 0,
wr_nogood = 0,
mb_id = '$member[mb_id]',
wr_password = '$wr_password',
wr_name = '$wr_name',
wr_email = '$wr_email',
wr_homepage = '$wr_homepage',
wr_datetime = '$g4[time_ymdhis]',
wr_last = '$g4[time_ymdhis]',
wr_ip = '$_SERVER[REMOTE_ADDR]',
wr_1 = '$wr_1',
wr_2 = '$wr_2',
wr_3 = '$wr_3',
wr_4 = '$wr_4',
wr_5 = '$wr_5',
wr_6 = '$wr_6',
wr_7 = '$wr_7',
wr_8 = '$wr_8',
wr_9 = '$wr_9',
wr_10 = '$wr_10'";
$sql = " update $write_table
set ca_name = '$ca_name',
ca_name2_1 = '$ca_name2_1',
ca_name2_2 = '$ca_name2_2',
ca_name2_3 = '$ca_name2_3',
ca_name2_4 = '$ca_name2_4',
wr_option = '$html,$secret,$mail',
wr_subject = '$wr_subject',
wr_content = '$wr_content',
wr_link1 = '$wr_link1',
wr_link2 = '$wr_link2',
mb_id = '$mb_id',
wr_name = '$wr_name',
wr_email = '$wr_email',
wr_homepage = '$wr_homepage',
wr_1 = '$wr_1',
wr_2 = '$wr_2',
wr_3 = '$wr_3',
wr_4 = '$wr_4',
wr_5 = '$wr_5',
wr_6 = '$wr_6',
wr_7 = '$wr_7',
wr_8 = '$wr_8',
wr_9 = '$wr_9',
wr_10= '$wr_10'
$sql_ip
$sql_password
where wr_id = '$wr[wr_id]' ";
sql_query($sql);
-----------------------------------------------------------------------------------------
$sql = " update $write_table
set ca_name = '$ca_name',
ca_name2_1 = '$ca_name2_1',
ca_name2_2 = '$ca_name2_2',
ca_name2_3 = '$ca_name2_3',
ca_name2_4 = '$ca_name2_4',
wr_option = '$html,$secret,$mail',
wr_subject = '$wr_subject',
wr_content = '$wr_content',
wr_link1 = '$wr_link1',
wr_link2 = '$wr_link2',
mb_id = '$mb_id',
wr_name = '$wr_name',
wr_email = '$wr_email',
wr_homepage = '$wr_homepage',
wr_1 = '$wr_1',
wr_2 = '$wr_2',
wr_3 = '$wr_3',
wr_4 = '$wr_4',
wr_5 = '$wr_5',
wr_6 = '$wr_6',
wr_7 = '$wr_7',
wr_8 = '$wr_8',
wr_9 = '$wr_9',
wr_10= '$wr_10'
$sql_ip
$sql_password
where wr_id = '$wr[wr_id]' ";
sql_query($sql);
// 분류가 수정되는 경우 해당되는 코멘트의 분류명도 모두 수정함
// 코멘트의 분류를 수정하지 않으면 검색이 제대로 되지 않음
$sql = " update $write_table set ca_name = '$ca_name' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
$sql = " update $write_table set ca_name2_1 = '$ca_name2_1' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
$sql = " update $write_table set ca_name2_2 = '$ca_name2_2' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
$sql = " update $write_table set ca_name2_3 = '$ca_name2_3' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
$sql = " update $write_table set ca_name2_4 = '$ca_name2_4' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
이 두 부분입니다.
ca_name2_1,ca_name2_2,ca_name2_3,ca_name2_4
이 네개에 관한것만 추가한거에요..
그런데 이것을 해당 스킨의 write_update.skin.php 로 옮기고 싶은데
<?
$sql = " insert into $write_table
set ca_name2_1 = '$ca_name2_1',
ca_name2_2 = '$ca_name2_2',
ca_name2_3 = '$ca_name2_3',
ca_name2_4 = '$ca_name2_4' ";
sql_query($sql);
?>
<?
$sql = " update $write_table
set ca_name2_1 = '$ca_name2_1',
ca_name2_2 = '$ca_name2_2',
ca_name2_3 = '$ca_name2_3',
ca_name2_4 = '$ca_name2_4',
where wr_id = '$wr[wr_id]' ";
sql_query($sql);
?>
<?
$sql = " update $write_table set ca_name2_1 = '$ca_name2_1' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
$sql = " update $write_table set ca_name2_2 = '$ca_name2_2' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
$sql = " update $write_table set ca_name2_3 = '$ca_name2_3' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
$sql = " update $write_table set ca_name2_4 = '$ca_name2_4' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
?>
이런식으로 삽입하니 먹통이 되는군요...
누가 조언좀 부탁드립니다.
bbs/wirte_update.php 의 쿼리를 추가해 줬습니다.
추가 항목은요
$sql = " insert into $write_table
set wr_num = '$wr_num',
wr_reply = '$wr_reply',
wr_comment = 0,
ca_name = '$ca_name',
ca_name2_1 = '$ca_name2_1',
ca_name2_2 = '$ca_name2_2',
ca_name2_3 = '$ca_name2_3',
ca_name2_4 = '$ca_name2_4',
wr_option = '$html,$secret,$mail',
wr_subject = '$wr_subject',
wr_content = '$wr_content',
wr_link1 = '$wr_link1',
wr_link2 = '$wr_link2',
wr_link1_hit = 0,
wr_link2_hit = 0,
wr_trackback = '$wr_trackback',
wr_hit = 0,
wr_good = 0,
wr_nogood = 0,
mb_id = '$member[mb_id]',
wr_password = '$wr_password',
wr_name = '$wr_name',
wr_email = '$wr_email',
wr_homepage = '$wr_homepage',
wr_datetime = '$g4[time_ymdhis]',
wr_last = '$g4[time_ymdhis]',
wr_ip = '$_SERVER[REMOTE_ADDR]',
wr_1 = '$wr_1',
wr_2 = '$wr_2',
wr_3 = '$wr_3',
wr_4 = '$wr_4',
wr_5 = '$wr_5',
wr_6 = '$wr_6',
wr_7 = '$wr_7',
wr_8 = '$wr_8',
wr_9 = '$wr_9',
wr_10 = '$wr_10'";
$sql = " update $write_table
set ca_name = '$ca_name',
ca_name2_1 = '$ca_name2_1',
ca_name2_2 = '$ca_name2_2',
ca_name2_3 = '$ca_name2_3',
ca_name2_4 = '$ca_name2_4',
wr_option = '$html,$secret,$mail',
wr_subject = '$wr_subject',
wr_content = '$wr_content',
wr_link1 = '$wr_link1',
wr_link2 = '$wr_link2',
mb_id = '$mb_id',
wr_name = '$wr_name',
wr_email = '$wr_email',
wr_homepage = '$wr_homepage',
wr_1 = '$wr_1',
wr_2 = '$wr_2',
wr_3 = '$wr_3',
wr_4 = '$wr_4',
wr_5 = '$wr_5',
wr_6 = '$wr_6',
wr_7 = '$wr_7',
wr_8 = '$wr_8',
wr_9 = '$wr_9',
wr_10= '$wr_10'
$sql_ip
$sql_password
where wr_id = '$wr[wr_id]' ";
sql_query($sql);
-----------------------------------------------------------------------------------------
$sql = " update $write_table
set ca_name = '$ca_name',
ca_name2_1 = '$ca_name2_1',
ca_name2_2 = '$ca_name2_2',
ca_name2_3 = '$ca_name2_3',
ca_name2_4 = '$ca_name2_4',
wr_option = '$html,$secret,$mail',
wr_subject = '$wr_subject',
wr_content = '$wr_content',
wr_link1 = '$wr_link1',
wr_link2 = '$wr_link2',
mb_id = '$mb_id',
wr_name = '$wr_name',
wr_email = '$wr_email',
wr_homepage = '$wr_homepage',
wr_1 = '$wr_1',
wr_2 = '$wr_2',
wr_3 = '$wr_3',
wr_4 = '$wr_4',
wr_5 = '$wr_5',
wr_6 = '$wr_6',
wr_7 = '$wr_7',
wr_8 = '$wr_8',
wr_9 = '$wr_9',
wr_10= '$wr_10'
$sql_ip
$sql_password
where wr_id = '$wr[wr_id]' ";
sql_query($sql);
// 분류가 수정되는 경우 해당되는 코멘트의 분류명도 모두 수정함
// 코멘트의 분류를 수정하지 않으면 검색이 제대로 되지 않음
$sql = " update $write_table set ca_name = '$ca_name' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
$sql = " update $write_table set ca_name2_1 = '$ca_name2_1' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
$sql = " update $write_table set ca_name2_2 = '$ca_name2_2' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
$sql = " update $write_table set ca_name2_3 = '$ca_name2_3' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
$sql = " update $write_table set ca_name2_4 = '$ca_name2_4' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
이 두 부분입니다.
ca_name2_1,ca_name2_2,ca_name2_3,ca_name2_4
이 네개에 관한것만 추가한거에요..
그런데 이것을 해당 스킨의 write_update.skin.php 로 옮기고 싶은데
<?
$sql = " insert into $write_table
set ca_name2_1 = '$ca_name2_1',
ca_name2_2 = '$ca_name2_2',
ca_name2_3 = '$ca_name2_3',
ca_name2_4 = '$ca_name2_4' ";
sql_query($sql);
?>
<?
$sql = " update $write_table
set ca_name2_1 = '$ca_name2_1',
ca_name2_2 = '$ca_name2_2',
ca_name2_3 = '$ca_name2_3',
ca_name2_4 = '$ca_name2_4',
where wr_id = '$wr[wr_id]' ";
sql_query($sql);
?>
<?
$sql = " update $write_table set ca_name2_1 = '$ca_name2_1' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
$sql = " update $write_table set ca_name2_2 = '$ca_name2_2' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
$sql = " update $write_table set ca_name2_3 = '$ca_name2_3' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
$sql = " update $write_table set ca_name2_4 = '$ca_name2_4' where wr_parent = '$wr[wr_id]' ";
sql_query($sql);
?>
이런식으로 삽입하니 먹통이 되는군요...
누가 조언좀 부탁드립니다.
댓글 전체

업데이트에서 저장을 하니 여분필드의 값만 추가적으로 저장을 해주면 되요.
<?
// 게시물 업데이트
$sql = " update $write_table set ca_name2_1 = '".$_POST['ca_name2_1']."', ca_name2_2 = '".$_POST['ca_name2_2']."', ca_name2_3 = '".$_POST['ca_name2_3']."', ca_name2_4 = '".$_POST['ca_name2_4']."' where wr_id = '$wr_id' ";
sql_query($sql);
?>
<?
// 게시물 업데이트
$sql = " update $write_table set ca_name2_1 = '".$_POST['ca_name2_1']."', ca_name2_2 = '".$_POST['ca_name2_2']."', ca_name2_3 = '".$_POST['ca_name2_3']."', ca_name2_4 = '".$_POST['ca_name2_4']."' where wr_id = '$wr_id' ";
sql_query($sql);
?>

알려주신 방법으로도 안되더라구요...ㅠ
무튼 답변 감사합니다.
무튼 답변 감사합니다.

죄송해요...다시해보니깐 되네요!! 감사합니다~ㅎㅎㅎ
그런데 죄송하지만 간략하게 어떤 차이가 있는건지 설명좀 해주실수 있나요??
그런데 죄송하지만 간략하게 어떤 차이가 있는건지 설명좀 해주실수 있나요??