웹씨커뮤니티님의 여분필드 갯수상관없이 업데이트 인서트하기가 잘 안됩니다 ㅠ.ㅠ 정보
웹씨커뮤니티님의 여분필드 갯수상관없이 업데이트 인서트하기가 잘 안됩니다 ㅠ.ㅠ본문
오류가 나는곳의 주소를 알려주시면 더 빠르고 정확하게 답변 받을 수 있습니다.
오류 주소 : 로컬
http://www.sir.co.kr/bbs/tb.php/g4_tiptech/11180/62da32b3f8b88f3abede92e3da17d8ac
위팁대로 했습니다.
수정전
$sql = " insert into $write_table
set wr_num = '$wr_num',
wr_reply = '$wr_reply',
wr_comment = 0,
ca_name = '$ca_name',
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_query($sql);
수정후
foreach ($_POST as $key => $value) :
for ($j=1; $j<=sizeof($_POST); $j++) :
if ($key == "wr_$j") $sql_content_spare .= " wr_$j = '$value', ";
endfor;
endforeach;
$sql = " insert into $write_table
set wr_num = '$wr_num',
wr_reply = '$wr_reply',
wr_comment = 0,
ca_name = '$ca_name',
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]',
$sql_content_spare' ";
이렇게 하는게 맞나요?
어떻게 하는거죠 ㅠ.ㅠ
오류 주소 : 로컬
http://www.sir.co.kr/bbs/tb.php/g4_tiptech/11180/62da32b3f8b88f3abede92e3da17d8ac
위팁대로 했습니다.
수정전
$sql = " insert into $write_table
set wr_num = '$wr_num',
wr_reply = '$wr_reply',
wr_comment = 0,
ca_name = '$ca_name',
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_query($sql);
수정후
foreach ($_POST as $key => $value) :
for ($j=1; $j<=sizeof($_POST); $j++) :
if ($key == "wr_$j") $sql_content_spare .= " wr_$j = '$value', ";
endfor;
endforeach;
$sql = " insert into $write_table
set wr_num = '$wr_num',
wr_reply = '$wr_reply',
wr_comment = 0,
ca_name = '$ca_name',
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]',
$sql_content_spare' ";
이렇게 하는게 맞나요?
어떻게 하는거죠 ㅠ.ㅠ
댓글 전체
아 해결한듯합니다.
$sql_content_spare
wr_ip = '$_SERVER[REMOTE_ADDR]'";
이렇게 하니 잘 됩니다 ^^
감사합니다.
$sql_content_spare
wr_ip = '$_SERVER[REMOTE_ADDR]'";
이렇게 하니 잘 됩니다 ^^
감사합니다.
해결 못했습니다 ㅠ.ㅠ 수정부분은 어찌 또 넣어야 하는지 으엉ㅇㅇ
수정할때 IP 필요 없으면은 updata에서 wr_ip 부분 제외 하면 되지 않나요?
감사합니다 해결하였습니다 ^,^