여분필드 내용이 DB에 저장이 안되요
본문
여분필드 wr_3 이후로 DB 내용이 저장이 안되고 wr_3은 wr_4~부터 적은게 랜덤으로wr_3에 적어지는데..
어디가 문제일까요??
bbs/write_update.php에는 아래와 비슷하게 2군데 넣었어요.
$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_seo_title = '$wr_seo_title',
wr_link1 = '$wr_link1',
wr_link2 = '$wr_link2',
wr_link1_hit = 0,
wr_link2_hit = 0,
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 = '".G5_TIME_YMDHIS."',
wr_last = '".G5_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',
wr_11 = '$wr_11',
wr_12 = '$wr_12',
wr_13 = '$wr_13',
wr_14 = '$wr_14',
wr_15 = '$wr_15',
wr_16 = '$wr_16',
wr_17 = '$wr_17',
wr_18 = '$wr_18',
wr_19 = '$wr_19',
wr_20 = '$wr_20',
wr_21 = '$wr_21',
wr_22 = '$wr_22',
wr_23 = '$wr_23',
wr_24 = '$wr_24',
wr_25 = '$wr_25',
wr_26 = '$wr_26',
wr_27 = '$wr_27',
wr_28 = '$wr_28',
wr_29 = '$wr_29',
wr_30 = '$wr_30' ";
sql_query($sql);
테마에 /skin/board/게시판/write_update.skin.php 에는 아래와 같이 추가했습니다.
<?php
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
$sql = " update $write_table
set wr_11 = '$wr_11',
wr_12 = '$wr_12',
wr_13 = '$wr_13',
wr_14 = '$wr_14',
wr_15 = '$wr_15',
wr_16 = '$wr_16',
wr_17 = '$wr_17',
wr_18 = '$wr_18',
wr_19 = '$wr_19',
wr_20 = '$wr_20',
wr_21 = '$wr_21',
wr_22 = '$wr_22',
wr_23 = '$wr_23',
wr_24 = '$wr_24',
wr_25 = '$wr_25',
wr_26 = '$wr_26',
wr_27 = '$wr_27',
wr_28 = '$wr_28',
wr_29 = '$wr_29',
wr_30 = '$wr_30'
where wr_id = '$wr_id' ";
sql_query($sql);
?>
답변 1
var_dump($_POST);
echo $sql;
exit;
해서 실제 들어오는 값과 쿼리에 무슨 값이 찍히는지 체크해 보셔야 할듯 합니다.
write_update.skin.php에 넣었더니 이렇게 뜹니다.
array(19) { ["token"]=> string(32) "98b46a9dd9b4b1acec5011e064b9094d" ["uid"]=> string(16) "2023091915165303" ["w"]=> string(1) "u" ["bo_table"]=> string(7) "evboard" ["wr_id"]=> string(1) "4" ["sca"]=> string(0) "" ["sfl"]=> string(0) "" ["stx"]=> string(0) "" ["spt"]=> string(0) "" ["sst"]=> string(0) "" ["sod"]=> string(0) "" ["page"]=> string(1) "0" ["wr_subject"]=> string(12) "테스트중" ["wr_1"]=> string(9) "테스트" ["wr_2"]=> string(9) "테스트" ["wr_3"]=> string(1) "7" ["wr_content"]=> string(18) "테스트테스트" ["wr_link1"]=> string(0) "" ["wr_link2"]=> string(0) "" } insert into Godo_g5_board_file set bo_table = 'evboard', wr_id = '4', bf_no = '1', bf_source = '', bf_file = '', bf_content = '', bf_fileurl = '', bf_thumburl = '', bf_storage = '', bf_download = 0, bf_filesize = '0', bf_width = '', bf_height = '', bf_type = '', bf_datetime = '2023-09-19 15:17:00'
