BLOG ARTICLE WebDB | 2 ARTICLE FOUND

  1. 2010.05.19 PHP 회원목록 출력
  2. 2010.05.17 PHP 회원가입 프로그램

dbConfig.php
<?php

$dbHost = "localhost";
$dbUser = "dbuser";
$dbpass = "dbpass";
$dbName = "dbname";

?>

memberList.php
<?php
require "./dbConfig.php";

$sql = "SELECT userid, username, email FROM php_member";

$dbConn = mysql_connect($dbHost, $dbUser, $dbpass);
mysql_select_db($dbName, $dbConn);
mysql_set_charset("utf8");
$result = mysql_query($sql, $dbConn);

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title></title>
    </head>
    <body>
        아이디 이름 이메일 <br />
        <?php
        while ($rec = mysql_fetch_array($result)) {
            echo $rec["userid"] . " " . $rec["username"] . " " . $rec["email"] . "<br />";
        }
        ?>
    </body>
</html>
<?
mysql_close($dbConn);
?>


'프로그래밍 > PHP' 카테고리의 다른 글

PHP 개요  (0) 2010.09.06
PHP 회원가입 프로그램  (0) 2010.05.17
AND

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;

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>

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)
?>



'프로그래밍 > PHP' 카테고리의 다른 글

PHP 개요  (0) 2010.09.06
PHP 회원목록 출력  (0) 2010.05.19
AND