PHP - 스물번째날 (1216)
회원가입 - DB작성 과 php소스로 DB연결
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\Documents and Settings\Administrator>mysql -u
mysql: option -u requires an argument
C:\Documents and Settings\Administrator>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 4.0.22-nt
Type help; or \h for help. Type \c to clear the buffer.
mysql> use appledb;
Database changed
mysql> show tables;
+-------------------+
| Tables_in_appledb |
+-------------------+
| aaa |
| bd_02 |
| bd_3 |
| board |
| board1 |
| member |
| memo |
| mymemo |
+-------------------+
8 rows in set (0.00 sec)
mysql> desc member;
+----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+----------------+
| num | int(11) | | PRI | NULL | auto_increment |
| userid | varchar(20) | | UNI | | |
| userpass | varchar(20) | | | | |
| question | varchar(150) | | | | |
| answer | varchar(50) | | | | |
| username | varchar(30) | | | | |
| email | varchar(50) | | | | |
| jumin | varchar(13) | | | | |
| tel | varchar(20) | | | | |
| zip | varchar(7) | | | | |
| address | varchar(50) | | | | |
| job | varchar(50) | | | | |
| hobby | varchar(50) | | | | |
+----------+--------------+------+-----+---------+----------------+
13 rows in set (0.04 sec)
mysql>
*** index.html
<!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN>
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
</HEAD>
<BODY>
<table border=1 width=800>
<tr>
<td colspan=2><img src=http://www.pcall.co.kr/img/93.gif height=150></td>
</tr>
<tr>
<td width=30% height=300 valign=top>
<form method=post action=login.php>
<table border=1 width=200>
<tr>
<td>아이디</td>
<td><input type=text name=username size=10></td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type=password name=userpass size=10></td>
</tr>
<tr>
<td colspan=2 align=center>
<input type=submit value=로그인></td>
</tr>
</table>
</form>
메뉴
<br>
<a href=index.html?mode=home>처음으로</a>
<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 ../board0/list.html;
break;
case memo: include ..memo/memolist.html;
break;
case join: include
egist.html;
break;
}
?>
</td>
</tr>
</table>
</BODY>
</HTML>
***regist.html
<!--아이디
비밀번호
비밀번호확인
이름
이메일
주민번호
전화번호
주소
핸드폰
직업
취미-->
<form method=post action=regist.php>
<form method=post action=regist.php>
<table border=1 width=500>
<tr>
<td>아이디</td>
<td><input type=text name=userid></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=userid></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);
$resulut=mysql_query($query);
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 테이블 생성 실폐;
}
*/
?>
***memberdb.php
<?
//파일명: memberdb.php
/*
아이디 : userid
비밀번호: userpass
비밀번호확인://
비밀번호질문:question
질문답변: ansewr
이름: username
이메일 : email
주민번호: jumin
전화번호 : tel
핸드폰://
우편번호: zip
주소: address
직업: job
취미: hobby
*/
/*
echo userid --- $userid<br>;
echo userpass --- $userpass1<br>;
echo question --- $question<br>;
echo answer --- $answer<br>;
echo email --- $email<br>;
$jumin=$jumin1 . $jumin<br>;
echo jumin --- $userpass1<br>;
$tel=$tell . - . $tel2 . - . $tel3;
echo el --- %tel<br>;
$zip=$zip1 . - . $zip2;
echo zip --- $zip<br>;
echo address --- $address<br>;
$totaladdress=$zip . /. $address;
echo job --- $job<br>;
echo hobby --- $hobby<br>;
*/
include connect.php;
$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)or die(mysql_error());
if($result){
echo 테이블 생성 성공;
}else{
echo 테이블 생성 실폐;
}
?>
2004 12 16 php스터디
소스자세정확하게보기
http://www.6VJ.com/php/php1216.txt
| 
방송
