{"id":3539,"date":"2011-07-25T03:43:36","date_gmt":"2011-07-25T03:43:36","guid":{"rendered":"http:\/\/www.happyfam.or.kr\/ysoh\/%ed%9a%8c%ec%9b%90%ea%b0%80%ec%9e%851\/"},"modified":"2015-02-10T21:11:45","modified_gmt":"2015-02-10T12:11:45","slug":"%ed%9a%8c%ec%9b%90%ea%b0%80%ec%9e%851","status":"publish","type":"post","link":"http:\/\/www.happyfam.or.kr\/ysoh\/%ed%9a%8c%ec%9b%90%ea%b0%80%ec%9e%851\/","title":{"rendered":"\ud68c\uc6d0\uac00\uc785 #1"},"content":{"rendered":"<p>\uc0ac\uc6a9\ud568\uc218<\/p>\n<p>&#8211; mysql_connect(String $hostname, String $userid, String $password)<br \/>PHP \ud504\ub85c\uadf8\ub7a8\uacfc \ub370\uc774\ud130\ubca0\uc774\uc2a4(MySQL) \uc11c\ubc84\uc640\uc758 \uc5f0\ub3d9\uc744 \uc704\ud55c \ud568\uc218\ub85c PHP \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub0b4\uc6a9\uc744 \uc870\uc801(\uac80\uc0c9, \uc218\uc815, \uc0ad\uc81c, \ucd94\uac00 \ub4f1)\ud558\ub824\uba74 \ubc18\ub4dc\uc2dc \uc774 \ud568\uc218\ub97c \uac00\uc7a5 \uba3c\uc800 \uc2e4\ud589\ud574\uc57c \ud55c\ub2e4. \uc774 \ud568\uc218\ub97c \uc2e4\ud589\ud558\ub824\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc758 \uc774\ub984($hostname), \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 \uc544\uc774\ub514($userid), \uadf8\ub9ac\uace0 \uc0ac\uc6a9\uc790 \ube44\ubc00\ubc88\ud638($password)\uac00 \uc8fc\uc5b4\uc838\uc57c \ud558\uba70, \uc131\uacf5\uc801\uc73c\ub85c \uc218\ud589\ub418\uba74 \uace0\uc720\ud55c \uc5f0\uacb0 \uc2dd\ubcc4\uac12\uc744 \ubc18\ud658\ud558\uace0 \uc2e4\ud328\ud560 \uacbd\uc6b0 FALSE \uac12\uc744 \ubc18\ud658\ud55c\ub2e4. <\/p>\n<p>&#8211; mysql_select_db(String $dbname, resource $linkid)<br \/>mysql_connect \ud568\uc218\uc5d0 \uc758\ud574 \uc131\uacf5\uc801\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc640\uc758 \uc5f0\uacb0\uc774 \uc774\ub8e8\uc5b4\uc9c0\uba74 \uc774 \uc5f0\uacb0($link)\uc5d0\uc11c \uc0ac\uc6a9 \uac00\ub2a5\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4($dbname)\ub97c \uc120\ud0dd\ud55c\ub2e4. \uc8fc\uc5b4\uc9c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc120\ud0dd\uc774 \uc131\uacf5\ud560 \uacbd\uc6b0 TRUE\ub97c \uc2e4\ud328\ud560 \uacbd\uc6b0 FALSE\ub97c \ubc18\ud658\ud55c\ub2e4.<\/p>\n<p>&#8211; mysql_query(String $sql, resource $linkid)<br \/>\ud604\uc7ac \uc5f0\uacb0($linkid)\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \uc9c8\uc758($sql)\ub97c \uc804\uc1a1 \uc2e4\ud589\ud55c\ub2e4. \uc2e4\ud589 \uacb0\uacfc\ub294 SELECT, SHOW, DESCRIBE, EXPLAIN \ub4f1\uacfc \uac19\uc774 \uacb0\uacfc\uc14b\uc744 \ubc18\ud658\ud558\ub294 \uc9c8\uc758\uc758 \uacbd\uc6b0, \uc9c8\uc758 \uc2e4\ud589\uc774 \uc131\uacf5\ud558\uba74 \uadf8 \uacb0\uacfc\ub97c \ubc18\ud658\ud558\uace0 \uc2e4\ud328\ud558\uba74 FALSE\ub97c \ubc18\ud658\ud55c\ub2e4. \uadf8\ub9ac\uace0 UPDATE, DELETE, INSERT, DROP \ub4f1\uc758 \ub2e4\ub978 \ud615\ud0dc\uc758 \uc9c8\uc758\uc758 \uacbd\uc6b0 \uc2e4\ud589\uc5d0 \uc131\uacf5\ud558\uba74 TRUE\ub97c \uc2e4\ud328\ud558\uba74 FALSE\ub97c \ubc18\ud658\ud55c\ub2e4.<\/p>\n<p>&#8211; mysql_close(resource $linkid)<br \/>\ud604\uc7ac \uc5f0\uacb0($linkid)\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc811\uc18d\uc744 \uc885\ub8cc\ud55c\ub2e4. \uc885\ub8cc \ud6c4\uc5d0 \ub2e4\uc2dc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc870\uc791\uc744 \ud558\ub824\uba74 \ubc18\ub4dc\uc2dc mysql_connect\ud568\uc218\ub97c \uc2e4\ud589\ud574\uc57c \uc870\uc791\ud560 \uc218 \uc788\ub2e4. \uc2e4\ud589 \uacb0\uacfc\ub294 \uc811\uc18d\uc885\ub8cc\uc5d0 \uc131\uacf5\ud560 \uacbd\uc6b0 TRUE\ub97c, \uc2e4\ud328\ud560 \uacbd\uc6b0 FLASE\ub97c \ubc18\ud658\ud55c\ub2e4.<\/p>\n<p>php_member.sql<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.happyfam.or.kr\/ysoh\/wp-content\/uploads\/sites\/3\/1\/cfile29.uf.131E03444E5B15BB29B6AC.png?resize=600%2C224\" class=\"aligncenter\" width=\"600\" height=\"224\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/>addForm.php(\uc800\uc7a5\uacbd\ub85c : ~\/public_html\/php\/member\/1)<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.happyfam.or.kr\/ysoh\/wp-content\/uploads\/sites\/3\/1\/cfile1.uf.123B5E374E5B15BB24B774.png?resize=600%2C970\" class=\"aligncenter\" width=\"600\" height=\"970\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/>addMember.php(\uc800\uc7a5\uacbd\ub85c : ~\/public_html\/php\/member\/1)<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.happyfam.or.kr\/ysoh\/wp-content\/uploads\/sites\/3\/1\/cfile29.uf.1754F3434E5B15BC24F1E7.png?resize=600%2C565\" class=\"aligncenter\" width=\"600\" height=\"565\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.happyfam.or.kr\/ysoh\/wp-content\/uploads\/sites\/3\/1\/cfile30.uf.15225A3B4E5B15BB275CE9.png?resize=494%2C386\" class=\"aligncenter\" width=\"494\" height=\"386\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.happyfam.or.kr\/ysoh\/wp-content\/uploads\/sites\/3\/1\/cfile25.uf.202828444E5B15BC0F4195.png?resize=494%2C386\" class=\"aligncenter\" width=\"494\" height=\"386\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc0ac\uc6a9\ud568\uc218 &#8211; mysql_connect(String $hostname, String $userid, String $password)PHP \ud504\ub85c\uadf8\ub7a8\uacfc \ub370\uc774\ud130\ubca0\uc774\uc2a4(MySQL) \uc11c\ubc84\uc640\uc758 \uc5f0\ub3d9\uc744 \uc704\ud55c \ud568\uc218\ub85c PHP \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub0b4\uc6a9\uc744 \uc870\uc801(\uac80\uc0c9, \uc218\uc815, \uc0ad\uc81c, \ucd94\uac00 \ub4f1)\ud558\ub824\uba74 \ubc18\ub4dc\uc2dc \uc774 \ud568\uc218\ub97c \uac00\uc7a5 \uba3c\uc800 \uc2e4\ud589\ud574\uc57c \ud55c\ub2e4. \uc774 \ud568\uc218\ub97c \uc2e4\ud589\ud558\ub824\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc758 \uc774\ub984($hostname), \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 \uc544\uc774\ub514($userid), \uadf8\ub9ac\uace0 \uc0ac\uc6a9\uc790 \ube44\ubc00\ubc88\ud638($password)\uac00 \uc8fc\uc5b4\uc838\uc57c \ud558\uba70, \uc131\uacf5\uc801\uc73c\ub85c \uc218\ud589\ub418\uba74 \uace0\uc720\ud55c \uc5f0\uacb0 \uc2dd\ubcc4\uac12\uc744 \ubc18\ud658\ud558\uace0 \uc2e4\ud328\ud560 \uacbd\uc6b0 FALSE \uac12\uc744 \ubc18\ud658\ud55c\ub2e4.\u2026 <span class=\"read-more\"><a href=\"http:\/\/www.happyfam.or.kr\/ysoh\/%ed%9a%8c%ec%9b%90%ea%b0%80%ec%9e%851\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":3,"featured_media":3540,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_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},"jetpack_post_was_ever_published":false},"categories":[259],"tags":[34,40,129],"class_list":["post-3539","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-webdb","tag-mysql","tag-php","tag-129"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.happyfam.or.kr\/ysoh\/wp-content\/uploads\/sites\/3\/1\/cfile29.uf.131E03444E5B15BB29B6AC.png?fit=600%2C224","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p776QY-V5","jetpack-related-posts":[],"_links":{"self":[{"href":"http:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/3539","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/comments?post=3539"}],"version-history":[{"count":0,"href":"http:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/3539\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media\/3540"}],"wp:attachment":[{"href":"http:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media?parent=3539"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/categories?post=3539"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/tags?post=3539"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}