[mapserver-users] Info Template

Wed Nov 20 05:29:15 PST 2019

Hi Markus,

I am not sure if you'd prefer me to answer in Finnish but English is easier for the majority of readers.

Certainly it is possible to use data from a database with templates yes but you did not tell the details about for what purpose you are trying to use the templates. The DATA (perhaps with CONNECTION) that is used in LAYER https://mapserver.org/mapfile/layer.html can also be used as a data source for templates.

An example from an old mail http://osgeo-org.1560.x6.nabble.com/html-tags-in-GetFeatureInfo-td5224781.html contains a template that defines the html format of GetFeatureInfo. Each "item name" is a name of the attribute in the source data. If vector data for the LAYER comes from MYSQL then the attributes are read from MYSQL as well.

<body>
<h3>NIMI</h3>
     [item name=NIMI format="$value" escape=none]
<h3>LISÄTIEDOT</h3>
     [item name=KIELLONLISATIETO format="$value" escape=none]
<h3>VOIMASSAOLO</h3>
     [item name=VOIMASSAOLO format="$value" escape=none]
<h3>YHTEYSTIEDOT</h3>
     [item name=YHTEYSTIEDOT format="$value" escape=none]
 </body>

-Jukka Rahkonen-

Lähettäjä: mapserver-users <mapserver-users-bounces at lists.osgeo.org> Puolesta Markus Lütke Brintrup
Lähetetty: keskiviikko 20. marraskuuta 2019 14.53
Vastaanottaja: mapserver-users at lists.osgeo.org
Aihe: [mapserver-users] Info Template

Hallo Liste,

besteht die Möglichkeit in der Template.html eines Map-Projektes eine Datenbankanbindung an zu steuern?
Beispiel:
<tr>
    <td><b>Projektname:</b></td>
    <td>[Werte aus MYSQL-DB]</td>
</tr>

Freundliche Grüße

Markus Lütke Brintrup

WipflerPLAN
Niederlassung Donauries

Telefon: 09081 27509-44
Telefax: 09081 27509-50
mlb at wipflerplan.de<mailto:mlb at wipflerplan.de>
www.wipflerplan.de<http://www.wipflerplan.de/>

WipflerPLAN Planungsgesellschaft mbH
Standort Nördlingen
An der Lach 11a
86720 Nördlingen
Amtsgericht Ingolstadt HRB 190595
Geschäftsführer:
Wilhelm Wipfler
Ursula Burkart
Adelheid Buchard

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20191120/c5962cc4/attachment.html>