{"id":1449,"date":"2013-12-13T09:37:51","date_gmt":"2013-12-13T09:37:51","guid":{"rendered":"http:\/\/brain.payzip.co.kr\/?p=1449"},"modified":"2013-12-13T09:37:51","modified_gmt":"2013-12-13T09:37:51","slug":"%ec%9c%84%eb%8f%84-%ea%b2%bd%eb%8f%84-%eb%b0%98%ea%b2%bd%eb%82%b4-%ed%8f%ac%ed%95%a8%ed%95%9c-%ec%a0%95%eb%b3%b4","status":"publish","type":"post","link":"https:\/\/blog.goorigo.com\/?p=1449","title":{"rendered":"\uc704\ub3c4, \uacbd\ub3c4 \ubc18\uacbd\ub0b4 \ud3ec\ud568\ud55c \uc815\ubcf4"},"content":{"rendered":"

1. \ub124\uc774\ubc84 \uc9c0\ub3c4 API\uc5d0\uc11c \uacbd\ub3c4, \uc704\ub3c4 \ubc1b\uc544\uc624\uae30
\n\uc6b0\uc120 \ub124\uc774\ubc84 \uc9c0\ub3c4 API\ub97c \uc774\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 Key\ub97c \ub4f1\ub85d\ud574\uc57c \ud55c\ub2e4.
\nhttp:\/\/dev.naver.com\/openapi\/register<\/a>\u00a0\uc5d0 \uc811\uc18d\ud55c\ub2e4. \ub85c\uadf8\uc778\uc774 \ub418\uc5b4\uc57c \uc815\uc0c1\uc801\uc73c\ub85c \uc774\uc6a9\ud560 \uc218 \uc788\ub2e4.
\n\uadf8\ub7f0 \ub2e4\uc74c \uc544\ub798 \ud654\uba74\ucc98\ub7fc \uc9c0\ub3c4\ud0a4 \ubc1c\uae09\uc5d0\uc11c \uc0ac\uc774\ud2b8 \uc8fc\uc18c\ub97c \uc785\ub825\ud558\uace0 \ud0a4\ub97c \ubc1c\uae09\ubc1b\ub3c4\ub85d \ud55c\ub2e4.<\/p>\n

\"\"<\/p>\n

\uadf8\ub7f0 \ub2e4\uc74c \uacbd\ub3c4 \uc704\ub3c4\ub97c \ud655\uc778\ud558\uae30 \uc704\ud574\uc11c \uc544\ub798 \uc8fc\uc18c\ub85c \uc811\uc18d\ud55c\ub2e4. test_key \ubd80\ubd84\uc740 \uc704\uc5d0\uc11c \ubc1c\uae09 \ubc1b\uc740 \ud0a4\ub85c \ubcc0\uacbd\ud55c\ub2e4.
\n\uc88c\ud45c\ud655\uc778URL<\/p>\n

http:\/\/openapi.map.naver.com\/api\/geocode.php?key=test_key&encoding=utf-8&coord=latlng&query=\uc11c\uc6b8 \uac15\ub0a8\uad6c \ub17c\ud6041\ub3d9<\/div>\n

\ub354 \uc790\uc138\ud55c \uc0ac\uc6a9\ubc95\uc740\u00a0http:\/\/dev.naver.com\/openapi\/apis\/map\/javascript_2_0\/reference#CT_URL<\/a>\u00a0\uc5d0\uc11c \ud655\uc778 \uac00\ub2a5.<\/p>\n

\uc544\ub798\ub294 \uacb0\uacfc \ud654\uba74\uc774\ub2e4.<\/p>\n

\"\"<\/p>\n

\uacb0\uacfc\ub294 XML \ud3ec\ub9f7\uc73c\ub85c \uc804\ub2ec\ub418\ub294 \ub370 x, y \uac12\uc774 \uc6b0\ub9ac\uac00 \uc6d0\ud558\ub294 \uac12\uc774\ub2e4. XML \ud30c\uc2f1 \ubd80\ubd84\uc740 \uac80\uc0c9\uc744 \ud1b5\ud574\uc11c.. ^^;<\/p>\n

\uac04\ub2e8\ud788 \ub0b4\uac00 \uc0ac\uc6a9\ud55c XML Parser\ub294\u00a0http:\/\/www.criticaldevelopment.net\/xml\/<\/a>\u00a0\uc5d0\uc11c \uc5bb\uc744 \uc218 \uc788\uc73c\uba70 \ud30c\uc11c \ud30c\uc77c\uc744
\nPHP \ud30c\uc77c\uc5d0 include \ud55c \ud6c4 \uc544\ub798 \ucf54\ub4dc\ub97c \uc774\uc6a9\ud574 XML\uc5d0\uc11c \uc88c\ud45c\ub97c \uc5bb\uc5b4\ub0b8\ub2e4.<\/p>\n

<?php
\n$source =\u201dhttp:\/\/openapi.map.naver.com\/api\/geocode.php?key=test_key&encoding=utf-8&coord=latlng&query=\u201d; <\/p>\n

$address = urlencode($address);<\/p>\n

$query = $source . $address;<\/p>\n

$xml = file_get_contents($query);<\/p>\n

$parser = new XMLParser($xml);<\/p>\n

$parser->Parse();<\/p>\n

$lng = $parser->document->item[0]->point[0]->x[0]->tagData;
\n$lat = $parser->document->item[0]->point[0]->y[0]->tagData;
\n?><\/p>\n<\/div>\n

test_key \ubd80\ubd84\uc740 \uc704\uc5d0\uc11c \ubc1c\uae09\ubc1b\uc740 \ud0a4\ub85c \ubcc0\uacbd\ud574\uc57c \ud55c\ub2e4. \uadf8\ub9ac\uace0 php \ud30c\uc77c\uc774 \uc704\uce58\ud55c \uc11c\ubc84\uc758 \ub3c4\uba54\uc778\uacfc \ubc1c\uae09\ubc1b\uc740 \ud0a4\uc758 \ub3c4\uba54\uc778\uc774 \uc77c\uce58\ud558\uc9c0 \uc54a\uc73c\uba74 \uc2e4\ud589\ub418\uc9c0 \uc54a\ub294\ub2e4. www\uac00 \ubd99\uc740 \ub3c4\uba54\uc778\uacfc \ubd99\uc9c0 \uc54a\uc740 \ub3c4\uba54\uc778\uc740 \uc11c\ub85c \ub2e4\ub974\uac8c \uc778\uc2dd\ub418\ub294 \ub4ef \ud558\ub2e4.<\/p>\n

2. MySQL Query\ub97c \uc774\uc6a9\ud574 \uae30\uc900 \ubc18\uacbd\ub0b4 \uc5c5\uccb4 \uac80\uc0c9
\n\uc6b0\uc120 \uacbd\ub3c4 \uc704\ub3c4\ub97c \uc800\uc7a5\ud560 \ud544\ub4dc\ub97c \ucd94\uac00\ud574\uc918\uc57c \ud55c\ub2e4. DATA \ud0c0\uc785\uc740 \uc544\ub798\uc640 \uac19\uc774 \ud558\uba74 \ub41c\ub2e4. \ud544\ub4dc \uba85\uc740 \uc801\ub2f9\ud788 \ubcc0\uacbd.<\/p>\n

\"\"<\/p>\n

\uc774\uc81c \uae30\uc900\uc810 (127.0000000, 37.0000000)\uc5d0\uc11c DB\uc5d0 \uc800\uc7a5\ub41c \uc9c0\uc810\uc758 \uac70\ub9ac\ub97c \uacc4\uc0b0\ud558\ub294 Query\ub97c \uc791\uc131\ud574\ubcf4\uc790.<\/p>\n

SELECT id, ( 6371 * acos( cos( radians(37) ) * cos( radians(\u00a0lat\u00a0) ) * cos( radians(\u00a0lng\u00a0) \u2013 radians(127) ) + sin( radians(37) ) * sin( radians(\u00a0lat\u00a0) ) ) ) AS distance FROM TEST_TABLE HAVING distance < 5 ORDER BY distance LIMIT 0 , 5;<\/div>\n

\uc704\uc758 \ucffc\ub9ac\ub294 TEST_TABLE\uc5d0\uc11c \uae30\uc900\uc810\uc5d0\uc11c \ubc18\uacbd 5Km \uc774\ub0b4\uc758 id\ub97c \uac70\ub9ac\uac00 \uac00\uae4c\uc6b4 \uc21c\uc11c\ub85c 5\uac1c \uac00\uc838\uc624\ub294 \uac83\uc774\ub2e4.
\n\ucc38\uace0 :\u00a0http:\/\/code.google.com\/intl\/ko\/apis\/maps\/articles\/phpsqlsearch_v3.html<\/a><\/p>\n

\uacb0\uacfc \uac12\uc774 \uc5bb\uc5b4\uc9c0\uba74 \uc774\uc81c \uc6d0\ud558\ub294 \uae30\ub2a5\uc744 \ud558\ub3c4\ub85d \ucf54\ub4dc\ub97c \uc791\uc131\ud558\uba74 \ub41c\ub2e4.<\/p>\n

\ucd9c\ucc98 :\u00a0http:\/\/ncube.net\/7388<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

1. \ub124\uc774\ubc84 \uc9c0\ub3c4 API\uc5d0\uc11c \uacbd\ub3c4, \uc704\ub3c4 \ubc1b\uc544\uc624\uae30 \uc6b0\uc120 \ub124\uc774\ubc84 \uc9c0\ub3c4 API\ub97c \uc774\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 Key\ub97c \ub4f1\ub85d\ud574\uc57c \ud55c\ub2e4. http:\/\/dev.naver.com\/openapi\/register\u00a0\uc5d0 \uc811\uc18d\ud55c\ub2e4. \ub85c\uadf8\uc778\uc774 \ub418\uc5b4\uc57c \uc815\uc0c1\uc801\uc73c\ub85c \uc774\uc6a9\ud560 \uc218 \uc788\ub2e4. \uadf8\ub7f0 \ub2e4\uc74c \uc544\ub798 \ud654\uba74\ucc98\ub7fc \uc9c0\ub3c4\ud0a4 \ubc1c\uae09\uc5d0\uc11c… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1449"}],"collection":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1449"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1449\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}