query("jobcards", "SELECT * FROM jobcards WHERE 1");
$js_array = "[";
if ($res->num_rows > 0) {
$first = true;
while ($row = $res->fetch_assoc()) {
$location = explode(",", $row['drill_co_ordinates']);
$lant = explode(":", $location[0])[1];
$long = explode(":", $location[1])[1];
$jobcard = $row['jc_no'];
$date = $row['action_date'];
$water_flow = $row['water_flow'];
if ($first) {
$first = false;
} else {
$js_array .= ",";
}
$js_array .= "{
latitude: '" . $lant . "',
longitude: '" . $long . "',
date: '" . $date . "',
jobcard: '" . $jobcard . "',
notes: '" . $water_flow . "'
}";
}
}
$js_array .= "]";
?>
Saved Locations Viewer
Saved Jobcard Locations