mirror of
https://github.com/Alvin-Zilverstand/school.git
synced 2026-03-06 11:16:54 +01:00
78 lines
2.4 KiB
PHP
78 lines
2.4 KiB
PHP
<!DOCTYPE html>
|
|
<html lang="nl">
|
|
<head>
|
|
<meta charset="UTF-8">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|
<title>Lorenzo van Matterhorn - Portofolio</title>
|
|
<link rel="stylesheet" href="style.css" >
|
|
|
|
</head>
|
|
<body>
|
|
<button class="dark-toggle" onclick="toggleDarkMode()"></button>
|
|
<header>
|
|
<h1><a href=".">Lorenzo van Matterhorn</a></h1>
|
|
<p>Student Software Developer op het Vista College</p>
|
|
<nav>
|
|
<?php require_once("mainmenu.php"); ?>
|
|
</nav>
|
|
<div class="mountains"></div>
|
|
</header>
|
|
|
|
<main>
|
|
<h1>Projecten</h1>
|
|
|
|
<?php
|
|
include 'database.inc.php';
|
|
|
|
$sql = "SELECT * FROM tb_projects";
|
|
$result = $conn->query($sql);
|
|
|
|
if ($result->num_rows > 0) {
|
|
// Output data of each row
|
|
while($row = $result->fetch_assoc()) {
|
|
$uuid = $row["uuid"];
|
|
$image = getPhoto($uuid);
|
|
|
|
echo "<h2>" . htmlspecialchars($row["name"]) . "</h2>";
|
|
echo "<p>" . htmlspecialchars($row["description"]) . "</p>";
|
|
echo "<p><a href='" . htmlspecialchars($row["url"]) . "' target='_blank'>Bekijk Project</a></p>";
|
|
echo "<hr>";
|
|
}
|
|
} else {
|
|
echo "<p>Geen projecten gevonden.</p>";
|
|
}
|
|
|
|
$conn->close();
|
|
|
|
function getPhoto($uuid) {
|
|
$sql = "SELECT * FROM tb_projectimages WHERE project_uuid = ?";
|
|
// Prepared statement om SQL-injectie te voorkomen
|
|
global $conn;
|
|
$stmt = $conn->prepare($sql);
|
|
$stmt->bind_param("s", $uuid);
|
|
$stmt->execute();
|
|
$result = $stmt->get_result();
|
|
if ($result->num_rows === 0) {
|
|
return "<img src='images/projects/default.png' alt='Default Project Image' style='max-width:200px; height:auto;'>";
|
|
}
|
|
$stmt->close();
|
|
|
|
$imagePath = "images/projects/" . $uuid . ".png";
|
|
if (file_exists($imagePath)) {
|
|
return "<img src='" . htmlspecialchars($imagePath) . "' alt='Project Image' style='max-width:200px; height:auto;'>";
|
|
} else {
|
|
return "<img src='images/projects/default.png' alt='Default Project Image' style='max-width:200px; height:auto;'>";
|
|
}
|
|
}
|
|
?>
|
|
|
|
|
|
</main>
|
|
|
|
<footer>
|
|
© <?php echo date("Y"); ?> Swarley
|
|
</footer>
|
|
<script src="script.js"></script>
|
|
</body>
|
|
</html>
|