{"id":2235,"date":"2014-09-03T12:45:09","date_gmt":"2014-09-03T03:45:09","guid":{"rendered":"http:\/\/www.happyfam.or.kr\/ysoh\/?p=2235"},"modified":"2016-06-01T11:36:08","modified_gmt":"2016-06-01T02:36:08","slug":"webdbii-%ec%8b%a4%ec%8a%b5%ec%98%88%ec%a0%9c-%ec%86%8c%ec%8a%a4-1","status":"publish","type":"post","link":"https:\/\/www.happyfam.or.kr\/ysoh\/webdbii-%ec%8b%a4%ec%8a%b5%ec%98%88%ec%a0%9c-%ec%86%8c%ec%8a%a4-1\/","title":{"rendered":"WebDB(II) \uc2e4\uc2b5\uc608\uc81c \uc18c\uc2a4 #1"},"content":{"rendered":"<p>WebDB(II) \uc2dc\uac04\uc5d0 \uc785\ub825\ud55c \uc608\uc81c\ud504\ub85c\uadf8\ub7a8\ub4e4 \uc785\ub2c8\ub2e4.<\/p>\n<pre class=\"lang:php decode:true\" title=\"examSQL.php\">&lt;?php\r\n\r\n$link = mysqli_connect(\"localhost\", \"i0058001\", \"yourPassword\"); \/\/ MySQL \uc11c\ubc84 \uc5f0\uacb0\r\nmysqli_select_db($link, \"db0058001\"); \/\/ Database \uc120\ud0dd\r\nmysqli_set_charset($link, \"utf8\"); \/\/ DB \ubb38\uc790\uc14b \uc124\uc815\r\n\r\n$sql = \"\";\r\n\r\nmysqli_query($link, $sql); \/\/ SQL \uc2e4\ud589\r\nmysqli_close($link); \/\/ MySQL \uc5f0\uacb0 \uc885\ub8cc\r\n?&gt;<\/pre>\n<pre class=\"lang:php decode:true\" title=\"dbConn.php\">&lt;?php\r\n$dbHost = \"localhost\";\r\n$dbName = \"db0058001\";\r\n$dbUser = \"i0058001\";\r\n$dbPass = \"yourPassword\"\r\n?&gt;<\/pre>\n<pre class=\"lang:php decode:true \" title=\"examSQL2.php\">&lt;?php\r\nrequire '.\/dbConn.php';\r\n\r\n$link = mysqli_connect($dbHost, $dbUser, $dbPass); \/\/ MySQL \uc11c\ubc84 \uc5f0\uacb0\r\nmysqli_select_db($link, $dbName); \/\/ Database \uc120\ud0dd\r\nmysqli_set_charset($link, \"utf8\"); \/\/ DB \ubb38\uc790\uc14b \uc124\uc815\r\n\r\n$sql = \"DROP TABLE `user`;\";\r\n\r\necho $sql;\r\n\r\nmysqli_query($link, $sql); \/\/ SQL \uc2e4\ud589\r\nmysqli_close($link); \/\/ MySQL \uc5f0\uacb0 \uc885\ub8cc\r\n?&gt;<\/pre>\n<pre class=\"lang:mysql decode:true \" title=\"SQL \uc0d8\ud50c \uc608\uc81c\">CREATE   TABLE   `user`   (\r\n  `userid`   varchar(20)   NOT   NULL,\r\n  `passwd`   varchar(128)   NOT   NULL,\r\n  `name`   varchar(20)   NOT   NULL,\r\n  `email`   varchar(50)   NOT   NULL,\r\n  PRIMARY   KEY (`userid`)\r\n)   ENGINE=InnoDB   DEFAULT   CHARSET=utf8;\r\n\r\nDROP TABLE `user`;\r\n\r\nINSERT   INTO   `user`\r\n(`userid`,   `name`)\r\nVALUES\r\n('test01',   '\ud64d\uae38\ub3d9')\r\n\r\nINSERT INTO `user`\r\nVALUES\r\n('test01',   '1111',   '\ud64d\uae38\ub3d9',   'test01@test.com');\r\n\r\nINSERT   INTO   `user`\r\n(`userid`,  `name`,  `passwd`,  `email`)\r\nVALUES\r\n('test02',  '\uae40\ucca0\uc218',  password('1234'),  'test02@test.com');\r\n\r\nINSERT   INTO   `user`\r\nVALUES\r\n('test03',  '3333',  '\uae40\ucca0\uc218',  'test03@daum.net'),\r\n('test04',  '4444',  '\ud64d\uba85\ubcf4',  'test04@daum.net');\r\n\r\nINSERT   INTO   `user`\r\n(`userid`,  `passwd`,  `name`,  `email`)\r\nVALUES\r\n('test05',  password('3333'),  '\uae40\ub300\uc911',  'test05@naver.com'), \r\n('test06',  password('4444'),  '\uae40\uc601\uc0bc',  'test06@naver.com');\r\n\r\nSELECT  `userid`,  `name`\r\nFROM  `user`;\r\n\r\nSELECT  *\r\nFROM  `user`;\r\n\r\nSELECT  *  \r\nFROM  `user`  \r\nWHERE  `name` = '\ud64d\uae38\ub3d9';\r\n\r\nSELECT  *  \r\nFROM  `user`  \r\nWHERE  `age`  BETWEEN  20  AND  30;\r\n\r\nSELECT  *  \r\nFROM  `user`  \r\nWHERE  `age`  &gt;=  20  \r\nAND  `age`  &lt;=  30;\r\n\r\nSELECT  *  \r\nFROM  `user`  \r\nWHERE  `name`  IN  ( '\ud64d\uae38\ub3d9',  '\uae40\ucca0\uc218',  '\uc804\uc6b0\uce58' );\r\n\r\nSELECT  *  \r\nFROM  `user`  \r\nWHERE  `name`  =  '\ud64d\uae38\ub3d9'  \r\nOR  `name`  =  '\uae40\ucca0\uc218'  \r\nOR  `name`  =  '\uc804\uc6b0\uce58';\r\n\r\nSELECT  *  \r\nFROM  `user`  \r\nWHERE  `name`  LIKE  '\ud64d%';\r\n\r\nSELECT  *  \r\nFROM  `user`  \r\nWHERE  `userid`  LIKE  't_____';\r\n\r\nSELECT  *  \r\nFROM  `user`  \r\nWHERE  `email`  LIKE  '%.com';\r\n\r\nSELECT  *  \r\nFROM  `user`  \r\nWHERE  `email`  LIKE  '%naver%';\r\n\r\nSELECT  *  \r\nFROM  `user`  \r\nORDER  BY  `name` ,  `userid`;\r\n\r\nSELECT  DISTINCT  `name`,  `email`\r\nFROM  `user`;\r\n\r\nSELECT  COUNT(`userid`),  `name`  \r\nFROM  `user`  \r\nGROUP  BY  `name`;\r\n\r\nSELECT  * \r\nFROM  `user`  \r\nLIMIT  1,  3;\r\n\r\nUPDATE  `user`  \r\nSET  `name`  =  '\uace0\uae38\ub3d9'  \r\nWHERE  `userid`  =  'test05';\r\n\r\nUPDATE `user`\r\nSET `age` = `age` + 1\r\n\r\nUPDATE `user`\r\nSET `name` =  '\ud64d\uae38\ub3d9', `age` = `age` + 1\r\nWHERE  `userid`  =  'test05';\r\n\r\nDELETE  \r\nFROM  `user`  \r\nWHERE  `userid`  =  'test05';\r\n\r\nDELETE\r\nFROM  `user`;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>WebDB(II) \uc2dc\uac04\uc5d0 \uc785\ub825\ud55c \uc608\uc81c\ud504\ub85c\uadf8\ub7a8\ub4e4 \uc785\ub2c8\ub2e4. &lt;?php $link = mysqli_connect(&#8220;localhost&#8221;, &#8220;i0058001&#8221;, &#8220;yourPassword&#8221;); \/\/ MySQL \uc11c\ubc84 \uc5f0\uacb0 mysqli_select_db($link, &#8220;db0058001&#8221;); \/\/ Database \uc120\ud0dd mysqli_set_charset($link, &#8220;utf8&#8221;); \/\/ DB \ubb38\uc790\uc14b \uc124\uc815 $sql = &#8220;&#8221;; mysqli_query($link, $sql); \/\/ SQL \uc2e4\ud589 mysqli_close($link); \/\/ MySQL \uc5f0\uacb0 \uc885\ub8cc ?&gt; &lt;?php $dbHost = &#8220;localhost&#8221;; $dbName = &#8220;db0058001&#8221;; $dbUser = &#8220;i0058001&#8221;; $dbPass = &#8220;yourPassword&#8221; ?&gt; &lt;?php\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.happyfam.or.kr\/ysoh\/webdbii-%ec%8b%a4%ec%8a%b5%ec%98%88%ec%a0%9c-%ec%86%8c%ec%8a%a4-1\/\">Read More &raquo;<\/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":[134,2],"tags":[233,21,34,40,53],"class_list":["post-2235","post","type-post","status-publish","format-standard","hentry","category-webdbii","category-2","tag-database","tag-html","tag-mysql","tag-php","tag-webdb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p776QY-A3","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/2235","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=2235"}],"version-history":[{"count":0,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/2235\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media?parent=2235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/categories?post=2235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/tags?post=2235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}