php_member.sql
CREATE TABLE IF NOT EXISTS `php_member` (
`userid` varchar(16) NOT NULL,
`password` char(32) NOT NULL,
`username` varchar(20) NOT NULL,
`jumin1` char(6) NOT NULL,
`jumin2` char(32) NOT NULL,
`zipcode` char(7) NOT NULL,
`address1` varchar(40) NOT NULL,
`address2` varchar(40) NOT NULL,
`email` varchar(40) NOT NULL,
`job` varchar(10) NOT NULL,
`intro` tinytext NOT NULL,
PRIMARY KEY (`userid`),
UNIQUE KEY `jumin` (`jumin1`,`jumin2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
`userid` varchar(16) NOT NULL,
`password` char(32) NOT NULL,
`username` varchar(20) NOT NULL,
`jumin1` char(6) NOT NULL,
`jumin2` char(32) NOT NULL,
`zipcode` char(7) NOT NULL,
`address1` varchar(40) NOT NULL,
`address2` varchar(40) NOT NULL,
`email` varchar(40) NOT NULL,
`job` varchar(10) NOT NULL,
`intro` tinytext NOT NULL,
PRIMARY KEY (`userid`),
UNIQUE KEY `jumin` (`jumin1`,`jumin2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
memForm.html
<!DOCTYPE html PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN”
“http://www.w3.org/TR/html4/loose.dtd”>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>입력 폼</title>
</head>
<body>
<form name=”form” method=”post” action=”addMember.php”>
<h3>이름을 입력하세요</h3>
<table border=”1″>
<tr>
<td>회원아이디</td>
<td><input type=”text” name=”userid” size=”10″ maxlength=”16″><br />
</td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type=”password” name=”password” size=”10″
maxlength=”16″><input type=”password” name=”repassword”
size=”10″ maxlength=”16″><br />
</td>
</tr>
<tr>
<td>회원이름</td>
<td><input type=”text” name=”username”><br />
</td>
</tr>
<tr>
<td>주민번호</td>
<td><input type=”text” name=”jumin1″ size=”6″ maxlength=”6″>-<input
type=”password” name=”jumin2″ size=”7″ maxlength=”7″><br />
</td>
</tr>
<tr>
<td>우편번호</td>
<td><input type=”text” name=”zipcode” maxlength=”7″><br />
</td>
</tr>
<tr>
<td>주소</td>
<td><input type=”text” name=”address1″ size=”40″><br />
</td>
</tr>
<tr>
<td>상세주소</td>
<td><input type=”text” name=”address2″ size=”40″><br />
</td>
</tr>
<tr>
<td>이메일</td>
<td><input type=”text” name=”email”><br />
</td>
</tr>
<tr>
<td>직업</td>
<td><select name=”job”>
<option>학생</option>
<option>회사원</option>
<option>교직원</option>
<option>공무원</option>
<option>주부</option>
<option>기타</option>
</select><br />
</td>
</tr>
<tr>
<td>자기소개</td>
<td><textarea name=”intro” cols=”25″ rows=”5″></textarea> <br />
</td>
</tr>
<tr>
<td><input type=”submit” value=”등록” /> <input type=”reset”
value=”취소” /></td>
</tr>
</table>
</form>
</body>
</html>
“http://www.w3.org/TR/html4/loose.dtd”>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>입력 폼</title>
</head>
<body>
<form name=”form” method=”post” action=”addMember.php”>
<h3>이름을 입력하세요</h3>
<table border=”1″>
<tr>
<td>회원아이디</td>
<td><input type=”text” name=”userid” size=”10″ maxlength=”16″><br />
</td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type=”password” name=”password” size=”10″
maxlength=”16″><input type=”password” name=”repassword”
size=”10″ maxlength=”16″><br />
</td>
</tr>
<tr>
<td>회원이름</td>
<td><input type=”text” name=”username”><br />
</td>
</tr>
<tr>
<td>주민번호</td>
<td><input type=”text” name=”jumin1″ size=”6″ maxlength=”6″>-<input
type=”password” name=”jumin2″ size=”7″ maxlength=”7″><br />
</td>
</tr>
<tr>
<td>우편번호</td>
<td><input type=”text” name=”zipcode” maxlength=”7″><br />
</td>
</tr>
<tr>
<td>주소</td>
<td><input type=”text” name=”address1″ size=”40″><br />
</td>
</tr>
<tr>
<td>상세주소</td>
<td><input type=”text” name=”address2″ size=”40″><br />
</td>
</tr>
<tr>
<td>이메일</td>
<td><input type=”text” name=”email”><br />
</td>
</tr>
<tr>
<td>직업</td>
<td><select name=”job”>
<option>학생</option>
<option>회사원</option>
<option>교직원</option>
<option>공무원</option>
<option>주부</option>
<option>기타</option>
</select><br />
</td>
</tr>
<tr>
<td>자기소개</td>
<td><textarea name=”intro” cols=”25″ rows=”5″></textarea> <br />
</td>
</tr>
<tr>
<td><input type=”submit” value=”등록” /> <input type=”reset”
value=”취소” /></td>
</tr>
</table>
</form>
</body>
</html>
addMember.php
<?php
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
$userid = $_POST[“userid”];
$password = $_POST[“password”];
$username = $_POST[“username”];
$jumin1 = $_POST[“jumin1”];
$jumin2 = $_POST[“jumin2”];
$zipcode = $_POST[“zipcode”];
$address1 = $_POST[“address1”];
$address2 = $_POST[“address2”];
$email = $_POST[“email”];
$job = $_POST[“job”];
$intro = $_POST[“intro”];
$dbHost = “localhost”;
$dbUser = “dbuser”;
$dbpass = “dbpass”;
$dbName = “dbname”;
$sql = “INSERT INTO php_member
(userid, password, username, jumin1, jumin2,
zipcode, address1, address2, email, job, intro)
VALUES
(‘$userid’, ‘$password’, ‘$username’, ‘$jumin1’, ‘$jumin2’,
‘$zipcode’, ‘$address1’, ‘$address2’, ‘$email’, ‘$job’, ‘$intro’)”;
$dbConn = mysql_connect($dbHost, $dbUser, $dbpass);
mysql_select_db($dbName, $dbConn);
mysql_set_charset(“utf8”);
mysql_query($sql, $dbConn);
mysql_close($dbConn)
?>