Notizen

<!DOCTYPE html>
<html>

    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <title>TBZ-Lernseite - knk</title>
        <meta name="description" content="Meine TBZ Informationssite.">
        <link rel="stylesheet" href="../css/style.css">
        <link rel="apple-touch-icon" sizes="57x57" href="../pic/apple-icon-57x57.png">
        <link rel="apple-touch-icon" sizes="60x60" href="../pic/apple-icon-60x60.png">
        <link rel="apple-touch-icon" sizes="72x72" href="../pic/apple-icon-72x72.png">
        <link rel="apple-touch-icon" sizes="76x76" href="../pic/apple-icon-76x76.png">
        <link rel="apple-touch-icon" sizes="114x114" href="../pic/apple-icon-114x114.png">
        <link rel="apple-touch-icon" sizes="120x120" href="../pic/apple-icon-120x120.png">
        <link rel="apple-touch-icon" sizes="144x144" href="../pic/apple-icon-144x144.png">
        <link rel="apple-touch-icon" sizes="152x152" href="../pic/apple-icon-152x152.png">
        <link rel="apple-touch-icon" sizes="180x180" href="../pic/apple-icon-180x180.png">
        <link rel="icon" type="image/png" sizes="192x192"  href="../pic/android-icon-192x192.png">
        <link rel="icon" type="image/png" sizes="32x32" href="../pic/favicon-32x32.png">
        <link rel="icon" type="image/png" sizes="96x96" href="../pic/favicon-96x96.png">
        <link rel="icon" type="image/png" sizes="16x16" href="../pic/favicon-16x16.png">
        <link rel="manifest" href="../pic/manifest.json">
        <meta name="msapplication-TileColor" content="#ffffff">
        <meta name="msapplication-TileImage" content="../pic/ms-icon-144x144.png">
        <meta name="theme-color" content="#ffffff">
    </head>
    <body>
            <header id="oben">
                <div id="logo">
                <section id="logo_farbe">
                    <a href="../index.html"><img src="../pic/logo.png" alt="logo" width="300" height="120"></a>
                </section>
                </div>
                <nav>

                        <ul>

                                <li><a href="../index.html">Home</a></li>

                                <li><a href="faecher.html">Fächer</a></li>
                        </ul>

                </nav>
                </header>
                <div id="wrapper">

<?php

// Hier entsprechende Daten eintragen
$dbname = 'datenbankname';
$dbhost = 'localhost';
$dbuser = 'username';
$dbpass = 'passwort';

$dsn = 'mysql:dbname='. $dbname .';host='. $dbhost;
$pdo = new PDO($dsn, $dbuser, $dbpass);

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);


$date = $_POST["date"];
$note = $_POST["note"];
$update = $_POST['update'];

if(!isset($date) || !isset($note)) {
echo "Du hast die Felder nicht ausgefüllt..!";
} else {
    if (!isset($update)) {
        $sql = "INSERT INTO mathe SET
            date = :date,
            note = :note";

        $stmt = $pdo->prepare($sql);
        $stmt->bindValue(':date', $date, PDO::PARAM_STR);
        $stmt->bindValue(':note', $note, PDO::PARAM_STR);
    }
    else {
        $sql = "UPDATE mathe SET
            date = :date,
            note = :note
        WHERE id = :id";

        $stmt = $pdo->prepare($sql);
        $stmt->bindValue(':id', $update, PDO::PARAM_INT);
        $stmt->bindValue(':date', $date, PDO::PARAM_STR);
        $stmt->bindValue(':note', $note, PDO::PARAM_STR);
    }

    if($stmt->execute()) {
        echo 'Notes wurden gespeichert';
    } else {
        echo 'Deine Notes konnten nicht gespeichert werden, wende dich an den Admin..!<br>';
        echo $stmt->queryString .'<br>';
        echo $stmt->errorInfo()[2];
    }
}
?>

<!-- Formular für neue Einträge -->
<form action="" method="post">
    <p><label>Datum:<br><input type="text" name="date"></label></p>
    <p><label>Notizen:<br>
    <textarea name="note" cols="50" rows="8"></textarea></label></p>
    <input type="submit" value="Speichern!">
</form>

<?php
    $sql = "SELECT * FROM mathe";
    $res = $pdo->query($sql);

    foreach ($res as $row) {
?>

<!-- Vorhandene Einträge -->
<form action="" method="post">
    <input type="hidden" name="update" value="<?php echo $row->id; ?>">
    <p><label>Datum:<br><input type="text" name="date" value="<?php echo $row->date; ?>"></label></p>
    <p><label>Notizen:<br>
    <textarea name="note" cols="50" rows="8"><?php echo $row->note; ?></textarea></label></p>
    <input type="submit" value="Speichern!">
</form>
<br><br>
<?php
    }
?>

</div>


    </body>
    <footer>
        <p>&copy; 2017</p>
    </footer>
</html>