{"id":3261,"date":"2010-05-17T07:35:13","date_gmt":"2010-05-17T07:35:13","guid":{"rendered":"http:\/\/www.happyfam.or.kr\/ysoh\/php-%ed%9a%8c%ec%9b%90%ea%b0%80%ec%9e%85-%ed%94%84%eb%a1%9c%ea%b7%b8%eb%9e%a8\/"},"modified":"2015-02-10T21:11:48","modified_gmt":"2015-02-10T12:11:48","slug":"php-%ed%9a%8c%ec%9b%90%ea%b0%80%ec%9e%85-%ed%94%84%eb%a1%9c%ea%b7%b8%eb%9e%a8","status":"publish","type":"post","link":"https:\/\/www.happyfam.or.kr\/ysoh\/php-%ed%9a%8c%ec%9b%90%ea%b0%80%ec%9e%85-%ed%94%84%eb%a1%9c%ea%b7%b8%eb%9e%a8\/","title":{"rendered":"PHP \ud68c\uc6d0\uac00\uc785 \ud504\ub85c\uadf8\ub7a8"},"content":{"rendered":"

php_member.sql
\n<\/span><\/p>\n

\nCREATE TABLE IF NOT EXISTS `php_member` (  
\n  `userid` varchar(16) NOT NULL,
\n  `password` char(32) NOT NULL,
\n  `username` varchar(20) NOT NULL,
\n   `jumin1` char(6) NOT NULL,
\n  `jumin2` char(32) NOT NULL,
\n  `zipcode` char(7) NOT NULL,
\n  `address1` varchar(40) NOT NULL,
\n  `address2` varchar(40) NOT NULL,
\n  `email` varchar(40) NOT NULL,
\n  `job` varchar(10) NOT NULL,
\n  `intro` tinytext NOT NULL,
\n  PRIMARY KEY (`userid`),
\n  UNIQUE KEY `jumin` (`jumin1`,`jumin2`)
\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;<\/span><\/div>\n
\n
\n<\/span><\/font><\/div>\n
\nmemForm.html<\/span><\/font><\/div>\n
\n<\/p>\n
\n<!DOCTYPE html PUBLIC “-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN” 
\n“http:\/\/www.w3.org\/TR\/html4\/loose.dtd”>
\n<html>
\n<head>
\n<meta http-equiv=”Content-Type” content=”text\/html; charset=UTF-8″>
\n<title>\uc785\ub825 \ud3fc<\/title>
\n<\/head>
\n<body>
\n<form name=”form” method=”post” action=”addMember.php”>
\n<h3>\uc774\ub984\uc744 \uc785\ub825\ud558\uc138\uc694<\/h3>
\n<table border=”1″>
\n    <tr>
\n        <td>\ud68c\uc6d0\uc544\uc774\ub514<\/td>
\n        <td><input type=”text” name=”userid” size=”10″ maxlength=”16″><br \/>
\n        <\/td>
\n    <\/tr>
\n    <tr>
\n        <td>\ube44\ubc00\ubc88\ud638<\/td>
\n        <td><input type=”password” name=”password” size=”10″
\n            maxlength=”16″><input type=”password” name=”repassword”
\n            size=”10″ maxlength=”16″><br \/>
\n        <\/td>
\n    <\/tr>
\n    <tr>
\n        <td>\ud68c\uc6d0\uc774\ub984<\/td>
\n        <td><input type=”text” name=”username”><br \/>
\n        <\/td>
\n    <\/tr>
\n    <tr>
\n        <td>\uc8fc\ubbfc\ubc88\ud638<\/td>
\n        <td><input type=”text” name=”jumin1″ size=”6″ maxlength=”6″>-<input
\n            type=”password” name=”jumin2″ size=”7″ maxlength=”7″><br \/>
\n        <\/td>
\n    <\/tr>
\n    <tr>
\n        <td>\uc6b0\ud3b8\ubc88\ud638<\/td>
\n        <td><input type=”text” name=”zipcode” maxlength=”7″><br \/>
\n        <\/td>
\n    <\/tr>
\n    <tr>
\n        <td>\uc8fc\uc18c<\/td>
\n        <td><input type=”text” name=”address1″ size=”40″><br \/>
\n        <\/td>
\n    <\/tr>
\n    <tr>
\n        <td>\uc0c1\uc138\uc8fc\uc18c<\/td>
\n        <td><input type=”text” name=”address2″ size=”40″><br \/>
\n        <\/td>
\n    <\/tr>
\n    <tr>
\n        <td>\uc774\uba54\uc77c<\/td>
\n        <td><input type=”text” name=”email”><br \/>
\n        <\/td>
\n    <\/tr>
\n    <tr>
\n        <td>\uc9c1\uc5c5<\/td>
\n        <td><select name=”job”>
\n            <option>\ud559\uc0dd<\/option>
\n            <option>\ud68c\uc0ac\uc6d0<\/option>
\n            <option>\uad50\uc9c1\uc6d0<\/option>
\n            <option>\uacf5\ubb34\uc6d0<\/option>
\n            <option>\uc8fc\ubd80<\/option>
\n            <option>\uae30\ud0c0<\/option>
\n        <\/select><br \/>
\n        <\/td>
\n    <\/tr>
\n    <tr>
\n        <td>\uc790\uae30\uc18c\uac1c<\/td>
\n        <td><textarea name=”intro” cols=”25″ rows=”5″><\/textarea> <br \/>
\n        <\/td>
\n    <\/tr>
\n    <tr>
\n        <td><input type=”submit” value=”\ub4f1\ub85d” \/> <input type=”reset”
\n            value=”\ucde8\uc18c” \/><\/td>
\n    <\/tr>
\n<\/table>
\n<\/form>
\n<\/body>
\n<\/html>\n<\/div>\n

<\/span><\/span><\/font><\/div>\n

\n\n<\/div>\n

addMember.php<\/p>\n

\n
\n<\/div>\n
\n
\n<?php<\/div>\n
\n\/* <\/div>\n
\n * To change this template, choose Tools | Templates<\/div>\n
\n * and open the template in the editor.<\/div>\n
\n *\/<\/div>\n
\n\n<\/div>\n
\n$userid   = $_POST[“userid”];<\/div>\n
\n$password = $_POST[“password”];<\/div>\n
\n$username = $_POST[“username”];<\/div>\n
\n$jumin1   = $_POST[“jumin1”];<\/div>\n
\n$jumin2   = $_POST[“jumin2”];<\/div>\n
\n$zipcode  = $_POST[“zipcode”];<\/div>\n
\n$address1 = $_POST[“address1”];<\/div>\n
\n$address2 = $_POST[“address2”];<\/div>\n
\n$email    = $_POST[“email”];<\/div>\n
\n$job      = $_POST[“job”];<\/div>\n
\n$intro    = $_POST[“intro”];<\/div>\n
\n\n<\/div>\n
\n$dbHost = “localhost”;<\/div>\n
\n$dbUser = “dbuser”;<\/div>\n
\n$dbpass = “dbpass”;<\/div>\n
\n$dbName = “dbname”;<\/div>\n
\n\n<\/div>\n
\n$sql    = “INSERT INTO php_member<\/div>\n
\n           (userid, password, username, jumin1, jumin2, <\/div>\n
\n            zipcode, address1, address2, email, job, intro)<\/div>\n
\n           VALUES<\/div>\n
\n           (‘$userid’, ‘$password’, ‘$username’, ‘$jumin1’, ‘$jumin2’, <\/div>\n
\n            ‘$zipcode’, ‘$address1’, ‘$address2’, ‘$email’, ‘$job’, ‘$intro’)”;<\/div>\n
\n\n<\/div>\n
\n$dbConn = mysql_connect($dbHost, $dbUser, $dbpass);<\/div>\n
\nmysql_select_db($dbName, $dbConn);<\/div>\n
mysql_set_charset(“utf8”);<\/div>\n
\nmysql_query($sql, $dbConn);<\/div>\n
\nmysql_close($dbConn)<\/div>\n
\n?><\/div>\n<\/div>\n
\n<\/div>\n
\n\n<\/div>\n
\n\n<\/div>\n<\/div>\n
\n\n<\/div>\n","protected":false},"excerpt":{"rendered":"

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\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[241],"tags":[40,53],"class_list":["post-3261","post","type-post","status-publish","format-standard","hentry","category-php","tag-php","tag-webdb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p776QY-QB","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/3261","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/comments?post=3261"}],"version-history":[{"count":0,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/3261\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media?parent=3261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/categories?post=3261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/tags?post=3261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}