...

View Full Version : City, Providence, Country Location Script?



shakyfry
11-07-2007, 07:21 PM
Does anyone know where I could find a choose location script that is as extensive as the one on this page. http://ablespace.abk-soft.com/search.php

There is no way they added all those cities and towns in cities from around the world themselves into their database.

Does anyone know where I can find this location script? I would love you for life.

psykx
11-07-2007, 08:36 PM
No, but surely your looking for a database?

the script below if from the php manual, fetch_array() fetch_assoc() and fetch_row() are all similar


<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf("ID: %s Name: %s", $row[0], $row[1]);
}

mysql_free_result($result);
?>

aedrin
11-07-2007, 11:03 PM
If you can't find an extensive one like theirs, why not just take theirs?

It shouldn't take much effort to write a JavaScript that will fetch all of their countries + provinces + cities using their Ajax calls.

Inigoesdr
11-08-2007, 05:23 AM
I've used this one (http://www.geobytes.com/GeoWorldMap.zip) before. They have some sample code, but I imported it into MySQL and made a custom script for the site I used it on.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum