/**
Retrieves the markers from the DB and loads them into an array. It creates full
Marker objects with Line and Connection objects.
@return an array of Markers
*/
function retrieveMarkers()
{
$debug = false;
$markers = array();
$query = 'SELECT * FROM markers';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
while ($line = mysql_fetch_array($result, MYSQL_BOTH)) {
$id = $line['id'];
$lat = $line['lat'];
$lng = $line['lng'];
$name = $line['name'];
$url = $line['url'];
if ($debug) {
echo "building marker: {$name} ({$id})<br/>";
}
$marker = new Marker($lat, $lng, $id, $name);
$marker->setURL($url);
// grab all connections
$conn_query = "SELECT * FROM connections WHERE id='" . $id . "'";
$conn_result = mysql_query($conn_query) or die('Query failed: ' . mysql_error());
$lines = array();
$line_names = array();
while ($conn = mysql_fetch_array($conn_result, MYSQL_BOTH)) {
// grab all variables from DB
$marker_id = $conn['marker_id'];
$day = $conn['day'];
$duration = $conn['duration'];
$line = $conn['line'];
$type = $conn['type'];
$start = $conn['start'];
$end = $conn['end'];
if ($debug) {
echo "->found connection: {$marker_id}<br/>";
}
// create a new connection
$connection = new Connection($marker_id, $type, $start, $end, $day, $duration);
$marker_line = $lines["{$line}"];
if (is_null($marker_line)) {
$marker_line = array();
}
$marker_line[] = $connection;
// add it to an array. we need it later.
if ($debug) {
echo "->found line: {$line}<br/>";
}
$lines["{$line}"] = $marker_line;
if (!in_array($line, $line_names)) {
if ($debug) {
echo "adding {$line} to line_names<br/>";
}
$line_names[] = $line;
}
}
// connection loop
if ($debug) {
echo "line_names count: " . count($line_names) . "<br/>";
}
// retrieved all connections and set them in their appropriate lines.
// now we need to create the lines
foreach ($line_names as $line_name) {
if ($debug) {
echo "->looking at line: {$line_name}<br/>";
}
// for each line, grab the data from the database
$line_query = "SELECT * FROM `lines` WHERE name='" . $line_name . "'";
$line_result = mysql_query($line_query) or die('Query failed: ' . mysql_error());
// the line_name is the unique key for that table, so we only need to get the first one
$line_array = mysql_fetch_array($line_result, MYSQL_BOTH);
$lname = $line_array['name'];
$lurl = $line_array['url'];
$limg = $line_array['img'];
$line = new Line($limg, $lurl, $lname);
if ($debug) {
echo "-->found line: " . $lname . "<br/>";
}
// now add all the connections
$connections = $lines["{$line_name}"];
foreach ($connections as $connection) {
// each one is a connection object from above. add it
$line->addConnection($connection);
if ($debug) {
echo "--->adding " . $connection->id . " to {$line_name}<br/>";
}
}
// now add the line to the marker
$marker->addLine($line);
if ($debug) {
echo "-->adding {$line_name} to {$name}<br/>";
}
}
// line loop
// the marker object is created and populated. add to the markers array.
$markers["{$id}"] = $marker;
if ($debug) {
echo "adding {$id} to markers<br/>";
}
}
// marker loop
return $markers;
}