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-boun...@lists.osgeo.org> Puolesta 
Markus Lütke Brintrup
Lähetetty: keskiviikko 20. marraskuuta 2019 14.53
Vastaanottaja: mapserver-users@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
m...@wipflerplan.de<mailto:m...@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


_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to