Ejemplo n.º 1
0
function placeMapMarkers($pageId, $DB_SERVER, $DB_USERNAME, $DB_PASSWORD, $DB_DATABASE)
{
    global $baseURL;
    $results = getMapMarkers($pageId, $DB_SERVER, $DB_USERNAME, $DB_PASSWORD, $DB_DATABASE);
    //$numRows =  mysqli_num_rows($results);
    $numRows = count($results);
    $counter = 0;
    $markerJS = '';
    if ($numRows > 0) {
        $markerJS .= 'var iconBase = \'' . $baseURL . '/img/\';';
        $markerJS .= "\r\n";
        $markerJS .= 'var thmbBase = \'' . $baseURL . '/img/locations/thumbnails/\';';
        $markerJS .= "\r\n";
        $markerJS .= 'var markerLocations = [';
        $markerJS .= "\r\n";
        foreach ($results as $row) {
            $counter++;
            $markerJS .= '{';
            $markerJS .= "\r\n";
            $markerJS .= 'id: ' . $row['id'] . ', ';
            $markerJS .= "\r\n";
            $markerJS .= 'title: "' . $row['title'] . '", ';
            $markerJS .= "\r\n";
            $markerJS .= 'lat: ' . $row['lat'] . ', ';
            $markerJS .= "\r\n";
            $markerJS .= 'lng: ' . $row['lng'] . ', ';
            $markerJS .= "\r\n";
            $markerJS .= 'icon: iconBase + \'' . $row['map_icon'] . '\', ';
            $markerJS .= "\r\n";
            $markerJS .= 'image_thumb: thmbBase + \'' . $row['image_thumb'] . '\', ';
            $markerJS .= "\r\n";
            $markerJS .= 'alt: "' . $row['alt'] . '", ';
            $markerJS .= "\r\n";
            $markerJS .= 'category: "' . $row['category_title'] . '", ';
            $markerJS .= "\r\n";
            $markerJS .= 'sub_heading: "' . $row['type_title'] . '"';
            $markerJS .= "\r\n";
            $markerJS .= '}';
            if ($counter < $numRows) {
                $markerJS .= ',';
            }
            $markerJS .= "\r\n";
        }
        $markerJS .= '];';
        $markerJS .= "\r\n";
        $markerJS .= "\r\n";
    }
    echo $markerJS;
}
Ejemplo n.º 2
0
function getFilters($pageId, $DB_SERVER, $DB_USERNAME, $DB_PASSWORD, $DB_DATABASE)
{
    $filterArray = array();
    $categories = getMapMarkers($pageId, $DB_SERVER, $DB_USERNAME, $DB_PASSWORD, $DB_DATABASE);
    foreach ($categories as $category) {
        if (!in_array($category['category_title'], $filterArray)) {
            array_push($filterArray, $category['category_title']);
        }
    }
    return $filterArray;
}