|
|
|
|
 |
|
핑순이 / 2002-03-25 / 오후 6:19:43 / 61.33.59.215
조회수 : 150
|
| [질문] 회원가입부분이 저를 울려요...x) |
지가요...
새로 회사에 들어왔는데 이 부분을 완성하라구 해서 하고 있는데 몇일째 고생이네요...
회원가입부분에서 모든 값을 디비로 넘기는 것 까지는 했는데 중복 아이디 검사에서 안넘어가네요. 좀 도와주세요....
파일은 두갠데 하나는 등록화면이구, 하난 값을 받아 중복아이디를 체크하는 건데 정말 자꾸 안되네요...
좀 도와주세요....
도와주시면 여기 쥔장님을 큰언니로 모실께요....
registration.asp
<%@ Language=VBScript %>
<html>
<head>
<!--#include virtual="/inc/title.asp"-->
<!--#include virtual="/inc/css.asp"-->
<!--#include virtual="/inc/menu_java.asp"-->
<!--#include virtual="/inc/mail_java.asp"-->
<!--#include virtual="/inc/go_top.asp"-->
<meta http-equiv="content-type" content="text/html; charset=euc-kr">
<script language="vbscript">
sub join_idcheck_onClick()
IF join_form.join_id.value="" THEN
alert "아이디를 입력하셔야 합니다."
join_form.join_id.focus
ELSE
window.location.href="idcheck.asp?id="&document.join_form.join_id.value&""
END IF
end sub
function join_form_onSubmit
if (document.join_form.join_id.value="") or _
(document.join_form.join_passwd.value="") or _
(document.join_form.join_repasswd.value="") or _
(document.join_form.join_name.value="") or _
(document.join_form.join_email.value="") or _
(document.join_form.join_tel.value="") or _
(document.join_form.join_jumin.value="") then
alert "모두 입력해주세요."
join_form_onSubmit=False
join_form.join_passwd.focus
ELSE
if document.join_form.join_passwd.value= document.join_form.join_repasswd.value then
IDtot = 0
IDAdd = "234567892345"
jumin=document.join_form.join_jumin.value
if len(jumin) < 13 then
alert "주민등록번호 자리가 틀립니다."
join_form_onSubmit=False
join_form.join_jumin.focus
else
if (jumin="1234567890123") then
alert "주민등록번호가 틀립니다."
join_form_onSubmit=False
join_form.join_jumin.focus
else
for k=1 to 12
IDtot = IDtot + Mid(jumin, k, 1) * Mid(IDAdd, k, 1)
next
IDtot = 11 - (IDtot Mod 11)
if Right(jumin, 1)=Right(IDtot, 1) then
join_form_onSubmit=True
else
alert "주민등록번호가 틀립니다."
join_form_onSubmit=False
join_form.join_jumin.focus
end if
end if
end if
else
alert "비밀번호가 틀립니다."
join_form_onSubmit=False
join_form.join_passwd.focus
end if
END IF
end function
</script>
<script language="javascript">
function GoSearch()
{
fom = document.forms[0];
if ( document.InSearch.str_zip.value == "" )
{
alert("기재하고 싶은 주소를 선택하세요!");
fom.str_zip.focus();
return;
}
if (document.InSearch.str_zip.value.length <= 1)
{
alert("주소입력은 2자리 이상이어야 합니다!");
fom.str_zip.focus();
return;
}
document.InSearch.submit();
}
</script>
<script language="JavaScript">
function onlyNumber()
{
if ( event.keyCode<48 || event.keyCode>57 )
event.returnValue=false;
}
// 새로운 윈도우띄우는함수
function sub(url, field)
{
var opt = "toolbar=no,resizable=yes,scrollbars=yes,location=no,resize=no,menubar=no,directories=no,copyhistory=0,width=470,height=250,top= 330,left = 370";
window.open(url, 'new_window', opt);
}
</script>
</head>
<body background="/images/left_bg.gif" topmargin=0 leftmargin=0 marginwidth=0 marginheight=0>
<form name=join_form action="insert.asp" method=post>
<table border=0 cellpadding=0 cellspacing=0 width=770 height="100%">
<tr>
<td valign="top">
<table border=0 cellpadding=0 cellspacing=0 width=770 height="100%">
<tr>
<td valign="top" width="170">
<table border=0 cellpadding=0 cellspacing=0 width=170>
<tr>
<td colspan=2><img src="images/left_top01.gif"></td>
</tr>
<tr>
<td background="/images/left_menu_bg.gif"><img src="/images/left_menu_bg.gif" width="9" height="1"></td>
<td>
</td>
</tr>
<tr>
<td colspan=2><img src="/images/left_top02.gif"></td>
</tr>
</table>
</td>
<td valign="top" width="20"><img src="/images/title_cap.jpg"></td>
<td valign="top" width="580">
<table border=0 cellpadding=0 cellspacing=0 width="100%">
<tr>
<td>
<table border=0 cellpadding=0 cellspacing=0 width="100%">
<tr>
<td><img src="images/title01.jpg"></td>
<td><img src="images/title_com.jpg"></td>
</tr>
</table>
</td>
</tr>
<tr><td height=5></td></tr>
<tr>
<td>
<!-- 회원가입 양식 내용테이블 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%-->
<table width="580" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td> </td>
</tr>
<tr>
<td height="217" valign="top" align="center">
<table width=541 border=0 cellspacing=0 cellpadding=0 class=trcolor7>
<tr>
<td colspan=3 height=36 bgcolor=#ffffff><img src="images/bullet_01.gif">
[ <b><font color=#FF0000>*</font></b> ] 표시 항목은 회원가입시 필수기재사항입니다.</td>
<td width=1 class=white height=36></td>
</tr>
</table>
<!--전체적인 폼테이블 박스 시작#####################################################-->
<table width=570 border=0 cellspacing=1 cellpadding=0 bgcolor=#BEBCBC>
<tr>
<td width=113 class=sign align=right><b><font color=#FF0000>*</font></b>
아이디 </td>
<td width="300" style="padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:3px;" colspan="3">
<span style="font-size:9pt;"><input type=text name=join_id id=join_id value=<%"join_id"%> size=8 style="border:1px dotted;border-color:#396da5;color:396da5;background-color:white;font-size:8pt"> <input type=button id=join_idcheck name=join_idcheck value=중복체크 style="border:1px dotted;border-color:#396da5;color:white;background-color:#396da5;font-size:8pt"></span>
</td>
</td>
<!--이름부분 끝-->
</tr>
<tr>
<td width=113 class=sign height=35 align=right><b><font color=#FF0000>*</font></b>
비밀번호 </td>
<td width=425 class=white>
<input type="password" name="join_passwd" id="join_passwd" maxlength="10" size="13" class="input">
<b>4</b>자 이상 ~ <b>10</b>자 이내</td>
</tr>
<tr>
<td width=113 class=sign height=35 align=right><b><font color=#FF0000>*</font></b>
비밀번호확인 </td>
<td width=425 class=white>
<input type="password" name="join_repasswd" id="join_repasswd" maxlength="10" size="13" class="input">
</td>
</tr>
<tr>
<td width=113 class=sign height=35 align=right><b><font color=#FF0000>*</font></b>
이름 </td>
<td width=425 class=white>
<input type="text" name="join_name" id="join_name" maxlength="20" class="input">
</td>
</tr>
<tr>
<td width=113 class=sign height=35 align=right><b><font color=#FF0000>*</font></b>
주민등록번호 </td>
<td width=425 class=white>
<input type="text" name="join_jumin" id="join_jumin" maxlength="15" size="14" class=input >
-없이 숫자만 넣어주세요.</td>
</tr>
<tr>
<td width=113 class=sign height=35 align=right><font color=#FF0000>*</font> 이메일 </td>
<td width=425 class=white height=30>
<input type="text" name="join_email" id="join_email" maxlength="50" class="input">
</td>
</tr>
<tr>
<td width=113 class=sign height=90 align=right><font color=#FF0000>*</font>주소 </td>
<td width=425 class=white height=79>
<!--주소분 작은 테이블 --------------------------------------------------->
<TABLE cellpadding="5" cellspacing="1" bgcolor="white" width="480" align="center">
<TR bgcolor="white" height="25">
<td align="center" style="padding:0" width="120" bgcolor="#EFEFEF">우편번호</td>
<td width="260" style="padding:0">
<input type="text" name="join_zipcode1" size="3" maxlength="3" onKeypress="onlyNumber();">
-
<input type="text" name="join_zipcode2" size="3" maxlength="3" onKeypress="onlyNumber();" >
</td>
<td width="100" style="padding:0" bgcolor="#dddddd" align="center">
<button onClick="sub('../ZC/zip.asp', this);" style="background-color:#dddddd; BORDER: #dddddd 1px solid; WIDTH:100%; HEIGHT: 20" class="verdana" accessKey="I">
우편번호검색</button>
</td>
</TR>
<TR bgcolor="white" height="25">
<TD align="center" style="padding:0" width="120" bgcolor="#EFEFEF">
기본 주소 :
</TD>
<TD height="5" width="387" colspan="2">
<input type="text" name="join_address1" size="30" style="HEIGHT:18; BORDER: white 1px solid; WIDTH: 100%">
</TD>
</TR>
<TR bgcolor="white" height="25">
<TD align="center" style="padding:0" width="120" bgcolor="#EFEFEF">나머지 주소</TD>
<TD height="5" width="387" colspan="2">
<input type="text" name="join_address2" size="30" style="HEIGHT:18; BORDER: white 1px solid; WIDTH: 100%">
</TD>
</TR>
</TABLE>
<!--주소분 작은 테이블 --------------------------------------------------->
</td>
</tr>
<tr>
<td width=113 class=sign height=35 align=right><font color=#FF0000>*</font>연락처 </td>
<td width=425 class=white>
<input type="text" name="join_tel" id="join_tel" maxlength="20" class="input">
</td>
</tr>
<tr>
<td width=113 class=sign height=35 align=right>휴대폰</td>
<td width=425 class=white>
<input type="text" name="join_mphone" maxlength="20" class="input">
</td>
</tr>
<tr>
<td width=113 class=sign height=35 align=right>홈페이지</td>
<td width=425 class=white>
<input type="text" name="join_site" id="join_site" value='http://' size=30 maxlength='100' class="input">
</td>
</tr>
<tr>
<td width=113 class=sign height=35 align=right>소개</td>
<td width=425 class=white><textarea name="join_etc" id="join_etc" rows="5" cols="60"></textarea></td>
</tr>
</table>
<table width=580 border=0 cellspacing=0 cellpadding=10>
<tr>
<td height=30 >
<p>- <font color=#CC3300>필수기재사항을 빠짐없이 입력하신 후, 아래의 <b>확인</b> 버튼을 누르시면 가입이 완료됩니다.</font><br>
</td>
</tr>
</table>
<table cellpadding=4 border=0 cellspacing=5>
<tr>
<p align="center"><span style="font-size:10pt;"><input type=submit name=submit id=submit value=회원가입 style="border:1px dotted;border-color:#396da5;color:white;background-color:#396da5;font-size:8pt;width:50"> <input type=reset value=다시 style="border:1px dotted;border-color:#396da5;color:white;background-color:#396da5;font-size:8pt;width:50" id=reset name=reset></span></p>
<td><a href="insert.asp"><img src="images/join.gif" border=0 input type=submit name=submit id=submit></a></td>
<td><img src="images/cancel.gif" border=0 input type=reset id=reset name=reset></td>
</tr>
</table>
</td>
</tr>
</table>
<!--회원가입 양식 내용테이블 끝%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%-->
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="bottom">
</td>
</tr>
</table>
</form>
</body>
</html>
idcheck.asp
<%@ Language=VBScript %>
<OBJECT RUNAT=server PROGID=ADODB.Connection id=conn></OBJECT>
<%
idcheck=Request.QueryString("join_id")
%>
<!--#include file="dbconn.inc"-->
<%
sqlstring="select num from member where id='"&idcheck&"' order by num desc"
set result=conn.Execute(sqlstring)
if not result.eof then
%>
<script language="javascript">
window.alert("이미 다른 사용자가 사용하고 있습니다.")
window.history.back(1)
</script>
<%
else
%>
<script language="javascript">
window.alert("사용하실 수 있습니다.")
window.history.back(1)
</script>
<%
end if
conn.Close
%>
|
|
|
|