PHP Geo::geocoder_getdata示例

function get_geo($modin, $geo_field = NULL, $update = NULL, $limit = '1000', $offset = '0')
{
    global $dbcon;
    $type = $_REQUEST['type'];
    if ($update) {
        $up_sql = ' and ' . $geo_field . ' != "" ';
    }
    $sql = "select * from userdata where modin =" . $modin . $up_sql . " limit {$offset}, {$limit}";
    $R = $dbcon->Execute($sql) or die("Error getting udm data " . $sql . $dbcon->ErrorMsg());
    $t = 0;
    $x = 0;
    while (!$R->EOF) {
        $t++;
        $geo = new Geo($dbcon);
        $geo->City = $R->Fields("City");
        $geo->State = $R->Fields("State");
        $geo->Street = $R->Fields("Street");
        $geo->Zip = $R->Fields("Zip");
        if ($geo->Street) {
            $geo->geocoder_getdata();
        }
        ///if ( ($R->Fields("City")) &&  ($R->Fields("State")) &&  ($type == 'City') && (!$geo->lat) ) {
        //	$geo->city_lookup();
        //}
        if ($geo->lat && $geo->long) {
            $sql = "update userdata set " . $geo_field . " = '" . $geo->lat . "," . $geo->long . "' where id = " . $R->Fields("id");
            $dbcon->Execute($sql) or die("Error updating udm " . $sql . $dbcon->ErrorMsg());
            echo $R->Fields("id") . ": " . $geo->lat . $geo->long . "<br>";
            $x++;
        } else {
            $html .= "<a href = 'modinput4_view.php?uid=" . $R->Fields("id") . "&modin=" . $modin . "'>" . $R->Fields("Street") . " " . $R->Fields("City") . " " . $R->Fields("State") . " " . $R->Fields("Zip") . " </a><br>";
        }
        $R->MoveNext();
    }
    $out = "Found {$x} address of {$t} <br><br>Failed Addresses<br> {$html}";
    return $out;
}