function getCoords($query, $zip, $mykey)
{
$geocoder = new OpenCage\Geocoder($mykey);
$result = $geocoder->geocode($query);
$empty[0] = "";
if (empty($result['results'][0])) {
array_push($empty, $result);
} else {
$jsst = '{"lat":' . ($latlng['lat'] = $result['results'][0]['geometry']['lat']);
$jsst .= ', "long":' . ($latlng['lng'] = $result['results'][0]['geometry']['lng']);
$jsst .= ', "zip":' . $zip . '}, ';
}
if (empty($latlng['lat'])) {
return;
} else {
return $jsst;
}
}
#!/usr/bin/env php
<?php
/*One time script used to add latitude and longitude to all businesses in database*/
require_once './src/OpenCage.Geocoder.php';
$key = "39ee84f3ae0ca490055ca19becda2846";
$geocoder = new OpenCage\Geocoder($key);
/*Add longitude and latitude to repair businesses*/
$mysqli = new mysqli("mysql.eecs.oregonstate.edu", "cs419-g4", "RNjFRsBYJK5DVF8d", "cs419-g4");
$result = $mysqli->query('SELECT repairId, repairName, repairAddress, repairCity, repairState FROM repair_businesses');
while ($row = $result->fetch_assoc()) {
$query = $row["repairAddress"] . " " . $row["repairCity"] . "," . $row["repairState"];
$id = $row["repairId"];
$geo_res = $geocoder->geocode($query);
$lat = $geo_res["results"][0]["geometry"]["lat"];
$lng = $geo_res["results"][0]["geometry"]["lng"];
$stmt = $mysqli->prepare("UPDATE repair_businesses SET repairLongitude = ?, repairLatitude = ? WHERE repairId = ?");
$stmt->bind_param("ddi", $lng, $lat, $id);
$stmt->execute();
echo $row["repairName"] . " coordinates input\n";
}
$result->free();
/*Add longitude and latitude to reuse businesses*/
$result = $mysqli->query('SELECT reuseId, reuseName, reuseAddress, reuseCity, reuseState FROM reuse_businesses');
while ($row = $result->fetch_assoc()) {
$query = $row["reuseAddress"] . " " . $row["reuseCity"] . "," . $row["reuseState"];
$id = $row["reuseId"];
$geo_res = $geocoder->geocode($query);
$lat = $geo_res["results"][0]["geometry"]["lat"];
$lng = $geo_res["results"][0]["geometry"]["lng"];
$stmt = $mysqli->prepare("UPDATE reuse_businesses SET reuseLongitude = ?, reuseLatitude = ? WHERE reuseId = ?");