I've writing html in a php-file because I want to add php-code. I created a form which was visible. After I add the php code the form wasn't visible on my website. The table that is in the php code is also invisible.
The php code is customized to my MySQL Database.
<!DOCTYPE html>
<html>
<head>
<title>Anmeldung</title>
<meta charset="UTF-8">
<meta name="description" content="">
<meta name="author" content="">
<meta name="keywords" content="">
<meta name="generator" content="Webocton - Scriptly (www.scriptly.de)">
<link href="style.css" type="text/css" rel="stylesheet">
</head>
<body>
<h1 class="Titeltext">Anmeldung</h1>
<?php include('navbar.html'); ?>
<br />
<br />
<br />
<?php
require 'inc/db.php';
if (isset($_POST['aktion']) and $_POST['aktion']=='anmelden') {
$wettbewerb = "";
if (isset($_POST['wettbewerb'])) {
$wettbewerb = trim($_POST['wettbewerb']);
}
$nickname = "";
if (isset($_POST['nickname'])) {
$nickname = trim($_POST['nickname'])
}
$erstellt = date("Y-m-d H:i:s");
if ( $wettbewerb != '' or $nickname != '' )
{
// speichern
$einfuegen = $db->prepare("
INSERT INTO anmeldung (wettbewerb, nickname, erstellt)
VALUES (?, ?, NOW())
");
$einfuegen->bind_param('sss', $wettbewerb, $nickname);
if ($einfuegen->execute()) {
header('Location: anmeldung.php?aktion=anmeldunggespeichert');
die();
echo "<h1>angemeldet</h1>";
}
}
}
if (isset($_GET['aktion']) and $_GET['aktion']=='anmeldunggespeichert') {
echo '<p class="anmeldungerfolg">Deine Anmeldung wurde gespeichert</p>';
}
$daten = array();
if ($erg = $db->query("SELECT * FROM anmeldung")) {
if ($erg->num_rows) {
while($datensatz = $erg->fetch_object()) {
$daten[] = $datensatz;
}
$erg->free();
}
}
if (!count($daten)) {
echo "<p>Es liegen keine Daten vor :(</p>";
} else {
?>
<table>
<thead>
<tr>
<th>Wettbewerb</th>
<th>Nickname</th>
<th>erstellt</th>
</tr>
</thead>
<tbody>
<?php
foreach ($daten as $inhalt) {
?>
<tr>
<td><?php echo $inhalt->wettbewerb; ?></td>
<td><?php echo bereinigen($inhalt->nickname); ?></td>
<td><?php echo $inhalt->erstellt; ?></td>
</tr>
<?php
}
?>
</tbody>
</table>
<?php
}
function bereinigen($inhalt='') {
$inhalt = trim($inhalt);
$inhalt = htmlentities($inhalt, ENT_QUOTES, "UTF-8");
return($inhalt);
}
?>
<form action="" method="post">
<label>Wettbewerb:
<select name="top5" size="5">
<option>FCS</option>
<option>Team Liga</option>
<option>Premiere League</option>
</select>
</label>
<label>Nickname:
<input type="text" name="nickname" id="nickname">
</label>
<input type="hidden" name="aktion" value="anmelden">
<input type="submit" value="anmelden">
</form>
</body>
</html>