Convert from UTC to local time based on lat/long?

<?php

$conn=mysqli_connect("localhost","REMOVED","REMOVED","REMOVED");
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$sql = "SELECT config.nodeid, config.loc_city, config.loc_state, config.latitude, config.longitude, event_data.compass, event_data.heading, event_data.pressure, event_data.datetime, event_data.event_type FROM config INNER JOIN event_data ON config.nodeid = event_data.nodeid AND event_data.event_type = 'alertStart' AND event_data.datetime > DATE_SUB(NOW(), INTERVAL 1 DAY) ORDER BY `config`.`nodeid` ASC;";

$result = mysqli_query($conn, $sql);
$num_rows = mysqli_num_rows($result);

    $header ="From: example@example.com" . "\r\n";
    $email    = 'example@example.com';
    $header .= "MIME-Version: 1.0\r\n";
    $header .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
    $subject  = 'ALERT: ' . $num_rows . ' Nodes Reported alertStart!';
    $message = 'The following nodes reported an alertStart in the last 24 hours:
    <table border="1">
        <tr>
            <td>Node</td>
            <td>City</td>
            <td>State</td>
            <td>Compass</td>
            <td>Heading</td>
            <td>Pressure (in/Hg)</td>
            <td>Alert Time - UTC</td>
        </tr>
        ';
while ($row = mysqli_fetch_array($result)){
$message .="<tr>";
$message .="<td>".$row['nodeid']."</td>";
$message .="<td>".$row['loc_city']."</td>";
$message .="<td>".$row['loc_state']."</td>";
$message .="<td>".$row['compass']."</td>";
$message .="<td>".$row['heading']."</td>";
$message .="<td>".$row['pressure']."</td>";
$message .="<td>".$row['datetime']."</td>";
$message .="</tr>";
}
$message .="</table>EOF";

	mail($email, $subject, $message, $header);

?>

Select allOpen in new window