|
|
|
|
Á¤ÁöÇö / 2002-10-16 / ¿ÀÀü 1:36:10 / 211.35.36.127
Á¶È¸¼ö : 170
|
[Áú¹®] ȸ¿ø°¡ÀÔ ¿À·ù ¼öÁ¤ Á» ºÎŹµå¸³´Ï´Ù. |
ȸ¿ø°¡ÀÔ ´ÙÀ½À¸·Î ³Ñ¾î°¡Áö ¾Ê¾Æ¿ä..µµÅë ¸ð¸£°Ú¾î¿ä..¾Ë·ÁÁÖ¼¼¿ä~ °è¼Ó ÆäÀÌÁö¸¦ Ç¥½ÃÇÒ ¼ö ¾ø´Ù°í ³ª¿À´Âµ¥...¾Ë·ÁÁÖ¼¼¿ä~~
<%
'db¿¬°á
set db = Server.CreateObject("ADODB.Connection")
db.open("photo")
SQL = "select mem_id from member where mem_id='"&request("userid")&"'"
set result = db.Execute(SQL)
<%if not result.eof then%>
%>
<script language="javascript">
alert("ÀÌ¹Ì Á¸ÀçÇÏ´Â ¾ÆÀ̵ð ÀÔ´Ï´Ù!");
history.back();
</script>
<% else
name = request("name")
id = request("userid")
pwd = request("pwd1")
ssn = request("ssn1")&"-"&request("ssn2")
zip = request("zip1")&"-"&request("zip2")
addr = request("addr")
tel = request("tel1")&"-"&request("tel2")&"-"&request("tel3")
sex = request("sex")
job = request("job")
email = request("email")
intro = request("intro")
intro = replace(intro,"'","''")
SQL = "insert into member (mem_name,mem_id,mem_pwd,mem_ssn,mem_zip,mem_addr,mem_tel"
SQL = SQL & ",mem_sex,mem_job,mem_email,mem_intro) values"
SQL = SQL & "('"& name &"','"
SQL = SQL & id &"','"
SQL = SQL & pwd &"','"
SQL = SQL & ssn &"','"
SQL = SQL & zip &"','"
SQL = SQL & addr &"','"
SQL = SQL & tel &"','"
SQL = SQL & sex &"','"
SQL = SQL & job &"','"
SQL = SQL & email &"','"
SQL = SQL & intro &"')"
db.Execute SQL
%>
<script language="javascript">
alert("ȸ¿ø°¡ÀÔÀ» ÃàÇϵ帳´Ï´Ù.\n\nȸ¿ø·Î±äÀ» ÇØÁֽʽÿä");
location.href="login.asp"
</script>
<% end if %>
|
|
|
|