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 New Document
아이디
비밀번호
메뉴
처음으로

회원가입

게시판

메모장

뷰
***regist.html
아이디
비밀번호
비밀번호확인
비밀번호
분실시질문
질문답변
이름
이메일
주민번호 -
전화번호 --
모바일
우편번호 -
주소
직업
취미
***regist.php "; echo "userpass --- $userpass1
"; echo "question --- $question
"; echo "answer --- $answer
"; echo "username --- $username
"; echo "email --- $email
"; $jumin=$jumin1 . $jumin2; echo "jumin --- $jumin
"; $tel=$tell . "-" . $tel2 . "-" . $tel3; echo "tel --- %tel
"; $zip=$zip1 . "-" . $zip2; echo "zip --- $zip
"; echo "address --- $address
"; $totaladdress=$zip . "/" . $address; echo "totaladdress --- $totaladdress
"; echo "job --- $job
"; echo "hobby --- $hobby
"; 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 "; echo "userpass --- $userpass1
"; echo "question --- $question
"; echo "answer --- $answer
"; echo "email --- $email
"; $jumin=$jumin1 . $jumin
"; echo "jumin --- $userpass1
"; $tel=$tell . "-" . $tel2 . "-" . $tel3; echo "tel --- %tel
"; $zip=$zip1 . "-" . $zip2; echo "zip --- $zip
"; echo "address --- $address
"; $totaladdress=$zip . "/". $address; echo "job --- $job
"; echo "hobby --- $hobby
"; */ 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