<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.Shkpostityyli18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.Shkpostityyli19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="FI" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi Markus,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">I am not sure if you’d prefer me to answer in Finnish but English is easier for the majority of readers.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">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
<a href="https://mapserver.org/mapfile/layer.html">https://mapserver.org/mapfile/layer.html</a> can also be used as a data source for templates.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">An example from an old mail <a href="http://osgeo-org.1560.x6.nabble.com/html-tags-in-GetFeatureInfo-td5224781.html">
http://osgeo-org.1560.x6.nabble.com/html-tags-in-GetFeatureInfo-td5224781.html</a> 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. <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><body> <br>
<h3>NIMI</h3> <br>
[item name=NIMI format="$value" escape=none] <br>
<h3>LISÄTIEDOT</h3> <br>
[item name=KIELLONLISATIETO format="$value" escape=none] <br>
<h3>VOIMASSAOLO</h3> <br>
[item name=VOIMASSAOLO format="$value" escape=none] <br>
<h3>YHTEYSTIEDOT</h3> <br>
[item name=YHTEYSTIEDOT format="$value" escape=none] <br>
</body><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">-Jukka Rahkonen-</span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="mso-fareast-language:FI">Lähettäjä:</span></b><span style="mso-fareast-language:FI"> mapserver-users <mapserver-users-bounces@lists.osgeo.org>
<b>Puolesta </b>Markus Lütke Brintrup<br>
<b>Lähetetty:</b> keskiviikko 20. marraskuuta 2019 14.53<br>
<b>Vastaanottaja:</b> mapserver-users@lists.osgeo.org<br>
<b>Aihe:</b> [mapserver-users] Info Template<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="DE">Hallo Liste,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE">besteht die Möglichkeit in der Template.html eines Map-Projektes eine Datenbankanbindung an zu steuern?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE">Beispiel:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"><tr><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"> <td><b>Projektname:</b></td><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"> <td>[Werte aus MYSQL-DB]</td> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"></tr><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:DE">Freundliche Grüße<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:DE">Markus Lütke Brintrup<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:DE">WipflerPLAN<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:DE">Niederlassung Donauries<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:DE">Telefon: 09081 27509-44<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:DE">Telefax: 09081 27509-50<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:blue;mso-fareast-language:DE"><a href="mailto:mlb@wipflerplan.de"><span style="color:blue">mlb@wipflerplan.de</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><u><span lang="DE" style="color:blue;mso-fareast-language:DE"><a href="http://www.wipflerplan.de/"><span style="color:blue">www.wipflerplan.de</span></a></span></u><span lang="DE" style="color:blue;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9.0pt;mso-fareast-language:DE">WipflerPLAN Planungsgesellschaft mbH<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9.0pt;mso-fareast-language:DE">Standort Nördlingen<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9.0pt;mso-fareast-language:DE">An der Lach 11a<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9.0pt;mso-fareast-language:DE">86720 Nördlingen<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9.0pt;mso-fareast-language:DE">Amtsgericht Ingolstadt HRB 190595<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9.0pt;mso-fareast-language:DE">Geschäftsführer:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9.0pt;mso-fareast-language:DE">Wilhelm Wipfler<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9.0pt;mso-fareast-language:DE">Ursula Burkart<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9.0pt;mso-fareast-language:DE">Adelheid Buchard
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
</div>
</body>
</html>