[mapserver-users] Querying an external database

Thu, 18 Jul 2002 14:18:30 +0200

This is a multi-part message in MIME format.

------=_NextPart_000_0023_01C22E65.FDC86AE0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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@crs4.it=20
  CRS4 - GIS                =20
  Sesta Strada Ovest              Phone: +39 070 2796.293
  Z.I. Macchiareddu            =20
  C.P. 94 - 09010 Uta (CA), Italy
____________________________________________________________________

------=_NextPart_000_0023_01C22E65.FDC86AE0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial>Hi all,</FONT></DIV>
<DIV><FONT face=3DArial></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial>I'd like to build an&nbsp;application which =
allow the user=20
to query an external database, for example querying the attribute table =
in MySQl=20
or Access<BR>database, and gets a list of ID. Then&nbsp;I need to query=20
the&nbsp;shapefile to highlight all the returned ID.<BR></FONT></DIV>
<DIV><FONT face=3DArial>How can I do this?</FONT></DIV>
<DIV><FONT face=3DArial>How can I link the returned ID from the external =
database=20
with the shapefile&nbsp;ID?<BR>How can I&nbsp;query the&nbsp;shapefile =
and=20
highlight the results in PHP/MapScript ?</FONT></DIV>
<DIV><FONT face=3DArial>Can anyone&nbsp;send me an =
example?<BR><BR><BR>Thanks very=20
much</FONT></DIV>
<DIV><FONT face=3DArial>&nbsp;</DIV></FONT>
<DIV><FONT face=3DArial=20
size=3D2>________________________________________________________________=
____</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; Alessandro=20
Cadeddu&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
E-mail: <A href=3D"mailto:acadeddu@crs4.it">acadeddu@crs4.it</A> =
<BR>&nbsp; CRS4 -=20
GIS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>&nbsp; Sesta Strada=20
Ovest&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;=20
Phone: +39 070 2796.293<BR>&nbsp; Z.I.=20
Macchiareddu&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;=20
<BR>&nbsp; C.P. 94 - 09010 Uta (CA),=20
Italy<BR>________________________________________________________________=
____</FONT></DIV></BODY></HTML>

------=_NextPart_000_0023_01C22E65.FDC86AE0--