Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Sep 2007
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    City, Providence, Country Location Script?

    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.

  • #2
    New Coder
    Join Date
    Apr 2007
    Posts
    89
    Thanks
    1
    Thanked 2 Times in 2 Posts
    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 Code:
    <?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($resultMYSQL_NUM)) {
        
    printf("ID: %s  Name: %s"$row[0], $row[1]); 
    }

    mysql_free_result($result);
    ?>

  • #3
    Senior Coder
    Join Date
    Jan 2007
    Posts
    1,648
    Thanks
    1
    Thanked 58 Times in 54 Posts
    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.

  • #4
    Super Moderator Inigoesdr's Avatar
    Join Date
    Mar 2007
    Location
    Florida, USA
    Posts
    3,642
    Thanks
    2
    Thanked 405 Times in 397 Posts
    I've used this one before. They have some sample code, but I imported it into MySQL and made a custom script for the site I used it on.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •