게시판의 필드를 웹에서 추가시킬려고 하는데... 정보
그누보드 게시판의 필드를 웹에서 추가시킬려고 하는데...
본문
http://sir.co.kr/?doc=bbs/gnuboard.php&bo_table=tiptech&sselect=wr_subject&stext=%C7%CA%B5%E5%C3%DF%B0%A1&soperator=1&page=1&wr_id=5418&ca_id=
위 글을 참고해서 웹에서 aaa라는 게시판에 아래의 필드를 추가할려고 합니다.
이렇게 하는게 맞는가요?
----------------필드 추가----------------
`wr_file3` varchar(255) NOT NULL default '',
`wr_file4` varchar(255) NOT NULL default '',
`wr_file5` varchar(255) NOT NULL default '',
`wr_file6` varchar(255) NOT NULL default '',
`wr_file7` varchar(255) NOT NULL default '',
`wr_file8` varchar(255) NOT NULL default '',
`wr_file9` varchar(255) NOT NULL default '',
`wr_file10` varchar(255) NOT NULL default '',
`wr_file11` varchar(255) NOT NULL default '',
`wr_file12` varchar(255) NOT NULL default '',
`wr_file13` varchar(255) NOT NULL default '',
`wr_file3_source` varchar(255) NOT NULL default '',
`wr_file4_source` varchar(255) NOT NULL default '',
`wr_file5_source` varchar(255) NOT NULL default '',
`wr_file6_source` varchar(255) NOT NULL default '',
`wr_file7_source` varchar(255) NOT NULL default '',
`wr_file8_source` varchar(255) NOT NULL default '',
`wr_file9_source` varchar(255) NOT NULL default '',
`wr_file10_source` varchar(255) NOT NULL default '',
`wr_file11_source` varchar(255) NOT NULL default '',
`wr_file12_source` varchar(255) NOT NULL default '',
`wr_file13_source` varchar(255) NOT NULL default '',
`wr_file3_download` int(11) NOT NULL default '0',
`wr_file4_download` int(11) NOT NULL default '0',
`wr_file5_download` int(11) NOT NULL default '0',
`wr_file6_download` int(11) NOT NULL default '0',
`wr_file7_download` int(11) NOT NULL default '0',
`wr_file8_download` int(11) NOT NULL default '0',
`wr_file9_download` int(11) NOT NULL default '0',
`wr_file10_download` int(11) NOT NULL default '0',
`wr_file11_download` int(11) NOT NULL default '0',
`wr_file12_download` int(11) NOT NULL default '0',
`wr_file13_download` int(11) NOT NULL default '0',
`subject1` varchar(255) NOT NULL default '',
`subject2` varchar(255) NOT NULL default '',
`subject3` varchar(255) NOT NULL default '',
`subject4` varchar(255) NOT NULL default '',
`subject5` varchar(255) NOT NULL default '',
`subject6` varchar(255) NOT NULL default '',
`subject7` varchar(255) NOT NULL default '',
`subject8` varchar(255) NOT NULL default '',
`subject9` varchar(255) NOT NULL default '',
`subject10` varchar(255) NOT NULL default '',
---------------필드추가내용 끝------------------
아래와 같이 add.php 파일로 저장해서 웹에서 실행시키면 될까요? 잘못 입력한 내용이 없는지..
까막눈이라.. -,.-;;
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
define("_DOCTYPE_", "STYLE");
//추가 필드 설치
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file3 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file4 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file5 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file6 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file7 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file8 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file9 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file10 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file11 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file12 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file13 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file3_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file4_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file5_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file6_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file7_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file8_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file9_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file10_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file11_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file12_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file13_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file3_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file4_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file5_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file6_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file7_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file8_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file9_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file10_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file11_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file12_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file13_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject1 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject2 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject3 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject4 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject5 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject6 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject7 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject8 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject9 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject10 varchar(255) not null default";
$result1 = @mysql_query($gb_wirte_aaa) or mysql_error();
echo "테이블안에 필드를 추가하였습니다..^^"
?>
위 글을 참고해서 웹에서 aaa라는 게시판에 아래의 필드를 추가할려고 합니다.
이렇게 하는게 맞는가요?
----------------필드 추가----------------
`wr_file3` varchar(255) NOT NULL default '',
`wr_file4` varchar(255) NOT NULL default '',
`wr_file5` varchar(255) NOT NULL default '',
`wr_file6` varchar(255) NOT NULL default '',
`wr_file7` varchar(255) NOT NULL default '',
`wr_file8` varchar(255) NOT NULL default '',
`wr_file9` varchar(255) NOT NULL default '',
`wr_file10` varchar(255) NOT NULL default '',
`wr_file11` varchar(255) NOT NULL default '',
`wr_file12` varchar(255) NOT NULL default '',
`wr_file13` varchar(255) NOT NULL default '',
`wr_file3_source` varchar(255) NOT NULL default '',
`wr_file4_source` varchar(255) NOT NULL default '',
`wr_file5_source` varchar(255) NOT NULL default '',
`wr_file6_source` varchar(255) NOT NULL default '',
`wr_file7_source` varchar(255) NOT NULL default '',
`wr_file8_source` varchar(255) NOT NULL default '',
`wr_file9_source` varchar(255) NOT NULL default '',
`wr_file10_source` varchar(255) NOT NULL default '',
`wr_file11_source` varchar(255) NOT NULL default '',
`wr_file12_source` varchar(255) NOT NULL default '',
`wr_file13_source` varchar(255) NOT NULL default '',
`wr_file3_download` int(11) NOT NULL default '0',
`wr_file4_download` int(11) NOT NULL default '0',
`wr_file5_download` int(11) NOT NULL default '0',
`wr_file6_download` int(11) NOT NULL default '0',
`wr_file7_download` int(11) NOT NULL default '0',
`wr_file8_download` int(11) NOT NULL default '0',
`wr_file9_download` int(11) NOT NULL default '0',
`wr_file10_download` int(11) NOT NULL default '0',
`wr_file11_download` int(11) NOT NULL default '0',
`wr_file12_download` int(11) NOT NULL default '0',
`wr_file13_download` int(11) NOT NULL default '0',
`subject1` varchar(255) NOT NULL default '',
`subject2` varchar(255) NOT NULL default '',
`subject3` varchar(255) NOT NULL default '',
`subject4` varchar(255) NOT NULL default '',
`subject5` varchar(255) NOT NULL default '',
`subject6` varchar(255) NOT NULL default '',
`subject7` varchar(255) NOT NULL default '',
`subject8` varchar(255) NOT NULL default '',
`subject9` varchar(255) NOT NULL default '',
`subject10` varchar(255) NOT NULL default '',
---------------필드추가내용 끝------------------
아래와 같이 add.php 파일로 저장해서 웹에서 실행시키면 될까요? 잘못 입력한 내용이 없는지..
까막눈이라.. -,.-;;
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
define("_DOCTYPE_", "STYLE");
//추가 필드 설치
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file3 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file4 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file5 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file6 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file7 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file8 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file9 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file10 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file11 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file12 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file13 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file3_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file4_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file5_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file6_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file7_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file8_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file9_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file10_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file11_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file12_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file13_source varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file3_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file4_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file5_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file6_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file7_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file8_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file9_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file10_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file11_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file12_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add wr_file13_download int(11) not null default '0'";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject1 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject2 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject3 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject4 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject5 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject6 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject7 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject8 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject9 varchar(255) not null default";
$gb_write_aaa ="alter TABLE gb_write_aaa add subject10 varchar(255) not null default";
$result1 = @mysql_query($gb_wirte_aaa) or mysql_error();
echo "테이블안에 필드를 추가하였습니다..^^"
?>
댓글 전체
^^;; 고맙습니다.
힘들게 하시는군요...ㅡㅡ;
아래를 그대로 복사해서 붙여넣기 해서 사용하십시오.
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
define("_DOCTYPE_", "STYLE");
for($f=3;$f<14;$f++){
sql_query(" alter table gb_write_aaa add wr_file$f varchar(255) not null ");
}
for($s=3;$s<14;$s++){
sql_query(" alter table gb_write_aaa add wr_file{$s}_source varchar(255) not null ");
}
for($d=3;$d<14;$d++){
sql_query(" alter table gb_write_aaa add wr_file{$d}_download int(11) not null default '0' ");
}
for($b=1;$b<11;$b++){
sql_query(" alter table gb_write_aaa add subject$b varchar(255) not null ");
}
echo " 필드추가 완료";
?>
아래를 그대로 복사해서 붙여넣기 해서 사용하십시오.
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
define("_DOCTYPE_", "STYLE");
for($f=3;$f<14;$f++){
sql_query(" alter table gb_write_aaa add wr_file$f varchar(255) not null ");
}
for($s=3;$s<14;$s++){
sql_query(" alter table gb_write_aaa add wr_file{$s}_source varchar(255) not null ");
}
for($d=3;$d<14;$d++){
sql_query(" alter table gb_write_aaa add wr_file{$d}_download int(11) not null default '0' ");
}
for($b=1;$b<11;$b++){
sql_query(" alter table gb_write_aaa add subject$b varchar(255) not null ");
}
echo " 필드추가 완료";
?>
