here<\/a>.<\/p>\n\nExample : get GPS position for a specific city in a specific country :<\/p>\n\n
global $wpdb;\n$s = $wpdb->get_row(\"SELECT latitude, longitude \n FROM \".$wpdb->prefix.\"geonames \n WHERE name='Paris' and country_code='FR' \");\necho $s->latitude . \" - \" . $s->longitude;\n<\/code><\/pre>\n\nExample : 10 most populous cities in Switzerland :<\/p>\n\n
global $wpdb;\n$s = $wpdb->get_results(\"SELECT name, population \n FROM \".$wpdb->prefix.\"geonames \n WHERE country_code='CH' and feature_class='P' \n ORDER BY population DESC \n LIMIT 10\");\nforeach($s as $t) {\n echo $t->name. \" : \" . $t->population . \"<br \/>\";\n}\n<\/code><\/pre>\n\nExample : hotels within 40 km from Marbella (ES) :<\/p>\n\n
global $wpdb;\n$p = $wpdb->get_row(\"SELECT latitude, longitude \n FROM \".$wpdb->prefix.\"geonames \n WHERE name='Marbella' and country_code='ES' \");\n$dlat = 40 \/ 1.852 \/ 60;\n$dlon = 40 \/ 1.852 \/ 60 \/ cos($p->latitude * 0.0174533);\n$s = $wpdb->get_results(\"SELECT name, latitude, longitude\n FROM \".$wpdb->prefix.\"geonames \n WHERE country_code='ES' and \n feature_code='HTL' and \n latitude<\".($p->latitude+$dlat).\" and\n latitude>\".($p->latitude-$dlat).\" and\n longitude<\".($p->longitude+$dlon).\" and\n longitude>\".($p->longitude-$dlon).\"\n LIMIT 100\");\nforeach($s as $t) {\n $d = (floor(sqrt(pow(($p->latitude-$t->latitude)*60*1.852,2)+pow(($p->longitude-$t->longitude)*60*1.852*cos($p->latitude * 0.0174533),2))));\n if($d<=40) echo $t->name. \" : \" . $d . \" km<br \/>\";\n}\n<\/code><\/pre>\n\nExample : Suggest cities during the typing by the user (like Google search)<\/p>\n\n
You must use Ajax action and PHP function with the name \"wpgeonamesAjax\"<\/strong><\/p>\n\nIn your theme, in function.php ; add :\n function wpgeonamesAjax() {\n global $wpdb;\n $s = $wpdb->get_results(\"SELECT name \n FROM \".$wpdb->prefix.\"geonames \n WHERE country_code='FR' and feature_class='P' and name LIKE '\".strip_tags($_POST[\"city\"]).\"%' \n ORDER BY name \n LIMIT 10\");\n foreach($s as $t) {\n echo '<\/p>\n\n'.$t->name.'\n\n
';\n }\n }<\/p>\n\n
In your theme, in the right page ; add :<\/p>\n\n
<input id=\"inpCity\" name=\"inpCity\" type=\"text\" onkeyup=\"sugg(this,'<?php echo admin_url('admin-ajax.php'); ?>');\" \/>\n<div class=\"suggCity\" id=\"suggCity\"><\/div>\n<script>\nfunction sugg(f,g){\n jQuery(document).ready(function(){\n jQuery.post(g,{'action':'wpgeonamesAjax','city':f.value},function(r){\n jQuery('#suggCity').empty();jQuery('#suggCity').append(r.substring(0,r.length-1));\n });\n });\n}\n<\/script>\n<\/code><\/pre>\n\n\n1.9.2<\/h4>\n\n
02\/05\/2025 - Fix translation warning with WP 6.8<\/p>","raw_excerpt":"Allows you to insert all or part of the global GeoNames database in your WordPress base.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pirate.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/33085","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pirate.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/pirate.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/pirate.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=33085"}],"author":[{"embeddable":true,"href":"https:\/\/pirate.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/sojahu"}],"wp:attachment":[{"href":"https:\/\/pirate.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=33085"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/pirate.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=33085"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/pirate.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=33085"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/pirate.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=33085"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/pirate.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=33085"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/pirate.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=33085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}