This repository has been archived by the owner on Apr 25, 2023. It is now read-only.
/
hoofdpagina.php
69 lines (58 loc) · 2.1 KB
/
hoofdpagina.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
<?php
include './functions.php';
include './htmlHelpers.php';
renderHtmlStart("Home", "");
?>
<div>
<?php
// welkoms text (WelkomsTtekst asshole)
$uitvoerDatabase = query("SELECT Welkomstekst FROM welkomstekst WHERE ID = 1", NULL);
foreach ($uitvoerDatabase as $value1) {
foreach ($value1 as $value2) {
echo "<h4 id='welkomstekst'>$value2</h4>";
}
}
?>
</div>
<?php // slider ?>
<script src="slider.js"></script>
<div class="slider2">
<a href="#" class="control_next"><span class="glyphicon glyphicon-chevron-right"></span></a>
<a href="#" class="control_prev"><span class="glyphicon glyphicon-chevron-left"></span></a>
<div id="slider">
<ul>
<?php
// schilderijen voor slider ophalen uit database
$categorieen = query("SELECT CategorieID FROM schilderij WHERE OpWebsite = 1 GROUP BY CategorieID HAVING COUNT(*) >= 3 LIMIT 0,5", null);
$query = "";
$union = "";
$param = [];
$j = 1;
foreach ($categorieen as $cat) {
$query .= $union . "SELECT Schilderij_ID, Titel, Img FROM schilderij WHERE OpWebsite = 1 AND CategorieID = " . $cat["CategorieID"] . " LIMIT 0," . $j * 3;
$param[] = $cat["CategorieID"];
$union = " UNION ";
$j++;
}
$schilderijen = query($query, $param);
$i = 0;
foreach ($schilderijen as $schilderij) {
if ($i % 3 == 0 && $i != count($schilderijen)) {
echo "<li>";
}
echo "<a href='/schilderij.php?id=" . $schilderij["Schilderij_ID"] . "'>";
echo "<div style='background-image:url(\"/content/uploads/small_" . $schilderij["Img"] . "\"); '></div>";
echo "<span class='slider-titel'>" . $schilderij["Titel"] . "</span>";
echo "</a>";
$i++;
if ($i % 3 == 0) {
echo "</li>";
}
}
?>
</ul>
</div>
</div>
<?php
renderHtmlEnd();
?>