회원가입테이블에 필드추가후..
멤버스킨에 DB 추가후 추가 입력란을 만들었습니다.
입력정보가 DB에 저장까지 됩니다.
문제는 회원정보 수정하기 버튼을 눌렀을때..
기존 입력한 내용이 입력되어있지 않습니다.
다음은 제가 추가한 내용입니다.
rigister_form.skin.php
---------------------------------------------------------------------------------
<?
$car_info = explode("|",$write[mb_5]);
$info01 = $car_info[0];
$info02 = $car_info[1];
$info03 = $car_info[2];
$info04 = $car_info[3];
$info05 = $car_info[4];
$info06 = $car_info[5];
$info07 = $car_info[6];
$info08 = $car_info[7];
?>
<TR bgcolor="#FFFFFF">
<TD width="160" class=m_title>추가정보</TD>
<TD class=m_padding>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><td height="30">선택1 :
<select name=info01 itemname="선택1">
<option value="">===선택하세요===
<option value='1' <? if($info01 == 1) echo " selected "; ?>>1
<option value='2' <? if($info01 == 2) echo " selected "; ?>>2
<option value='3' <? if($info01 == 3) echo " selected "; ?>3
</select> 선택2 :
<select name=info02 itemname="선택2">
<option value="">선택
<option value='1' <? if($info02 == 1) echo " selected "; ?>>1
<option value='2' <? if($info02 == 2) echo " selected "; ?>>2
<option value='3' <? if($info02 == 3) echo " selected "; ?>>3
<option value='4' <? if($info02 == 4) echo " selected "; ?>>4
<option value='5' <? if($info02 == 5) echo " selected "; ?>>5
<option value='6' <? if($info02 == 6) echo " selected "; ?>>6
</select> 색상 :
<select name='info03' itemname="선택3">
<option value="">선택
<option value='1' <? if($info03 == 1) echo " selected "; ?>>1
<option value='2' <? if($info03 == 2) echo " selected "; ?>>2
<option value='3' <? if($info03 == 3) echo " selected "; ?>>3
<option value='4' <? if($info03 == 4) echo " selected "; ?>>4
<option value='5' <? if($info03 == 5) echo " selected "; ?>>5
<option value='6' <? if($info03 == 6) echo " selected "; ?>>6
<option value='7' <? if($info03 == 7) echo " selected "; ?>>7
<option value='8' <? if($info03 == 8) echo " selected "; ?>>8
</select>
</td></tr>
<tr>
<td height="30">선택4 :
<select name='info04' itemname="선택4">
<option value="">선택
<option value='1' <? if($info04 == 휘발유) echo " selected "; ?>>1
<option value='2' <? if($info04 == LPG) echo " selected "; ?>>2
<option value='3' <? if($info04 == 기타) echo " selected "; ?>>3
</select> 년도 :
<select name='info05' itemname="년">
<option value="">선택
<option value='2008' <? if($info05 == 2008) echo " selected "; ?>>2008
<option value='2007' <? if($info05 == 2007) echo " selected "; ?>>2007
<option value='2006' <? if($info05 == 2006) echo " selected "; ?>>2006
<option value='2005' <? if($info05 == 2005) echo " selected "; ?>>2005
<option value='2004' <? if($info05 == 2004) echo " selected "; ?>>2004
<option value='2003' <? if($info05 == 2003) echo " selected "; ?>>2003
<option value='2002' <? if($info05 == 2002) echo " selected "; ?>>2002
<option value='2001' <? if($info05 == 2001) echo " selected "; ?>>2001
<option value='2000' <? if($info05 == 2000) echo " selected "; ?>>2000
<option value='1999' <? if($info05 == 1999) echo " selected "; ?>>1999
<option value='1998' <? if($info05 == 1998) echo " selected "; ?>>1998
</select> 년
<select name='info06' itemname="월">
<option value="">선택
<option value='1' <? if($info06 == 1) echo " selected "; ?>>1
<option value='2' <? if($info06 == 2) echo " selected "; ?>>2
<option value='3' <? if($info06 == 3) echo " selected "; ?>>3
<option value='4' <? if($info06 == 4) echo " selected "; ?>>4
<option value='5' <? if($info06 == 5) echo " selected "; ?>>5
<option value='6' <? if($info06 == 6) echo " selected "; ?>>6
<option value='7' <? if($info06 == 7) echo " selected "; ?>>7
<option value='8' <? if($info06 == 8) echo " selected "; ?>>8
<option value='9' <? if($info06 == 9) echo " selected "; ?>>9
<option value='10' <? if($info06 == 10) echo " selected "; ?>>10
<option value='11' <? if($info06 == 11) echo " selected "; ?>>11
<option value='12' <? if($info06 == 12) echo " selected "; ?>>12
</select> 월
</td></tr>
<tr><td height="30">차량번호 :
<select name='info07' itemname="소재지역">
<option value="">선택
<option value='서울' <? if($info07 == 서울) echo " selected "; ?>>서울
<option value='부산' <? if($info07 == 부산) echo " selected "; ?>>부산
<option value='대구' <? if($info07 == 대구) echo " selected "; ?>>대구
<option value='인천' <? if($info07 == 인천) echo " selected "; ?>>인천
<option value='광주' <? if($info07 == 광주) echo " selected "; ?>>광주
<option value='대전' <? if($info07 == 대전) echo " selected "; ?>>대전
<option value='울산' <? if($info07 == 울산) echo " selected "; ?>>울산
<option value='강원' <? if($info07 == 강원) echo " selected "; ?>>강원
<option value='경기' <? if($info07 == 경기) echo " selected "; ?>>경기
<option value='경남' <? if($info07 == 경남) echo " selected "; ?>>경남
<option value='경북' <? if($info07 == 경북) echo " selected "; ?>>경북
<option value='전남' <? if($info07 == 전남) echo " selected "; ?>>전남
<option value='전북' <? if($info07 == 전북) echo " selected "; ?>>전북
<option value='제주' <? if($info07 == 제주) echo " selected "; ?>>제주
<option value='충남' <? if($info07 == 충남) echo " selected "; ?>>충남
<option value='충북' <? if($info07 == 충북) echo " selected "; ?>>충북
<option value='해외' <? if($info07 == 해외) echo " selected "; ?>>해외
</select>
<input class=m_text name='info08' value="<?=$info08?>" style=width:60 itemname="번호"> ex) 3079
</td></tr></table>
</TD>
</TR>
--------------------------------------------------------------------------------------------------
입니다.
수정하기 눌렀을때 기존 정보가 입력되어 있도록 하고 싶습니다.
어떻게 해야될까요
도움부탁드릴께요..
입력정보가 DB에 저장까지 됩니다.
문제는 회원정보 수정하기 버튼을 눌렀을때..
기존 입력한 내용이 입력되어있지 않습니다.
다음은 제가 추가한 내용입니다.
rigister_form.skin.php
---------------------------------------------------------------------------------
<?
$car_info = explode("|",$write[mb_5]);
$info01 = $car_info[0];
$info02 = $car_info[1];
$info03 = $car_info[2];
$info04 = $car_info[3];
$info05 = $car_info[4];
$info06 = $car_info[5];
$info07 = $car_info[6];
$info08 = $car_info[7];
?>
<TR bgcolor="#FFFFFF">
<TD width="160" class=m_title>추가정보</TD>
<TD class=m_padding>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><td height="30">선택1 :
<select name=info01 itemname="선택1">
<option value="">===선택하세요===
<option value='1' <? if($info01 == 1) echo " selected "; ?>>1
<option value='2' <? if($info01 == 2) echo " selected "; ?>>2
<option value='3' <? if($info01 == 3) echo " selected "; ?>3
</select> 선택2 :
<select name=info02 itemname="선택2">
<option value="">선택
<option value='1' <? if($info02 == 1) echo " selected "; ?>>1
<option value='2' <? if($info02 == 2) echo " selected "; ?>>2
<option value='3' <? if($info02 == 3) echo " selected "; ?>>3
<option value='4' <? if($info02 == 4) echo " selected "; ?>>4
<option value='5' <? if($info02 == 5) echo " selected "; ?>>5
<option value='6' <? if($info02 == 6) echo " selected "; ?>>6
</select> 색상 :
<select name='info03' itemname="선택3">
<option value="">선택
<option value='1' <? if($info03 == 1) echo " selected "; ?>>1
<option value='2' <? if($info03 == 2) echo " selected "; ?>>2
<option value='3' <? if($info03 == 3) echo " selected "; ?>>3
<option value='4' <? if($info03 == 4) echo " selected "; ?>>4
<option value='5' <? if($info03 == 5) echo " selected "; ?>>5
<option value='6' <? if($info03 == 6) echo " selected "; ?>>6
<option value='7' <? if($info03 == 7) echo " selected "; ?>>7
<option value='8' <? if($info03 == 8) echo " selected "; ?>>8
</select>
</td></tr>
<tr>
<td height="30">선택4 :
<select name='info04' itemname="선택4">
<option value="">선택
<option value='1' <? if($info04 == 휘발유) echo " selected "; ?>>1
<option value='2' <? if($info04 == LPG) echo " selected "; ?>>2
<option value='3' <? if($info04 == 기타) echo " selected "; ?>>3
</select> 년도 :
<select name='info05' itemname="년">
<option value="">선택
<option value='2008' <? if($info05 == 2008) echo " selected "; ?>>2008
<option value='2007' <? if($info05 == 2007) echo " selected "; ?>>2007
<option value='2006' <? if($info05 == 2006) echo " selected "; ?>>2006
<option value='2005' <? if($info05 == 2005) echo " selected "; ?>>2005
<option value='2004' <? if($info05 == 2004) echo " selected "; ?>>2004
<option value='2003' <? if($info05 == 2003) echo " selected "; ?>>2003
<option value='2002' <? if($info05 == 2002) echo " selected "; ?>>2002
<option value='2001' <? if($info05 == 2001) echo " selected "; ?>>2001
<option value='2000' <? if($info05 == 2000) echo " selected "; ?>>2000
<option value='1999' <? if($info05 == 1999) echo " selected "; ?>>1999
<option value='1998' <? if($info05 == 1998) echo " selected "; ?>>1998
</select> 년
<select name='info06' itemname="월">
<option value="">선택
<option value='1' <? if($info06 == 1) echo " selected "; ?>>1
<option value='2' <? if($info06 == 2) echo " selected "; ?>>2
<option value='3' <? if($info06 == 3) echo " selected "; ?>>3
<option value='4' <? if($info06 == 4) echo " selected "; ?>>4
<option value='5' <? if($info06 == 5) echo " selected "; ?>>5
<option value='6' <? if($info06 == 6) echo " selected "; ?>>6
<option value='7' <? if($info06 == 7) echo " selected "; ?>>7
<option value='8' <? if($info06 == 8) echo " selected "; ?>>8
<option value='9' <? if($info06 == 9) echo " selected "; ?>>9
<option value='10' <? if($info06 == 10) echo " selected "; ?>>10
<option value='11' <? if($info06 == 11) echo " selected "; ?>>11
<option value='12' <? if($info06 == 12) echo " selected "; ?>>12
</select> 월
</td></tr>
<tr><td height="30">차량번호 :
<select name='info07' itemname="소재지역">
<option value="">선택
<option value='서울' <? if($info07 == 서울) echo " selected "; ?>>서울
<option value='부산' <? if($info07 == 부산) echo " selected "; ?>>부산
<option value='대구' <? if($info07 == 대구) echo " selected "; ?>>대구
<option value='인천' <? if($info07 == 인천) echo " selected "; ?>>인천
<option value='광주' <? if($info07 == 광주) echo " selected "; ?>>광주
<option value='대전' <? if($info07 == 대전) echo " selected "; ?>>대전
<option value='울산' <? if($info07 == 울산) echo " selected "; ?>>울산
<option value='강원' <? if($info07 == 강원) echo " selected "; ?>>강원
<option value='경기' <? if($info07 == 경기) echo " selected "; ?>>경기
<option value='경남' <? if($info07 == 경남) echo " selected "; ?>>경남
<option value='경북' <? if($info07 == 경북) echo " selected "; ?>>경북
<option value='전남' <? if($info07 == 전남) echo " selected "; ?>>전남
<option value='전북' <? if($info07 == 전북) echo " selected "; ?>>전북
<option value='제주' <? if($info07 == 제주) echo " selected "; ?>>제주
<option value='충남' <? if($info07 == 충남) echo " selected "; ?>>충남
<option value='충북' <? if($info07 == 충북) echo " selected "; ?>>충북
<option value='해외' <? if($info07 == 해외) echo " selected "; ?>>해외
</select>
<input class=m_text name='info08' value="<?=$info08?>" style=width:60 itemname="번호"> ex) 3079
</td></tr></table>
</TD>
</TR>
--------------------------------------------------------------------------------------------------
입니다.
수정하기 눌렀을때 기존 정보가 입력되어 있도록 하고 싶습니다.
어떻게 해야될까요
도움부탁드릴께요..
|
댓글을 작성하시려면 로그인이 필요합니다.
댓글 6개
$car_info = explode("|",$write[mb_5]);
$info01 = $car_info[0];
$info02 = $car_info[1];
$info03 = $car_info[2];
$info04 = $car_info[3];
$info05 = $car_info[4];
$info06 = $car_info[5];
$info07 = $car_info[6];
$info08 = $car_info[7];
?>
위에 보시면 mb_5를 다음과 같이 설정했습니다.
아래와 같이 넣어주면 해결됩니다. 이것을 응용하면 되겠네요.
$wr_9 = "$ext9_00|$ext9_01|$ext9_02|$ext9_03";
mysql_query(" update $write_table set wr_9 = '$wr_9' where wr_id = '$wr_id' ");
$mb_5 = "$info01|$info02|$info03|$info04|$info05|$info06|$info07|$info08";
$sql5 = " update $g4[member_table]
set mb_5 = '$mb_5'
where mb_id = '$_POST[mb_id]' ";
sql_query($sql5);
이렇게 하였는데도 입력이 안됩니다.
도와주세요
mysql_query(" update g4_member set mb_5 = '$mb_5' where mb_id = '$member[mb_id]' ");
이렇게 한번 해보세요. 테스트해보니까 입력은 되는것 같은데.. 그래도 안되면 다른문제인 것 같습니다.
제가 실수를 했네요 ㅡ.ㅡ;
문제는 다른곳에 있네요
신경써주셔서 감사합니다.
문제는 이곳입니다. ㅡ.ㅡ;
<?
$car_info = explode("|",$write[mb_5]);
$info01 = $car_info[0];
$info02 = $car_info[1];
$info03 = $car_info[2];
$info04 = $car_info[3];
$info05 = $car_info[4];
$info06 = $car_info[5];
$info07 = $car_info[6];
$info08 = $car_info[7];
?>
$car_info = explode("|",$write[mb_5]);
$write[mb_5]) 가 아니고 $member[mb_5])로 해야되네요..
게시판 소스를 가져다가 구조도 모르고 뜯어 고치니 문제가 생겼네요..
감사합니다.