회원가입 - 중복체크
***index.html-------------------------------------
<?session_start();?>
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<style>
input {background:#ffdcd7}
</style>
</HEAD>
<BODY>
<table border=1 width=800>
<tr>
<td colspan=2><img src=http://www.pcall.co.kr/img/103.gif height=150></td>
</tr>
<tr>
<td width=30% height=300 valign=top>
메뉴
<br>
<a href=index.html?mode=home>처음으로</a>
<?
if($id){
echo <br>{$name}님 환영합니다.<br>;
echo <br><a href=logout.php>로그아웃</a><br>;
}else{
?>
<form method=post action=login.php>
<table border=1 width=200>
<tr>
<td>아이디</td>
<td><input type=text name=userid size=15 value=아이디를 입력 onFocus=this.value=\></td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type=password name=userpass size=15 value=비밀번호입력 onFocus=this.value=\ ></td>
</tr>
<tr>
<td colspan=2 align=center>
<input type=submit value=로그인></td>
</tr>
</table>
</form>
<!--
***********************
<input type= ext name=
ame value=이름 style=order:black 1px solid;background-color:ivory onMouseOver= his.style.backgroundColor=ccffcc\ onMouseOut= his.style.backgroundColor=ivory\ onFocus= his.value=\ size=10>
<input type= ext name=email value=이메일 style=order:black 1px solid;background-color:ivory onMouseOver= his.style.backgroundColor=ccffcc\ onMouseOut= hes.style.backgroundColor=ivory\ onFocus= his.value=\ size=10>
<input type= ext name=memo value=내용 style=order:black 1px solid;background-color:ivory onMouseOver= his.style.backgroundColor=ccffcc\ onMouseOut= hes.style.backgroundColor=ivory\ onFocus= his.value=\ size=30>
**********************
-->
<p>
<a href=index.html?mode=join>회원가입</a>
<p>
<?}?>
<a href=index.html?mode=board>게시판</a>
<p>
<a href=index.html?mode=memo>메모장</a>
<p>
</td>
<td align=center>
뷰
<?
if(!$mode){
$mode=home;
}
switch($mode){
case home: include
ull.html;
break;
case oard: include oard1/list.html;
break;
case memo: include ..memo/memolist.html;
break;
case join: include
egist.html;
break;
case dview : include ./board1/view.html;
break;
}
?>
</td>
</tr>
</table>
</BODY>
</HTML>
***regist.html-------------------------
<!--아이디
비밀번호
비밀번호확인
이름
이메일
주민번호
전화번호
주소
핸드폰
직업
취미-->
<script>
function id_search(ref){
var id=eval(document.regist.userid);
if(!id.value){
alert(아이디를 입력하신 후에 확인하세요!);
id.focus();
return;
}else{
ref=ref+?id=+id.value;
var window_left=(screen.width-640)/2;
var window_top=(screen.height-480)/2;
window.open(ref,id_search,width=250,height=140,status=no, top=+window_top+,left+window_left+\);
//location.href=ref;
}
}
</script>
<form name=regist method=post action=regist.php>
<table border=1 width=500>
<tr>
<td width=20%>아이디</td>
<td><input type=text name=userid><input type=button onClick=id_search(id_search.php) value=중복확인></td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type=password name=userpass1></td>
</tr>
<tr>
<td>비밀번호확인</td>
<td><input type=password name=userpass2></td>
</tr>
<tr>
<td>비밀번호 <br>분실시질문</td>
<td><input type=text name=qusstion size=50></td>
</tr>
<tr>
<td>질문답변</td>
<td><input type=text name=answer></td>
</tr>
<tr>
<td>이름</td>
<td><input type=text name=username></td>
</tr>
<tr>
<td>이메일</td>
<td><input type=text name=email></td>
</tr>
<tr>
<td>주민번호</td>
<td><input type=text name=jumin1 size=6>-<input type=text name=jumin2 size=7></td>
</tr>
<tr>
<td>전화번호</td>
<td><input type=text name=tell size=2>-<input type=text name=tel2 size=4>-<input type=text name=tel3 size=4></td>
</tr>
<tr>
<td>모바일</td>
<td><input type=text name=mobile></td>
</tr>
<tr>
<td>우편번호</td>
<td><input type=text name=zip1 size=3>-<input type=text name=zip2 size=3></td>
</tr>
<tr>
<td>주소</td>
<td><input type=text name=address size=20></td>
</tr>
<tr>
<td>직업</td>
<td><input type=text name=job></td>
</tr>
<tr>
<td>취미</td>
<td><input type=text name=hobby></td>
</tr>
<tr>
<td colspan align=center>
<input type=submit value=가입>
</td>
</tr>
</table>
</form>
***regist.php-------------------------
<?
//파일명: memberdb.php
/*
아이디 : userid
비밀번호: userpass
비밀번호확인:
비밀번호질문:question
질문답변: ansewr
이름: name
이메일 : jumin
주민번호: jumin
전화번호 : tel
핸드폰:
주소: address
직업: job
취미: hobby
*/
echo userid --- $userid<br>;
echo userpass --- $userpass1<br>;
echo question --- $question<br>;
echo answer --- $answer<br>;
echo username --- $username<br>;
echo email --- $email<br>;
$jumin=$jumin1 . $jumin2;
echo jumin --- $jumin<br>;
$tel=$tell . - . $tel2 . - . $tel3;
echo el --- $tel<br>;
$zip=$zip1 . - . $zip2;
echo zip --- $zip<br>;
echo address --- $address<br>;
$totaladdress=$zip . / . $address;
echo otaladdress --- $totaladdress<br>;
echo job --- $job<br>;
echo hobby --- $hobby<br>;
include connect.php;
$query=insert into member values(NULL, $userid,$userpass1,$question,$answer,$username,$email,$jumin,$tel,$zip,$totaladdress,$job,$hobby);
$result=mysql_query($query) or die(mysql_error());
if($result){
echo 입력성공;
}else{
echo 입력실패;
}
/*
$query=create table member(
num int not null auto_increment primary key,
userid varchar(20) not null unique,
userpass varchar(20) not null ,
question varchar(150) not null,
answer varchar(50) not null,
username varchar(30) not null,
email varchar(50) not null,
jumin varchar(13) not null,
tel varchar(20) not null,
zip varchar(7) not null,
address varchar(50) not null,
job varchar(50) not null,
hobby varchar(50) not null);
$result=mysql_query($query);
if($result){
echo 테이블 생성 성공;
}else{
echo 테이블 생성 실폐;
}
*/
?>
***id_search.php ----------------------------
<script>
function test(){
opener.document.regist.userpass1.focus();
self.close();
}
</script>
<?
include connect.php;
$query=select * from member where userid=$id\;
$result=mysql_query($query);
$rows=mysql_num_rows($result);
if(!$rows){
echo $id는 사용하실 수 있습니다!<br>;
//echo <a href=javascript:self.close();>확인</a>;
echo <input type=button onClick=test() value=확인>;
}else{
echo $id는 사용중입니다!;
}
/* 중복확인 방법처음
if(!$rows){
echo <script>
alert($id + 는 사용하실 수 있는 아이디 입니다!);
history.back();
</script>;
}else{
echo <script>
alert($id + 는 사용 중 아이디 입니다!);
history.back();
</script>;
}
*/
?>
PHP스터디 2004 12 22
소스자세히 보기
http://www.6VJ.com/php/php1222.txt
| 
방송
