{"id":19194,"date":"2022-07-28T03:45:40","date_gmt":"2022-07-27T18:45:40","guid":{"rendered":"http:\/\/hyunsik.me\/wordpress\/?p=19194"},"modified":"2023-06-11T05:19:07","modified_gmt":"2023-06-10T20:19:07","slug":"%ed%9a%8c%ec%82%ac%ec%9d%98-%eb%a7%a4%eb%8b%88%ec%a7%80%eb%a8%bc%ed%8a%b8-%ec%8b%9c%ec%8a%a4%ed%85%9c-%ec%9d%b4%ec%a0%84-%eb%ac%b4%ec%82%ac%ed%9e%88-%eb%a7%88%ec%b9%98%eb%a9%b0","status":"publish","type":"post","link":"http:\/\/hyunsik.me\/wordpress\/?p=19194","title":{"rendered":"\ud68c\uc0ac\uc758 \ub9e4\ub2c8\uc9c0\uba3c\ud2b8 \uc2dc\uc2a4\ud15c(WMS) \uc774\uc804 &#8211; \ubb34\uc0ac\ud788 \ub9c8\uce58\uba70"},"content":{"rendered":"<p><img style=\"border: 1px solid grey;\" src=\"http:\/\/hyunsik.me\/wordpress\/wp-content\/uploads\/2022\/07\/20220728_034834-1024x283.png\" alt=\"\" width=\"100%\" \/><\/p>\n<p>\ud68c\uc0ac\uc758 \ub9e4\ub2c8\uc9c0\uba3c\ud2b8 \uc2dc\uc2a4\ud15c\uc744 \ube44\uc988\ud504\ub9ac \ud638\uc2a4\ud305(\uad6c \ud30c\ub780 \ud638\uc2a4\ud305)\uc5d0\uc11c \uce74\ud39824 \ud638\uc2a4\ud305\uc73c\ub85c \uc774\uc804\ud588\ub2e4. \uc774\uc804 \uacfc\uc815\uc758 \ubcf5\uc7a1\ud568\uc774 \uc2eb\uc5b4\uc11c \uc9c0\uae08\uae4c\uc9c0 \ubc84\ud17c\uc9c0\ub9cc, \ube44\uc988\ud504\ub9ac \ud638\uc2a4\ud305\uc774 \uc774\uc81c \uc544\uc8fc \uc5c6\uc5b4\uc9c4\ub2e4\uace0 \ud55c\ub2e4. \uadf8 \ub54c\ubb38\uc5d0 \uc5b4\uca54 \uc218 \uc5c6\uc5c8\ub2e4.<\/p>\n<p>[line][\/line]<\/p>\n<p><strong style=\"font-size: 17pt; color: blue;\">[1] DB \uc758 \uc774\uc804<\/strong><\/p>\n<p>\uccab \ubc88\uc9f8 \ub09c\uc81c\ub294 DB\ub97c \uc62e\uae30\ub294 \uac83\uc774\uc5c8\ub2e4. &lt;phpMyAdmin&gt;\uc744 \uc774\uc6a9\ud558\uc5ec \ud14c\uc774\ube14 \ub2e8\uc704\ub85c &#8216;\ub0b4\ubcf4\ub0b4\uae30&#8217;\ub97c \uc9c4\ud589\ud588\ub2e4. SQL\ud30c\uc77c\ub85c \ub0b4\ubcf4\ub0b4\ub294 \uac83\uc740 \uc26c\uc6e0\ub2e4. \ud558\uc9c0\ub9cc \ud14c\uc774\ube14\uc758 \uc6a9\ub7c9\uc774 100MB\ub97c \ucd08\uacfc\ud560 \uacbd\uc6b0 \uc758 &#8216;\uac00\uc838\uc624\uae30&#8217;\ub97c \ud1b5\ud574 SQL\ud30c\uc77c\uc744 \uac00\uc838\uc62c \uc218 \uc5c6\uc5c8\ub2e4.<\/p>\n<p>\ubb34\ub824 15\ub144 \uc804\uc5d0 \uc0ac\uc6a9\ud588\ub358 &lt;Navicat&gt;\uc774 \uc0dd\uac01\ub0ac\ub2e4. 14\uc77c\uac04 \ubb34\ub8cc \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud588\ub2e4. &lt;Navicat&gt;\uc744 \uc774\uc6a9\ud558\uc5ec \uac00\uc838\uc628 SQL\ud30c\uc77c\uc744 \uc2e4\ud589\ud558\uc5ec, \ud544\uc694\ud55c \ud14c\uc774\ube14\uc744 \uc190\uc27d\uac8c \ubcf5\uc0ac\ud560 \uc218 \uc788\uc5c8\ub2e4. \uc88b\uc558\ub2e4.<\/p>\n<ul>\n<li>\ube44\uc988\ud504\ub9ac\ub294 &lt;MySQL&gt;\uc744 \uc0ac\uc6a9\ud558\uace0, \uce74\ud39824\ub294 &lt;mariaDB&gt;\ub97c \uc0ac\uc6a9\ud55c\ub2e4. &lt;Navicat&gt;\uc5d0\uc11c \ub2e8\uc21c\ud788 \uce74\ud39824\uc758 DB\ub97c &lt;mariaDB&gt;\ub85c \uc124\uc815\ud574\uc900 \uac83 \uc678\uc5d0\ub294, DB\uc640 \uad00\ub828\ud558\uc5ec \uc5b4\ub5a4 \ubcc0\uacbd\ub3c4 \ud558\uc9c0 \uc54a\uc558\ub2e4. \ub3d9\uc77c\ud55c \uac83\uc778\uc9c0, \ud638\ud658\uc774 100%\uc778 \uac83\uc778\uc9c0 \uc54c \uc218\uac00 \uc5c6\ub2e4. \uc5b4\uca0c\ub4e0 \ub9e4\uc6b0 \ub2e4\ud589\uc774\uc5c8\ub2e4.<\/li>\n<li>\uc544\ub9c8 &lt;Navicat&gt;\uc5d0\uc11c &lt;MySQL&gt;\ub85c \uc124\uc815\ud574\ub3c4 \ubb38\uc81c\uac00 \uc5c6\uc744 \uac83 \uac19\ub2e4. <\/li>\n<\/ul>\n<p><strong style=\"font-size: 17pt; color: blue;\">[2] PHP \ud30c\uc77c\uc758 \uc218\uc815<\/strong><\/p>\n<p>\uc5d0\ub514\ud130\ub294 &lt;Atom&gt;\uc744 \uc0ac\uc6a9\ud588\ub2e4. \ucd5c\uace0\ub294 \uc544\ub2c8\uc9c0\ub9cc, \uc218\uc815 \uc791\uc5c5\uc5d0 \ub098\uc060 \uac83\uc740 \uc5c6\uc5c8\ub2e4. <\/p>\n<p>\uc774\ubc88 \uc774\uc804 \uc791\uc5c5\uc740 DB\ub9cc \uc798 \uac00\uc838\uc624\uba74, \uc5b4\ub5a4 \uc218\uc815\ub3c4 \uc5c6\uc774 \uc2dc\uc2a4\ud15c\uc774 \uadf8\ub300\ub85c \ub3d9\uc791\ud560 \uac83\uc774\ub77c\uace0 \uc0dd\uac01\ud588\ub2e4. \ud558\uc9c0\ub9cc \uc774 \uc0dd\uac01\uc740 \uc870\uae08 \ud2c0\ub838\ub2e4.<\/p>\n<p>\ubc14\ub85c &#8216;mysqli&#8217;\ub77c\ub294 \uc0c8\ub85c\uc6b4 \ub4dc\ub77c\uc774\ubc84\uc758 \ub4f1\uc7a5\uc774\uc5c8\ub2e4. DB\uc758 \uc5f0\uacb0\ubd80\uac00 \uc644\uc804\ud788 \ubcc0\ud55c \uac83\uc774\ub2e4. \ub3c4\ub300\uccb4 \uc5bc\ub9c8\ub098 \ub300\ub2e8\ud558\uae38\ub798 \ud568\uc218 \uc774\ub984\uc744 \ubc14\uafc0 \uc815\ub3c4\uc600\ub294\uc9c0 \ubaa8\ub974\uaca0\ub2e4. \uc774 \ubd80\ubd84\uc744 \uc218\uc815\ud558\ub294 \uac83\uc774 \uc2dc\uac04\uc774 \uc880 \uac78\ub838\ub2e4. DB \uad00\ub828\ud55c \ubd80\ubd84\uc740 \ubaa8\ub450 class\ud654 \ud574\ub193\uc544\uc11c \ube60\ub974\uac8c \uc218\uc815\ud560 \uc218 \uc788\uc5c8\uc9c0\ub9cc, \uadf8 \ubc16\uc5d0\ub3c4 \uc218\uc815\ud560 \ubd80\ubd84\uc774 \ub9ce\uc558\ub2e4.<\/p>\n<p>\ub300\ubd80\ubd84\uc758 \ud568\uc218\uc5d0\uc11c \uc0c8\ub86d\uac8c DB \ucee4\ub125\uc158\uc744 \ud30c\ub77c\uba54\ud130\ub85c \uc694\uad6c\ud588\ub2e4. \uc608\ub97c \ub4e4\uba74 &#8216;mysql_insert_id()&#8217;\ub77c\uace0 \uc4f0\uba74 \ub410\ub358 \uac83\uc774, \uc774\uc81c\ub294 &#8216;mysqli_insert_id($\ucee4\ub125\uc158)&#8217;\uc774\ub77c\uace0 \uc368\uc57c \ud55c\ub2e4. \uc774\ub7f0 \ubd80\ubd84\ub4e4\uc5d0 \ub300\ud574 \ud074\ub798\uc2a4\ub97c \uc218\uc815\ud574\uc11c \ub2e4\uac00\uac00\uc57c \ud558\ub294\uc9c0, \uc544\ub2c8\uba74 \ub2e4\ub978 \ubc29\ubc95\uc73c\ub85c \ub2e4\uac00\uac00\uc57c \ud558\ub294\uc9c0 \uace0\ubbfc\ud558\uba70 \uc9c4\ud589\ud558\uac8c \ub418\uc5c8\ub2e4. \ud2b9\ud788 &#8216;mysqli_real_escape_string&#8217;\uc744 \uc801\uc6a9\ud560 \ub54c\ub294 \ub354\uc6b1 \ud53c\uace4\ud588\ub358 \uac83 \uac19\ub2e4.<\/p>\n<ul>\n<li>&#8216;mysqli&#8217;\ub294 \uc774\ubbf8 \uc0c1\ub2f9\ud788 \uc624\ub798 \uc804\uc5d0 \ub098\uc628 \uac83\uc73c\ub85c \ud655\uc778\ub41c\ub2e4. \ub098\ub9cc \uc0c8\ub85c\uc6b4 \uac83\uc774\ub2e4.<\/li>\n<\/ul>\n<p>[line][\/line]<\/p>\n<p>\ucd5c\ucd08\uc5d0 \uc0dd\uac01\ud588\ub358 \uac83\uc5d0 \ube44\ud574\uc11c\ub294 \ud6e8\uc52c \ub2e8\uc21c\ud55c \uc791\uc5c5\uc774\uc5c8\ub2e4. \uac00\ub054\uc758 \ud504\ub85c\uadf8\ub798\ubc0d, \uc790\uc874\uac10\uc744 \uc9c0\ucf1c\uc900\ub2e4. \uc9c4\uc2ec\uc73c\ub85c \uc990\uac70\uc6e0\ub2e4. Good!<\/p>\n<p><iframe title=\"[BE ORIGINAL] CHUNG HA(\uccad\ud558) 'Sparkling' (4K)\" src=\"https:\/\/www.youtube.com\/embed\/IIP_kibV7cw\" width=\"580\" height=\"300\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud68c\uc0ac\uc758 \ub9e4\ub2c8\uc9c0\uba3c\ud2b8 \uc2dc\uc2a4\ud15c\uc744 \ube44\uc988\ud504\ub9ac \ud638\uc2a4\ud305(\uad6c \ud30c\ub780 \ud638\uc2a4\ud305)\uc5d0\uc11c \uce74\ud39824 \ud638\uc2a4\ud305\uc73c\ub85c \uc774\uc804\ud588\ub2e4. \uc774\uc804 \uacfc\uc815\uc758 \ubcf5\uc7a1\ud568\uc774 \uc2eb\uc5b4\uc11c \uc9c0\uae08\uae4c\uc9c0 \ubc84\ud17c\uc9c0\ub9cc, \ube44\uc988\ud504\ub9ac \ud638\uc2a4\ud305\uc774 \uc774\uc81c \uc544\uc8fc \uc5c6\uc5b4\uc9c4\ub2e4\uace0 \ud55c\ub2e4. \uadf8 \ub54c\ubb38\uc5d0 \uc5b4\uca54 \uc218 \uc5c6\uc5c8\ub2e4. [line][\/line] [1] DB \uc758 \uc774\uc804 \uccab \ubc88\uc9f8 \ub09c\uc81c\ub294 DB\ub97c \uc62e\uae30\ub294 \uac83\uc774\uc5c8\ub2e4. &lt;phpMyAdmin&gt;\uc744 \uc774\uc6a9\ud558\uc5ec \ud14c\uc774\ube14 \ub2e8\uc704\ub85c &#8216;\ub0b4\ubcf4\ub0b4\uae30&#8217;\ub97c \uc9c4\ud589\ud588\ub2e4. SQL\ud30c\uc77c\ub85c \ub0b4\ubcf4\ub0b4\ub294 \uac83\uc740 \uc26c\uc6e0\ub2e4. \ud558\uc9c0\ub9cc \ud14c\uc774\ube14\uc758 \uc6a9\ub7c9\uc774 100MB\ub97c \ucd08\uacfc\ud560 \uacbd\uc6b0 \uc758 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"spay_email":""},"categories":[176],"tags":[2943,130,2944,2942,2850,2228,448,1536,632],"jetpack_featured_media_url":"","views":"","jetpack-related-posts":[],"_links":{"self":[{"href":"http:\/\/hyunsik.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/19194"}],"collection":[{"href":"http:\/\/hyunsik.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/hyunsik.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/hyunsik.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/hyunsik.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19194"}],"version-history":[{"count":24,"href":"http:\/\/hyunsik.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/19194\/revisions"}],"predecessor-version":[{"id":21715,"href":"http:\/\/hyunsik.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/19194\/revisions\/21715"}],"wp:attachment":[{"href":"http:\/\/hyunsik.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/hyunsik.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19194"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/hyunsik.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}