보듬이님 정보
보듬이님첨부파일
본문
보듬이님 부탁드립니다.
댓글 전체
여기다가 올리셨군요 저다운받았으니 삭제해도됩니당
해당 게시판 테이블에 wr_111필드 추가해주시구요
해당 게시판 테이블에 wr_111필드 추가해주시구요
감사합니다.
소스보니까 피씨방상호의 name=wr_8 인데 $write[wr_111]이 값으로 되있네요
그냥 $write[wr_8]로 수정해서 쓰셔두 될듯 wr_11부터는 필드가 없어서 디비테이블에 직접 필드추가하셔야합니다
//wr_111을 써야할때
write.skin.php
<!-- 추가필드8 시작-->
<tr>
<td height="30" align="center">PC방 상호 </td>
<td ><input type='text' class=ed size=20 name='wr_111' itemname="PC방 상호" required value='<?=$write["wr_111"]?>' maxlength='20' style='text-align:left;'></td>
</tr>
<tr><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
<!-- 추가필드8 끝-->
write_update.php
$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',
wr_111= '$wr_111'";
$sql = " update $write_table
set 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',
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',
wr_111= '$wr_111'
$sql_ip
$sql_password
where wr_id = '$wr[wr_id]' ";
그냥 $write[wr_8]로 수정해서 쓰셔두 될듯 wr_11부터는 필드가 없어서 디비테이블에 직접 필드추가하셔야합니다
//wr_111을 써야할때
write.skin.php
<!-- 추가필드8 시작-->
<tr>
<td height="30" align="center">PC방 상호 </td>
<td ><input type='text' class=ed size=20 name='wr_111' itemname="PC방 상호" required value='<?=$write["wr_111"]?>' maxlength='20' style='text-align:left;'></td>
</tr>
<tr><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
<!-- 추가필드8 끝-->
write_update.php
$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',
wr_111= '$wr_111'";
$sql = " update $write_table
set 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',
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',
wr_111= '$wr_111'
$sql_ip
$sql_password
where wr_id = '$wr[wr_id]' ";
제가 항목 30가지 넣을려고 하거든요
그래서 wr_100~wr_130 까지 넣을려고하는데 에러가 자꾸나요
insert into g4_write_report set wr_num = '-6', wr_reply = '', wr_comment = 0, ca_name = '', wr_option = ',,', wr_subject = '2', wr_content = '2', wr_link1 = '', wr_link2 = '', wr_link1_hit = 0, wr_link2_hit = 0, wr_trackback = '', wr_hit = 0, wr_good = 0, wr_nogood = 0, mb_id = 'ryu', wr_password = '0dc409173935f806', wr_name = '삼성ICT', wr_email = '*** 개인정보보호를 위한 이메일주소 노출방지 ***', wr_homepage = '', wr_datetime = '2007-10-17 11:48:39', wr_last = '2007-10-17 11:48:39', wr_ip = '59.23.140.16', wr_1 = '', wr_2 = '', wr_3 = '2', wr_4 = '2', wr_5 = '', wr_6 = '', wr_7 = '', wr_8 = '1111111', wr_9 = '', wr_111 = '', wr_10 = ''
1054 : Unknown column 'wr_111' in 'field list'
error file : /bbs/write_update.php
그래서 wr_100~wr_130 까지 넣을려고하는데 에러가 자꾸나요
insert into g4_write_report set wr_num = '-6', wr_reply = '', wr_comment = 0, ca_name = '', wr_option = ',,', wr_subject = '2', wr_content = '2', wr_link1 = '', wr_link2 = '', wr_link1_hit = 0, wr_link2_hit = 0, wr_trackback = '', wr_hit = 0, wr_good = 0, wr_nogood = 0, mb_id = 'ryu', wr_password = '0dc409173935f806', wr_name = '삼성ICT', wr_email = '*** 개인정보보호를 위한 이메일주소 노출방지 ***', wr_homepage = '', wr_datetime = '2007-10-17 11:48:39', wr_last = '2007-10-17 11:48:39', wr_ip = '59.23.140.16', wr_1 = '', wr_2 = '', wr_3 = '2', wr_4 = '2', wr_5 = '', wr_6 = '', wr_7 = '', wr_8 = '1111111', wr_9 = '', wr_111 = '', wr_10 = ''
1054 : Unknown column 'wr_111' in 'field list'
error file : /bbs/write_update.php
1054 : Unknown column 'wr_111' in 'field list'
디비테이블에 wr_111을 추가해주세요 기본이 wr_1 에서 10까지만있습니다
ALTER TABLE `g4_write_게시판아이디` ADD `wr_111` VARCHAR( 255 ) NOT NULL 를 mysql에서 실행해주세욧
디비테이블에 wr_111을 추가해주세요 기본이 wr_1 에서 10까지만있습니다
ALTER TABLE `g4_write_게시판아이디` ADD `wr_111` VARCHAR( 255 ) NOT NULL 를 mysql에서 실행해주세욧
제가 똑같이 했는데요. 그래도 이런 에러가 뜨네요.
insert into g4_write_report set wr_num = '-6', wr_reply = '', wr_comment = 0, ca_name = '', wr_option = ',,', wr_subject = 'a', wr_content = 'a', wr_link1 = '', wr_link2 = '', wr_link1_hit = 0, wr_link2_hit = 0, wr_trackback = '', wr_hit = 0, wr_good = 0, wr_nogood = 0, mb_id = 'ryu', wr_password = '0dc409173935f806', wr_name = '삼성ICT', wr_email = '*** 개인정보보호를 위한 이메일주소 노출방지 ***', wr_homepage = '', wr_datetime = '2007-10-17 12:01:01', wr_last = '2007-10-17 12:01:01', wr_ip = '59.23.140.16', wr_1 = '', wr_2 = '', wr_3 = 'a', wr_4 = 'a', wr_5 = '', wr_6 = '', wr_7 = '', wr_8 = '', wr_9 = '', wr_10 = '', wr_11 = '1111'
1054 : Unknown column 'wr_11' in 'field list'
error file : /bbs/write_update.php
insert into g4_write_report set wr_num = '-6', wr_reply = '', wr_comment = 0, ca_name = '', wr_option = ',,', wr_subject = 'a', wr_content = 'a', wr_link1 = '', wr_link2 = '', wr_link1_hit = 0, wr_link2_hit = 0, wr_trackback = '', wr_hit = 0, wr_good = 0, wr_nogood = 0, mb_id = 'ryu', wr_password = '0dc409173935f806', wr_name = '삼성ICT', wr_email = '*** 개인정보보호를 위한 이메일주소 노출방지 ***', wr_homepage = '', wr_datetime = '2007-10-17 12:01:01', wr_last = '2007-10-17 12:01:01', wr_ip = '59.23.140.16', wr_1 = '', wr_2 = '', wr_3 = 'a', wr_4 = 'a', wr_5 = '', wr_6 = '', wr_7 = '', wr_8 = '', wr_9 = '', wr_10 = '', wr_11 = '1111'
1054 : Unknown column 'wr_11' in 'field list'
error file : /bbs/write_update.php
추가한필드가 wr_11이면
ALTER TABLE g4_write_report ADD `wr_11` VARCHAR( 255 ) NOT NULL 를 mysql에서 실행해주세욧
디비의 게시판테이블에 필드가 추가되지않으면 저 에러가 계속 납니다
//게시판 테이블에 필드추가하기
<?
include_once("./_common.php");
//간단쿼리실행입니다
//다른필드도 추가하고싶으시면 wr_11부분을 추가하고픈 필드명으로 교체하시면 됩니다
sql_query("ALTER TABLE g4_write_report ADD wr_11 VARCHAR( 255 ) NOT NULL");
?>
이소스를 field_add.php로 write_update.php 와 같은경로로 저장해서 실행하십시요
ALTER TABLE g4_write_report ADD `wr_11` VARCHAR( 255 ) NOT NULL 를 mysql에서 실행해주세욧
디비의 게시판테이블에 필드가 추가되지않으면 저 에러가 계속 납니다
//게시판 테이블에 필드추가하기
<?
include_once("./_common.php");
//간단쿼리실행입니다
//다른필드도 추가하고싶으시면 wr_11부분을 추가하고픈 필드명으로 교체하시면 됩니다
sql_query("ALTER TABLE g4_write_report ADD wr_11 VARCHAR( 255 ) NOT NULL");
?>
이소스를 field_add.php로 write_update.php 와 같은경로로 저장해서 실행하십시요
보듬님 감사합니다. 필드추가 PHP의 기초부터 차근차근 공부 해야겠네요.
감사합니다.
감사합니다.