query($segment_query) or die($mysqli->error.__LINE__);
if($segment_result->num_rows > 0) {
while($s = $segment_result->fetch_array()){
$segment = array();
$segment['id'] = $s['segment_id'];
$segment['color'] = $s['color'];
$coordinates = array();
$offset = 9;
$pts = unpack("@$offset/d*", $s[2]);
$geom = array();
$pair = false;
$count = 0;
$i = 1;
while($i < count($pts)){
$geom[0] = $pts[$i];
$i = $i + 1;
$geom[1] = $pts[$i];
$i = $i + 1;
$coordinates[$count] = $geom;
$count = $count + 1;
}
$segment['coordinates'] = $coordinates;
$segments[$segment["id"]] = $segment;
}
}
?>