[mapserver-users] Querying an external database

[Bjarni Pjetursson]

Hi,
you might want to port your shapefile to the database as well. By doing
this, you can use standard SQL to join the objects in your layer.
Another solution is to alter your layers FILTER attribute on-the-fly. You
could have an HTML input item called "MAP_LAYERNAME_FILTER" where you alter
the WHERE-clause for your shapefile. Read the cgi reference:
http://mapserver.gis.umn.edu/doc36/cgi-reference.html
Regards
Bjarni Thor Pjetursson


-----Original Message-----
From: Alessandro Cadeddu
To: mapserver-users at lists.gis.umn.edu
Sent: 18-07-02 14:18
Subject: [mapserver-users] Querying an external database

Hi all,
 
I'd like to build an application which allow the user to query an
external database, for example querying the attribute table in MySQl or
Access
database, and gets a list of ID. Then I need to query the shapefile to
highlight all the returned ID.

How can I do this?
How can I link the returned ID from the external database with the
shapefile ID?
How can I query the shapefile and highlight the results in PHP/MapScript
?
Can anyone send me an example?


Thanks very much
 
____________________________________________________________________
 
  Alessandro Cadeddu            E-mail: acadeddu at crs4.it
<mailto:acadeddu at crs4.it>  
  CRS4 - GIS                 
  Sesta Strada Ovest              Phone: +39 070 2796.293
  Z.I. Macchiareddu             
  C.P. 94 - 09010 Uta (CA), Italy
____________________________________________________________________