1.Loonud uue tabeli ja täitsin selle andmetega https://www.mockaroo.com/
2.Teisendas SQL-tabeli XML-failiks
PHP kood:
JQuery kood:
json kood:
ASP.net projekti avalikustamine zone.ee serveril
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
>
<xsl:output method="html" indent="yes"/>
<xsl:template match="/">
<html>
<head>
<title>Reiside nimekiri</title>
<style>
body { font-family: Arial, sans-serif; margin: 20px; }
.reis { border: 2px solid #333; margin: 15px 0; padding: 15px; background: #f9f9f9; }
.kallim { color: #c00; font-size: 18px; }
.hea { background: #e8f5e8; }
.hiina { background: #e6f3ff; }
table { width: 100%; border: 1px solid #666; }
th { background: #333; color: white; padding: 8px; }
td { padding: 6px; border-bottom: 1px solid #ddd; }
</style>
</head>
<body>
<h1>Kõik reisid</h1>
<xsl:for-each select="reisid/reis">
<xsl:sort select="number(translate(translate(hind, '€', ''), ',', '.'))" order="ascending"/>
<div class="reis">
<h2>
<xsl:value-of select="sihtkoht"/>
</h2>
<p>
<strong>Lennujaam:</strong>
<xsl:value-of select="lennujaam"/>
</p>
<xsl:variable name="hind" select="number(translate(translate(hind, '€', ''), ',', '.'))"/>
<p>
<strong>Hind:</strong>
<span class="{concat('hind', $hind > 200)}">
<xsl:value-of select="hind"/>
</span>
</p>
<div style="background: #fffacd; padding: 10px; margin: 10px 0;">
<p>
<strong>Lennu number:</strong>
<xsl:value-of select="lennu_number"/>
</p>
<p>
<strong>Kestus:</strong> <xsl:value-of select="lennu_kestus"/> tundi
</p>
<p>
<strong>Alates:</strong>
<xsl:value-of select="normalize-space(algus)"/>
</p>
<p>
<strong>Kuni:</strong>
<xsl:value-of select="normalize-space(lopp)"/>
</p>
</div>
</div>
</xsl:for-each>
<h1>Hiina reisid</h1>
<xsl:for-each select="reisid/reis[sihtkoht='China']">
<div class="reis hiina">
<h3>
<xsl:value-of select="lennujaam"/> - <xsl:value-of select="hind"/>
</h3>
<p>
Lenn #<xsl:value-of select="lennu_number"/> | <xsl:value-of select="lennu_kestus"/>h | <xsl:value-of select="algus"/> - <xsl:value-of select="lopp"/>
</p>
</div>
</xsl:for-each>
<h1>Tabel</h1>
<table>
<tr>
<th>Sihtkoht</th>
<th>Lennujaam</th>
<th>Hind</th>
<th>Lennu number</th>
<th>Kestus</th>
<th>Algus</th>
<th>Lõpp</th>
</tr>
<xsl:for-each select="reisid/reis">
<xsl:variable name="klass">
<xsl:if test="lennu_kestus > 3"> hea</xsl:if>
<xsl:if test="sihtkoht='China'"> hiina</xsl:if>
</xsl:variable>
<tr class="{$klass}">
<td>
<xsl:value-of select="sihtkoht"/>
</td>
<td>
<xsl:value-of select="lennujaam"/>
</td>
<td>
<xsl:if test="number(translate(translate(hind, '€', ''), ',', '.')) > 200">
<xsl:attribute name="style">color: #c00; font-weight: bold;</xsl:attribute>
</xsl:if>
<xsl:value-of select="hind"/>
</td>
<td>
<xsl:value-of select="lennu_number"/>
</td>
<td>
<xsl:value-of select="lennu_kestus"/>
</td>
<td>
<xsl:value-of select="normalize-space(algus)"/>
</td>
<td>
<xsl:value-of select="normalize-space(lopp)"/>
</td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>