복사하는데
본문
게시판 복사 코드를 작성하는데
$g5['board_table'] = "g5_write_aaa";
$aaa_columns = sql_field_names($g5['board_table']);
$g5['board_table'] = "g5_write_bbb";
$bbb_columns = sql_field_names($g5['board_table']);
를 print_r 해보니 아래처럼 잘나옵니다.
aaa
wr_1 [73] => wr_2 [74] => wr_3 [75] => wr_4 [76] => wr_5 [77] => wr_6 [78] => wr_7 [79] => wr_8 [80] => wr_9 [81] => wr_10 [82] => wr_11 [83] => wr_12 [84] => wr_13 [85] => wr_14 [86] => wr_15 [87] => wr_16 [88] => wr_17 [89] => wr_18 [90] => wr_19 [91] => wr_20 [92] => wr_21 [93] => wr_22 [94] => wr_23 [95] => wr_24 [96] => wr_25 [97] )
bbb
wr_1 [73] => wr_2 [74] => wr_3 [75] => wr_4 [76] => wr_5 [77] => wr_6 [78] => wr_7 [79] => wr_8 [80] => wr_9 [81] => wr_10 [82] => wr_11 [83] => wr_12 [84] => wr_13 [85] => wr_14 [86] => wr_15 [87] => wr_16 [88] => wr_17 [89] => wr_18 [90] => wr_19 [91] => wr_20 [92] => wr_21 [93] => wr_22 [94] => wr_23 [95] => wr_24 [96] => wr_25 [97] => wr_26 [98] => wr_27 [99] => wr_28 [100] => wr_29 [101] => wr_30 [102] => wr_31 [103] => wr_32 [104] => wr_33 [105] => wr_34 [106] => wr_35 [107] => wr_36 [108] => wr_37 [109] => wr_38 [110] => wr_39 [111] => wr_40 [112] => wr_41 [113] => wr_42 [114] => wr_43 [115] => wr_44 [116] => wr_45 )
이제
$sql = " insert into $move_write_table
set
$bbb_columns = '$aaa_columns',
wr_num = '$next_wr_num' ";
print_r($sql);
sql_query($sql);
$insert_id = sql_insert_id();
이렇게 하니
insert into g5_write_bbb set Array = 'Array', wr_num = '-36498'
이렇게만 나오고
$bbb_columns = '$aaa_columns', 이부분이 안나오는데
뭐가 잘못된걸까요?
답변 2
g4_import_run.php 파일에 아래 소스를 참조해서 만들어보세요..
// point table 복사
$sql = " select * from {$g4['point_table']} ";
$result = sql_query($sql);
for($i=0; $row=sql_fetch_array($result); $i++) {
if($is_euckr)
$row = array_map('iconv_utf8', $row);
$comma = '';
$sql = " insert into $move_write_table set ";
foreach($bbb_columns as $key=>$val) {
$sql .= " $key = '".addslashes($val)."', ";
}
$sql .= " wr_num = '$next_wr_num' ";
sql_query(" INSERT INTO {$g5['point_table']} SET $sql_common ");
}
감사합니다. 발전해서 마지막 정리 질문을 올렸습니다. ㅎㅎ