Mehrere Formularfunktionen in PHP:
Sort:
$sort_by = "kunden_id";
$order = "ASC";
if (isset($_GET['sort'])) {
// Überprüfen, ob die Sortierparameter gültig sind
if ($_GET['sort'] == 'kunden_id' || $_GET['sort'] == 'vname' || $_GET['sort'] == 'nname' || $_GET['sort'] == 'age') {
$sort_by = $_GET['sort'];
$order = ($_GET['order'] == 'asc') ? 'ASC' : 'DESC';
}
}
$sql = "SELECT kunden_id, vname, nname, age FROM kunden ORDER BY $sort_by $order";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo "<table border='1'>
<tr>
<th><a href='?sort=kunden_id&order=". ($sort_by == 'kunden_id' && $order == 'ASC' ? 'desc' : 'asc') ."'>Kunden ID</a></th>
<th><a href='?sort=vname&order=". ($sort_by == 'vname' && $order == 'ASC' ? 'desc' : 'asc') ."'>Vorname</a></th>
<th><a href='?sort=nname&order=". ($sort_by == 'nname' && $order == 'ASC' ? 'desc' : 'asc') ."'>Nachname</a></th>
<th><a href='?sort=age&order=". ($sort_by == 'age' && $order == 'ASC' ? 'desc' : 'asc') ."'>Alter</a></th>
</tr>";
while($row = $result->fetch_assoc()) {
echo "<tr>
<td>" . $row["kunden_id"]. "</td>
<td>" . $row["vname"]. " </td>
<td>" . $row["nname"]. "</td>
<td>" . $row["age"]. "</td>
</tr>";
}
echo "</table>";
}
else {
echo "0 Ergebnisse";
}
$conn->close();
?>
Tabellen anzeigen lassen:
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "lap";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT kunden_id, vname, nname, age FROM kunden Order by kunden_id";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo "<table border='1'>
<tr>
<th>Kunden ID</th>
<th>Vorname</th>
<th>Nachname</th>
<th>Alter</th>
</tr>";
// output data of each row
while($row = $result->fetch_assoc()) {
echo "<tr>
<td>" . $row["kunden_id"]. "</td>
<td>" . $row["vname"]. " </td>
<td>" . $row["nname"]. "</td>
<td>" . $row["age"]. "</td>
</tr>";
}
echo "</table>";
}
else {
echo "0 results";
}
$conn->close();
?>
QR-Code:
<!DOCTYPE html>
<html lang="de">
<head>
<meta charset="UTF-8">
<title>QR-Code Generator</title>
<script src="https://cdn.jsdelivr.net/npm/qr-code-styling@1.5.0/lib/qr-code-styling.js"></script>
<style>
body {
font-family: Arial, sans-serif;
display: flex;
flex-direction: column;
align-items: center;
margin-top: 50px;
}
#qrcode {
margin-top: 20px;
}
button {
margin-top: 10px;
}
</style>
</head>
<body>
<h1>QR-Code Generator</h1>
<form id="qrForm">
<label for="url">Gib eine URL ein:</label>
<input type="text" id="url" name="url" required>
<button type="submit">Generiere QR-Code</button>
</form>
<div id="qrcode"></div>
<button id="downloadBtn" style="display:none;">QR-Code herunterladen</button>
<script>
const qrCode = new QRCodeStyling({
width: 300,
height: 300,
type: "png",
data: "",
image: "",
dotsOptions: {
color: "#000",
type: "rounded"
},
backgroundOptions: {
color: "#fff",
}
});
document.getElementById("qrForm").addEventListener("submit", function(event) {
event.preventDefault();
const url = document.getElementById("url").value;
qrCode.update({
data: url
});
document.getElementById("qrcode").innerHTML = "";
qrCode.append(document.getElementById("qrcode"));
document.getElementById("downloadBtn").style.display = "block";
});
document.getElementById("downloadBtn").addEventListener("click", function() {
qrCode.download({ name: "qrcode", extension: "png" });
});
</script>
</body>
</html>