Advertisement

12.01.2008 at 01:43AM PST, ID: 23946191 | Points: 250
[x]
Attachment Details

display 1 color/item from database

I have this site running: www.modelbouwlocaties.nl
It shows all the database markers (shops, carclubs, boatclubs,
flightclubs) via color in script.

I like it to show only 1 item/color marker example only flightclubs(red).
The database contains rows with a color collum (gray, red, green, blue)

Don't know how to proceed / build this. So need a bit help.

using store locator from pamela (google).

my script:
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
//<![CDATA[ 
    var map; 
    var geocoder; 
        var gmarkers = []; 
        var to_htmls = []; 
        var from_htmls = []; 
        var i = 0; 
        var request; 
 
 
var baseIcon = new GIcon(); 
baseIcon.image = "http://www.modelbouwlocaties.nl/red.png"; 
baseIcon.shadow = "http://www.modelbouwlocaties.nl/shadow.png"; 
baseIcon.iconSize = new GSize(27, 41); 
baseIcon.shadowSize = new GSize(48, 41); 
baseIcon.iconAnchor = new GPoint(13, 20); 
baseIcon.infoWindowAnchor = new GPoint(13, 20); 
baseIcon.imageMap = [4,0,0,4,0,7,3,11,4,19,7,19,8,11,11,7,11,4,7,0]; 
baseIcon.transparent = "mapIcons/mm_20_transparent.png"; 
var icons=[]; 
 
 
var mainicon = new GIcon(); 
mainicon.image = "http://www.modelbouwlocaties.nl/mainmarker.png"; 
mainicon.shadow = "http://www.modelbouwlocaties.nl/mainshadow.png"; 
mainicon.iconSize = new GSize(27, 41); 
mainicon.shadowSize = new GSize(48, 41); 
mainicon.iconAnchor = new GPoint(13, 20); 
mainicon.infoWindowAnchor = new GPoint(13, 20); 
 
 
        function coloredRideshareIcon(iconColor) { 
         var color; 
         if ((typeof(iconColor)=="undefined") || (iconColor==null)) { 
      color = "red" 
         } else { 
      color = iconColor; 
         } 
         if (!icons[iconColor]) { 
      var icon = new GIcon(baseIcon); 
      icon.image = "http://www.modelbouwlocaties.nl/"+ color +".png"; 
      icons[iconColor]=icon; 
         } 
         return icons[iconColor]; 
        } 
 
 
    function load() { 
      if (GBrowserIsCompatible()) { 
        geocoder = new GClientGeocoder(); 
        map = new GMap2(document.getElementById('map')); 
        map.addControl(new GSmallMapControl()); 
        map.addControl(new GMapTypeControl()); 
                map.addMapType(G_PHYSICAL_MAP); 
        map.setCenter(new GLatLng(52.184036864,5.5535888671),7); 
      } 
    } 
 
 
        function searchLocations() { 
     var adres = document.getElementById('adresInput').value; 
     geocoder.getLatLng(adres, function(latlng) { 
       if (!latlng) { 
         alert(adres + ' not found'); 
       } else { 
             map.clearOverlays(); 
         searchLocationsNear(latlng); 
                 var mainmarker = new GMarker(latlng, mainicon); 
         map.addOverlay(mainmarker); 
       } 
     }); 
   } 
 
 
        function searchLocationsNear(center) { 
     var radius = document.getElementById('radiusSelect').value; 
     var searchUrl = 'phpsqlsearch_genxml.php?lat=' + center.lat() + 
'&lon=' + center.lng() + '&radius=' + radius; 
     GDownloadUrl(searchUrl, function(data) { 
       var xml = GXml.parse(data); 
       var markers = xml.documentElement.getElementsByTagName 
('marker'); 
       var bounds = new GLatLngBounds(); 
       for (var i = 0; i < markers.length; i++) { 
         var naam = markers[i].getAttribute('naam'); 
         var adres = markers[i].getAttribute('adres'); 
                 var postcode = markers[i].getAttribute('postcode'); 
                 var plaats = markers[i].getAttribute('plaats'); 
                 var tel = markers[i].getAttribute('tel'); 
                 var url = markers[i].getAttribute('url'); 
         var distance = parseFloat(markers[i].getAttribute 
('distance')); 
         var point = new GLatLng(parseFloat(markers[i].getAttribute 
('lat')), parseFloat(markers[i].getAttribute('lon'))); 
         var color= markers[i].getAttribute("icon"); 
         var marker = createMarker(point, naam, adres, postcode, 
plaats, tel, url, distance, color, i); 
         map.addOverlay(marker); 
         bounds.extend(point); 
       } 
       map.setCenter(bounds.getCenter(), map.getBoundsZoomLevel 
(bounds)); 
     }); 
   } 
 
 
     function tohere(i) { 
        gmarkers[i].openInfoWindowHtml(to_htmls[i]); 
      } 
          function fromhere(i) { 
        gmarkers[i].openInfoWindowHtml(from_htmls[i]); 
      } 
 
 
    function createMarker(point, naam, adres, postcode, plaats, tel, 
url, distance, iconStr, marker_num) { 
        var i = marker_num; 
        var icon = coloredRideshareIcon(iconStr); 
    var marker = new GMarker(point, icon); 
        gmarkers[i] = marker; 
    marker.type = iconStr; 
 
 
      var centrum= document.getElementById('adresInput').value; 
      var html = '<b>' + naam + '</b> <br/>' + adres + '<br/>' + 
postcode + ' ' + plaats + '<br/>Tel: ' + tel + '<br/><a href="' + url 
+ '">' + url + '</a><br/><br>' + distance.toFixed(1) + ' km vanaf ' + 
centrum + '.'; 
 
 
          // The info window version with the "to here" form open 
        to_htmls[i] = html + '<br><form name="route" action="http:// 
maps.google.nl/maps" method="get" 
target="_blank">Vertrekpunt:'+'<br><input type="text" SIZE=35 
MAXLENGTH=40 name="saddr" id="saddr" value="straatnaam, plaatsnaam" / 
 
 
><br>' + 
 
 
           '>> <a href="javascript:document.route.submit()">Bereken 
route</a>' + 
                   '<input type="hidden" name="daddr" value="' + point.lat() + ',' + 
point.lng() + '"/>'; 
 
           html = html + '<br>Routebeschrijving: <a href="javascript:tohere 
('+i+')">Hier naartoe</a>'; 
 
 
          GEvent.addListener(marker, 'click', function() { 
        marker.openInfoWindowHtml(html); }); 
 
 
          GEvent.addListener(marker, "mouseover", function() { 
         marker.openInfoWindowHtml(html); }); 
 
 
      return marker; 
    } 
    //]]>
Top Expert: mplungjan
Expert Since: 04/06/1998
Accepted Solutions: 7077
Computer Expertise: Advanced
mplungjan has been an Expert for 10 years 9 months, during which he has posted 43816 comments and answered 7077 questions. mplungjan is just one of 2424 experts in the JavaScript Zone.
 
 
20081119-EE-VQP-47 - Hierarchy / EE_QW_2_20070628