{"id":758,"date":"2014-03-06T17:44:32","date_gmt":"2014-03-06T16:44:32","guid":{"rendered":"http:\/\/webpiraten.de\/?p=758"},"modified":"2014-03-06T17:44:32","modified_gmt":"2014-03-06T16:44:32","slug":"umkreissuche-in-mysql-mit-coordinaten-latitude-longitude","status":"publish","type":"post","link":"https:\/\/webpiraten.de\/index.php\/php\/umkreissuche-in-mysql-mit-coordinaten-latitude-longitude\/","title":{"rendered":"umkreissuche in mysql mit coordinaten (latitude, longitude)"},"content":{"rendered":"<p>wenn ihr eine schnelle l\u00f6sung f\u00fcr eine umkreissuche ben\u00f6tigt, k\u00f6nnt ihr direkt in mysql geocoordinaten + distanzen errechnen.<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\n# :dist = gew\u00fcnschte entfernung in km (z.b 10)\r\n# :lat = latitude der aktuellen position\r\n# :lon = longitude der aktuellen position\r\n\r\nSELECT\r\n    id,\r\n    latitude,\r\n    longitude,\r\n    (\r\n        6371 * acos(\r\n            cos(\r\n                radians( :lat )\r\n            ) * cos(\r\n                radians( latitude )\r\n            ) * cos(\r\n                radians( longitude ) - radians( :lon )\r\n            ) + sin(\r\n                radians( :lat )\r\n            ) * sin(\r\n                radians( latitude )\r\n            )\r\n        )\r\n    ) AS distance\r\n\r\nFROM\r\n    points_with_geocoordinates\r\n\r\nHAVING\r\n    distance &lt;= :dist\r\n\r\nORDER BY\r\n    distance ASC\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>wenn ihr eine schnelle l\u00f6sung f\u00fcr eine umkreissuche ben\u00f6tigt, k\u00f6nnt ihr direkt in mysql geocoordinaten + distanzen errechnen. # :dist = gew\u00fcnschte entfernung in km (z.b 10) # :lat = latitude der aktuellen position # :lon = longitude der aktuellen position SELECT id, latitude, longitude, ( 6371 * acos( cos( radians( :lat ) ) * [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,5],"tags":[534,527,524,536,530,531,523,528,525,529,526,634,537,535,533,532],"class_list":["post-758","post","type-post","status-publish","format-standard","hentry","category-mysql","category-php","tag-acos","tag-coord","tag-coordinate","tag-cos","tag-distance","tag-distanz","tag-geo","tag-lat","tag-latitude","tag-lon","tag-longitude","tag-mysql","tag-radians","tag-sin","tag-suche","tag-umkreis"],"_links":{"self":[{"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/posts\/758","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/comments?post=758"}],"version-history":[{"count":3,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/posts\/758\/revisions"}],"predecessor-version":[{"id":761,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/posts\/758\/revisions\/761"}],"wp:attachment":[{"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/media?parent=758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/categories?post=758"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/tags?post=758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}