그누보드 - 회원가입 폼인데,,, 으~~

회원가입 폼인데,,, 으~~ 정보

회원가입 폼인데,,, 으~~

본문

<?
include("../../inc/global.php");

if($mlogin != "")
moveurl("../main/index.php");

if($subp=="save"){

$id = trim($id);
$pass = trim($pass);

$leader = trim($leader);

$name = trim($name);
$ssn1 = trim($ssn1);
$ssn2 = trim($ssn2);

$com_post = trim($com_post);
$com_addr = trim($com_addr1);
$com_addr2 = trim($com_addr2);

$post = trim($post);
$addr = trim($addr1);
$addr2 = trim($addr2);
$tel = trim($tel);
$hp = trim($hp);
$email = trim($email);
$mailing = trim($mailing);
$birth = trim($birth);
$birth_op = trim($birth_op);
$comnum = trim($comnum);
$company = trim($company);
$comitem = trim($comitem);
$comtype = trim($comtype);
$fax = trim($fax);

if($id != ""){
$query = "select count(*) from t_member where uid='$id'";

$db->parseExec($query);
$db->fetch();
$count = (int)$db->result(1);
$db->ParseFree();

if($count != 0){
$db->disconnect();
msgBack("이미 존재하는 아이디입니다!! 다시한번 시도해 주십시오!!");
}

$query = "select count(*) from t_member where ssn1='$ssn1' and ssn2=md5('$ssn2')";

$db->parseExec($query);
$db->fetch();
$count = (int)$db->result(1);
$db->ParseFree();

if($count != 0){
$db->disconnect();
msgBack("이미 존재하는 주민등록번호입니다!! 다시한번 시도해 주십시오!!");
}

/* 2011-01-04 이메일 중복 체크 제외시킴
$query = "select count(*) from t_member where email='$email'";

$db->parseExec($query);
$db->fetch();
$count = (int)$db->result(1);
$db->ParseFree();

if($count != 0){
$db->disconnect();
msgBack("이미 존재하는 이메일 주소입니다!! 다시한번 시도해 주십시오!!");
}
*/

$query = "select count(*) from t_member where uid='$recomid'";

$db->parseExec($query);
$db->fetch();
$count = (int)$db->result(1);
$db->ParseFree();

if($count == 0){
$recomid = "";
}

$region = trim(substr($addr, 0, 4));
$temparr = split("-", $ssn);
$sex = substr($temparr[1], 0, 1);

if($sex == 2)
$sex = 1;
else
$sex = 0;

$preurl2 = $HTTP_COOKIE_VARS["preurl2"];

$query = "insert t_member (gid, auth, teamidx, company, comnum, comtype, comitem, leader, name, uid, ssn1, ssn2, pass, com_post, com_addr1, com_addr2, post, addr1, addr2, email, regdate, hp, tel, fax, recomid, mailing, birth, birth_op, region, sex, preurl)
values (10, 1, '$teamidx', '$company', '$comnum', '$comtype', '$comitem', '$leader', '$name', '$id', '$ssn1', md5('$ssn2'), md5('$pass'), '$com_post', '$com_addr', '$com_addr2', '$post', '$addr', '$addr2', '$email', now(), '$hp', '$tel', '$fax', '$recomid', '$mailing', '$birth', '$birth_op', '$region', '$sex', '$preurl2')";

$db->parseExec($query);
$db->ParseFree();

if($py_join2mileageop == 1 && $py_join2mileage != 0){
$join2mileage = $py_join2mileage;

pulsMileage($db, $id, $join2mileage, '회원가입 감사 적립금을 증정합니다.', number_format($join2mileage).'원 적립');
}

// 선택 영업팀 인원수 추가
if($teamidx>0){
$query = "update t_team set su=su+1 where idx='".$teamidx."'";
$db->parseExec($query);
$db->ParseFree();

// 선택 영업팀 매니져 인원수 추가
$query = "select teammngidx from t_team where idx='".$teamidx."'";
$db->parseExec($query);
$db->fetch();
$teammngidx = $db->result(1);
$db->ParseFree();

$query = "update t_team_mng set su=su+1 where idx='".$teammngidx."'";
$db->parseExec($query);
$db->ParseFree();
}

include "../inc/mime.php";

//가입메일 전송
$query = "select content, title from t_mail where name='member_register'";

$db->parseExec($query);
$db->fetch();
$content = $db->result(1);
$subject = $db->result(2);
$db->ParseFree();

if($subject!=""){
$content = ereg_replace("name_str", $name, $content);
$content = ereg_replace("uid_str", $id, $content);
$content = ereg_replace("pass_str", $pass, $content);

$arr[from] = $cfg_sitename;
$arr[subject] = $subject;
$arr[fromemail] = $cfg_email;
$arr[to] = $name."<".$email.">";
$arr[body] = $content;
//MIME($arr);
}

$db->disconnect();

msgmove("성공적으로 가입이 완료되었습니다.", "../main/index.php");
}else{
$db->disconnect();
msgBack("다시 한번 시도해 주십시오!!");
}
}

if($ok!=1){
move("agree.php");
}

// 영업팀 리스트
$query = "select idx, name from t_team order by name";
$db->ParseExec($query);
$db->fetchStatement($rs_team);
$cnt_team = $db->rowCount();
$db->ParseFree();

?>

<?
include("../data/renew/goodsword.php");
include("../pages/top3.html");
?>

<table width='100%' border="0" cellspacing="0" cellpadding="0">
<tr>
<td height='50'></td>
</tr>

<tr>
<td align='center'>

<script language=Javascript src="../js/memberJavascript.js"></script>

<table width="700" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="top"><table width="700" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="700" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="60" background="../images/v3/title/join2.gif" width="700" align='right'>HOME<img src="../images/arrow_position.gif" width="13" height="5" align="absmiddle">회원<img src="../images/arrow_position.gif" width="13" height="5" align="absmiddle">사업자 회원가입</td>
</tr>
</table></td>
</tr>

<form name='frm' action='join2.php?subp=save' method=post>

<tr>
<td align="center"><table width="640" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="40" class="pad_l10"><img src="../images/txt_join3.gif" width="129" height="40"> <font color="#FF0000">*표시된 목록은 필수 기제사항 입니다 정확히 기록해주세요.</font></td>
</tr>
<tr>
<td align="center"><table width="620" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#616060" height="1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 배송담당자</td>
<td width="10"> </td>
<td><select name=teamidx>
<option value="">선택                             </option>
<option value="0">없음</option>

<?for($i=0;$i<$cnt_team;$i++){?>

<option value="<?=$rs_team['idx'][$i]?>"><?=$rs_team['name'][$i]?></option>

<?}?>

</select></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 상호명</td>
<td width="10"> </td>
<td><input type="text" name="company" class="basic" style="width:160"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 사업자등록번호</td>
<td width="10"> </td>
<td><input type="text" name="comnum1" class="basic" style="width:60" maxlength=3> - <input type="text" name="comnum2" class="basic" style="width:40" maxlength=2> - <input type="text" name="comnum3" class="basic" style="width:80" maxlength=5></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 업태/종목</td>
<td width="10"> </td>
<td><input type="text" name="comtype" class="basic" style="width:160"> / <input type="text" name="comitem" class="basic" style="width:160"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 대표자</td>
<td width="10"> </td>
<td><input type="text" name="leader" class="basic" style="width:160"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 우편번호</td>
<td width="10"> </td>
<td width="110"><input type="text" name="com_post1" class="basic" style="width:40" maxlength=3>
-
<input type="text" name="com_post2" class="basic" style="width:40" maxlength=3></td>
<td>
<img src="../images/b_zipcode.gif" width="86" height="25" class=abtn onClick="chkpost('company');"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 사업장 주소</td>
<td width="10"> </td>
<td><input type="text" name="com_addr1" class="basic" style="width:460"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 나머지주소</td>
<td width="10"> </td>
<td><input type="text" name="com_addr2" class="basic" style="width:460"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#616060"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 고객아이디</td>
<td width="10"> </td>
<td width="170"><input type="text" name="id" class="basic" style="width:160"></td>
<td width="102"><img src="../images/b_id.gif" width="86" height="25" onClick="chkID(frm);" class=abtn></td>
<td> 영문.숫자 4~12자리 </td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 비밀번호</td>
<td width="10"> </td>
<td width="170"><input type="password" name="pass" class="basic" style="width:160" maxlength=12></td>
<td> 영문.숫자 4~12자리 </td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 비밀번호확인</td>
<td width="10"> </td>
<td><input type="password" name="pass2" class="basic" style="width:160" maxlength=12></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 담당자 성명</td>
<td width="10"> </td>
<td><input type="text" name="name" class="basic" style="width:160" maxlength=5></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 주민등록번호</td>
<td width="10"> </td>
<td><input type="text" name="ssn1" class="basic" style="width:80" maxlength=6 onKeyUp="moveFocus(6,this,this.form.ssn2);" onChange='SetBirth(this.form)'>
-
<input type="password" name="ssn2" class="basic" style="width:80" maxlength7></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td height="20" align="right"><input type="checkbox" name="chk" value="1" onClick="setsendadr(frm);">
사업장 주소 정보와 동일 </td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>

<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4">우편번호</td>
<td width="10"> </td>
<td width="110"><input type="text" name="post1" class="basic" style="width:40" maxlength=3>
-
<input type="text" name="post2" class="basic" style="width:40" maxlength=3></td>
<td><img src="../images/b_zipcode.gif" width="86" height="25" class=abtn onClick="chkpost('send');"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4">배송 주소</td>
<td width="10"> </td>
<td><input type="text" name="addr1" class="basic" style="width:460"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4">나머지주소</td>
<td width="10"> </td>
<td><input type="text" name="addr2" class="basic" style="width:460"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4">전화번호</td>
<td width="10"> </td>
<td><input type="text" name="tel1" class="basic" style="width:40" maxlength=3>
-
<input type="text" name="tel2" class="basic" style="width:60" maxlength=4>
-
<input type="text" name="tel3" class="basic" style="width:60" maxlength=4></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4">팩스</td>
<td width="10"> </td>
<td><input type="text" name="fax1" class="basic" style="width:40" maxlength=4>
-
<input type="text" name="fax2" class="basic" style="width:60" maxlength=4>
-
<input type="text" name="fax3" class="basic" style="width:60" maxlength=4></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4">핸드폰</td>
<td width="10"> </td>
<td><input type="text" name="hp1" class="basic" style="width:40" maxlength=3>
-
<input type="text" name="hp2" class="basic" style="width:60" maxlength=4>
-
<input type="text" name="hp3" class="basic" style="width:60" maxlength=4></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4">이메일</td>
<td width="10"> </td>
<td width="210"><input type="text" name="email" class="basic" style="width:200" maxlength=50></td>
<td> 비밀번호 분실시 이메일로 확인합니다.</td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4">메일수신여부</td>
<td width="10"> </td>
<td> 신상품, 이벤트 및 각종 안내메일을 받으시겠습니까?
<input name="mailing" type="radio" value="1" checked>
예
<input name="mailing" type="radio" value="0">
아니오 </td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td><table width="620" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="center" bgcolor="f4f4f4">생년월일</td>
<td width="10"> </td>
<td><input type="text" name="birth_y" class="basic" style="width:60" maxlength=4>
년
<input type="text" name="birth_m" class="basic" style="width:30" maxlength=2>
월
<input type="text" name="birth_d" class="basic" style="width:30" maxlength=2>
일
<input name="birthop" type="radio" value="0" checked>
양력
<input name="birthop" type="radio" value="1">
음력 </td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="#E1E1E1"></td>
</tr>
<tr>
<td height="60" align="center"><img src="../images/b_join.gif" width="66" height="25" onClick='chkRegFrm2(frm);' class=abtn>   <a href="/main/index.php"><img src="../images/b_esc.gif" width="66" height="25"></a></td>
</tr>
</table></td>
</tr>
<tr>
<td height="60"> </td>
</tr>
</table></td>
</tr>

<input type=hidden name='comnum' value=''>
<input type=hidden name='ssn' value=''>
<input type=hidden name='birth' value=''>
<input type=hidden name='com_post' value=''>
<input type=hidden name='post' value=''>
<input type=hidden name='tel' value=''>
<input type=hidden name='hp' value=''>
<input type=hidden name='fax' value=''>
<input type=hidden name='idcheckop' value='0'>
</form>

<iframe name=procFrame width=0 height=0></iframe>

<tr>
<td height="20"></td>
</tr>
<tr>
<td align="center"> </td>
</tr>
<tr>
<td height="20"></td>
</tr>
</table></td>
</tr>
</table>

</td>
</tr>
<tr>
<td height='50'></td>
</tr>
</table>

<?include("../pages/bottom3.html");?>

</td>

<td width="10"></td>

<td width="7" align="center" valign="top">

<?include("../pages/quick3.html");?>

</td>
</tr>
</table>
================================================================================

회원가입 폼인데,,, 담당자랑 주민번호 입력란을 삭제 할려고 하는데요 삭제 하고 나면 회원 가입 자체가 안되네요,,,
<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 담당자 성명</td>
<td width="10"> </td>
<td><input type="text" name="name" class="basic" style="width:160" maxlength=5></td>

이부분하고

<td width="120" align="center" bgcolor="f4f4f4"><font color="#FF0000">*</font> 주민등록번호</td>
<td width="10"> </td>
<td><input type="text" name="ssn1" class="basic" style="width:80" maxlength=6 onKeyUp="moveFocus(6,this,this.form.ssn2);" onChange='SetBirth(this.form)'>
-
<input type="password" name="ssn2" class="basic" style="width:80" maxlength7></td>

이부분만 삭제 하면 되는것 아닌가요?

고수님들 도와주세요~~

댓글 전체

곰토리 자기소개 아이디로 검색 회원게시물

자기소개 아이디로 검색 회원게시물

12.08.08 11:05:00

그 위에 DB 처리 하는 페이지에서 주민번호 비교하는 부분도 삭제 해주셔야지요..

$query = "select count(*) from t_member where ssn1='$ssn1' and ssn2=md5('$ssn2')";

$db->parseExec($query);
$db->fetch();
$count = (int)$db->result(1);
$db->ParseFree();

if($count != 0){
$db->disconnect();
msgBack("이미 존재하는 주민등록번호입니다!! 다시한번 시도해 주십시오!!");
}

이걸 실행하기전에 $ssn1 과 $ssn2 가 값이 NULL 일때의 처리는요?
그리고 이메일 아이디 주민번호 세개다 묶어서 한번에 에러처리 하는게 효율적일듯 싶네요.

같은 쿼리문을 그것도 카운트만 돌리는걸 3개 하는건 좀 .. ;;

질문쟁이 홈페이지 자기소개 아이디로 검색 회원게시물

홈페이지 자기소개 아이디로 검색 회원게시물

12.08.08 11:31:53

말씀해주신데로 해도 회원 완료로 넘어가질 안네요,,,
ㅜ..ㅜ

곰토리 자기소개 아이디로 검색 회원게시물

자기소개 아이디로 검색 회원게시물

12.08.08 11:38:08

ssn 이 들어가는 부분에 대한 에러처리를 다 해주신거 맞으신건가요?

$query = "insert t_member (gid, auth, teamidx, company, comnum, comtype, comitem, leader, name, uid, ssn1, ssn2, pass, com_post, com_addr1, com_addr2, post, addr1, addr2, email, regdate, hp, tel, fax, recomid, mailing, birth, birth_op, region, sex, preurl)
values (10, 1, '$teamidx', '$company', '$comnum', '$comtype', '$comitem', '$leader', '$name', '$id', '$ssn1', md5('$ssn2'), md5('$pass'), '$com_post', '$com_addr', '$com_addr2', '$post', '$addr', '$addr2', '$email', now(), '$hp', '$tel', '$fax', '$recomid', '$mailing', '$birth', '$birth_op', '$region', '$sex', '$preurl2')";

여기만 봐도 업데이트에도 있고..

$temparr = split("-", $ssn);
$sex = substr($temparr[1], 0, 1);

if($sex == 2)
$sex = 1;
else
$sex = 0;

여기서도 성별 구분을 주민번호로 하는데.. ㄷㄷ

질문쟁이 홈페이지 자기소개 아이디로 검색 회원게시물

홈페이지 자기소개 아이디로 검색 회원게시물

12.08.08 12:39:52

감사함니다~~ 애구구~~

회원가입 폼인데,,, 으~~ > 그누4 질문답변

그누4 질문답변

회원가입 폼인데,,, 으~~ 정보

본문

댓글 전체

회원로그인