WP GeoNames

You can insert as many file as you want.

Use

You must use the WordPress tools to get the database. WPDB is your friend . You can write the code directly in your template or in functions.php of your theme.

Name of the table : ($wpdb->prefix)geonames

Names of the columns :

1. 09idwpgn (bigint)
2. 10geonameid (bigint)
3. 11name (varchar)
4. 12asciiname (varchar)
5. 13alternatenames (text)
6. 14latitude (decimal)
7. 15longitude (decimal)
8. 16feature_class (char)
9. 17feature_code (varchar)
10. 18country_code (varchar)
11. 19cc2 (varchar)
12. 20admin1_code (varchar)
13. 21admin2_code (varchar)
14. 22admin3_code (varchar)
15. 23admin4_code (varchar)
16. 24population (bigint)
17. 25elevation (int)
18. 26dem (smallint)
19. 27timezone (varchar)
20. 28modification_date (date)

Feature Class & Code here .

Example : get GPS position for a specific city in a specific country :

global $wpdb; $s = $wpdb->get_row("SELECT latitude, longitude FROM ".$wpdb->prefix."geonames WHERE name='Paris' and country_code='FR' "); echo $s->latitude . " - " . $s->longitude;

Example : 10 most populous cities in Switzerland :

global $wpdb; $s = $wpdb->get_results("SELECT name, population FROM ".$wpdb->prefix."geonames WHERE country_code='CH' and feature_class='P' ORDER BY population DESC LIMIT 10"); foreach($s as $t) { echo $t->name. " : " . $t->population . "<br />"; }

Example : hotels within 40 km from Marbella (ES) :

global $wpdb; $p = $wpdb->get_row("SELECT latitude, longitude FROM ".$wpdb->prefix."geonames WHERE name='Marbella' and country_code='ES' "); $dlat = 40 / 1.852 / 60; $dlon = 40 / 1.852 / 60 / cos($p->latitude * 0.0174533); $s = $wpdb->get_results("SELECT name, latitude, longitude FROM ".$wpdb->prefix."geonames WHERE country_code='ES' and feature_code='HTL' and latitude<".($p->latitude+$dlat)." and latitude>".($p->latitude-$dlat)." and longitude<".($p->longitude+$dlon)." and longitude>".($p->longitude-$dlon)." LIMIT 100"); foreach($s as $t) { $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)))); if($d<=40) echo $t->name. " : " . $d . " km<br />"; }

Example : Suggest cities during the typing by the user (like Google search)

You must use Ajax action and PHP function with the name “wpgeonamesAjax”

In your theme, in function.php ; add : function wpgeonamesAjax() { global $wpdb; $s = $wpdb->get_results(“SELECT name FROM “.$wpdb->prefix.”geonames WHERE country_code=’FR’ and feature_class=’P’ and name LIKE ‘”.strip_tags($_POST[“city”]).”%’ ORDER BY name LIMIT 10″); foreach($s as $t) { echo ‘

‘.$t->name.’

‘; } }

In your theme, in the right page ; add :

<input id="inpCity" name="inpCity" type="text" onkeyup="sugg(this,'<?php echo admin_url('admin-ajax.php'); ?>');" /> <div class="suggCity" id="suggCity"></div> <script> function sugg(f,g){ jQuery(document).ready(function(){ jQuery.post(g,{'action':'wpgeonamesAjax','city':f.value},function(r){ jQuery('#suggCity').empty();jQuery('#suggCity').append(r.substring(0,r.length-1)); }); }); } </script>