geocoding

require("dbinfo.php");
//Connect to database
$dbh = new PDO("mysql:host=$host;dbname=$database", $username, $password);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
try {
    //Prepare query
    $name = "%".$company."%";//Wildcard for PDO paramerter
    $countSql = "SELECT COUNT(*) FROM markers WHERE `name` LIKE ?";
    $countStmt = $dbh->prepare($countSql);
    // Assign parameter
    $countStmt->bindParam(1,$name);
    //Execute query
    $countStmt->execute();
    // check the row count
    if ($countStmt->fetchColumn() == 0) { #1
        echo "No row matched the query.";
        $q =$address.','.$city.','.$post_code;//Add .',UK'; for UK but inserts a lat & lng even if no address or postcode
        echo "\n";
        $base_url = "http://maps.googleapis.com/maps/api/geocode/xml?address=";
        $request_url = $base_url.urlencode($q)."&sensor=false";
        $xml = simplexml_load_file($request_url) or die("url not loading");
        if($xml->status=="OK"){#2
            // Successful geocode
            $lat = $xml->result->geometry->location->lat;
            $lng = $xml->result->geometry->location->lng;
            $flag = 1;
        } #2
        else if($xml->status=="ZERO_RESULTS"){#3
            //Zero Results
            $lat = 0;
            $lng = 0;
            $flag = 1;
        }#3
         else if($xml->status=="OVER_QUERY_LIMIT"){#4
              echo "OVER_QUERY_LIMIT";
              $flag = 0;
             //Do something

         }#4
         else if($xml->status=="REQUEST_DENIED"){#5
              echo "REQUEST DENIED";
              $flag = 0;
             //Do something
        }#5
        else if($xml->status=="REQUEST_DENIED"){#6
              echo "REQUEST DENIED";
              $flag = 0;
             //Do something
        }#6


         if($flag == 1){#7
            $insertSql ="INSERT INTO markers (`name`, `address`, `lat`, `lng`, `type`, `link`) VALUES (?,?,?,?,?,?)";
            $insertStmt = $dbh->prepare($insertSql);
            // Assign parameter
            $insertStmt->bindParam(1,$company);
            $insertStmt->bindParam(2,$address);
            $insertStmt->bindParam(3,$lat);
            $insertStmt->bindParam(4,$lng);
            $insertStmt->bindParam(5,$type);
            $insertStmt->bindParam(6,$link);
            //Execute query
            $insertStmt->execute();
        }#7

    } #1
    else {#1
    echo "Row matched the query.";
    } #1





}// End try


catch(PDOException $e) {
    echo "I'm sorry I'm afraid you can't do that.". $e->getMessage() ;// Remove or modify after testing
    file_put_contents('PDOErrors.txt',date('[Y-m-d H:i:s]').", myFile.php, ". $e->getMessage()."\r\n", FILE_APPEND);
 }