· 8 years ago · Apr 22, 2018, 12:10 PM
1<?php
2session_start();
3include_once 'includes/dbh.inc.php';
4$sql = "CREATE TABLE IF NOT EXISTS homework(
5 homework_id int(11) not null AUTO_INCREMENT PRIMARY KEY,
6 homework_fach varchar(256) not null,
7 homework_info varchar(256) not null,
8 homework_date date not null
9 )";
10 $result = mysqli_query($con, $sql);
11
12 $sql = "CREATE TABLE IF NOT EXISTS users(
13 user_id int(11) not null AUTO_INCREMENT PRIMARY KEY,
14 user_name varchar(256) not null,
15 user_password varchar(256) not null
16 )";
17 $result = mysqli_query($con, $sql);
18$name = "admin";
19$pass = "admin";
20 $sql = "SELECT * FROM users WHERE user_name='$name'";
21 $result = mysqli_query($con, $sql);
22 $resultCheck = mysqli_num_rows($result);
23if($resultCheck > 0){
24}else{
25 $hashedpwd = password_hash($pass, PASSWORD_DEFAULT);
26 $sql = "INSERT INTO users (user_name, user_password) VALUES ('$name', '$hashedpwd');";
27 mysqli_query($con, $sql);
28 echo '<h1>Bitte ändern Sie das Passwort des Administrations-Accountes.</h1>';
29}
30?>
31
32<!DOCTYPE html>
33<html>
34<head>
35 <meta charset="UTF-8" />
36 <link rel="stylesheet" href="style.css"/>
37 <title>E-Klassenbuch</title>
38</head>
39
40<body style="background: url(Bilder/c.jpg) no-repeat center center fixed; background-size: cover;">
41 <div class="Ueberschrift">
42 <p class="titel">E-Klassenbuch</p>
43 <?php
44 if(isset($_SESSION['u_id']) && $_SESSION['u_name'] == "admin"){
45 echo '<a href="inscribe.php">Hausaufgaben eintragen</a> <a href="userpanel.php">Benutzerverwaltung</a> <a href="includes/logout.inc.php">Logout</a>';
46 }elseif(isset($_SESSION['u_id'])){
47 echo '<a href="inscribe.php">Hausaufgaben eintragen</a> <a href="includes/logout.inc.php">Logout</a>';
48 }else{
49 echo '<a href="login.php">Login</a>';
50 }
51 ?>
52 </div>
53
54
55 <?php
56 include_once 'includes/dbh.inc.php';
57 $ergebnis = mysqli_query($con, "SELECT * FROM homework ORDER BY homework_date ASC");
58 while($row = mysqli_fetch_object($ergebnis))
59 {
60 $id = $row->homework_id;
61 $wochentage = array("Sonntag", "Montag", "Dienstag", "Mittwoch", "Donnerstag", "Freitag", "Samstag");
62 $zeit = strtotime($row->homework_date);
63 $datum = date("d.m.Y",strtotime($row->homework_date));
64 $timestamp = time();
65 $dat = date("d.m.Y", $timestamp);
66 $dateTimestamp1 = strtotime($datum);
67 $dateTimestamp2 = strtotime($dat);
68 if (!$dateTimestamp1 < $dateTimestamp2) {
69 if(isset($_SESSION['u_id']) && $_SESSION['u_name'] == "admin"){
70 $datum = date("d.m.Y",strtotime($row->homework_date));
71 echo "<div class='Hausaufgaben'><a class='Hausaufgaben'> ". $wochentage[date("w", $zeit)] . " " . $datum . " " . $row->homework_fach . " " . $row->homework_info . "<a>" . "<a> <a>" . "<a class='Hausaufgaben' href='includes/delete.inc.php?id=$id'>Löschen</a> </div>";
72 }else{
73 echo "<p class='Hausaufgaben'> ". $wochentage[date("w", $zeit)] . " " . $datum . " " . $row->homework_fach . " " . $row->homework_info . "</p>";
74 }
75 }else{
76 $sql = "DELETE FROM homework WHERE homework_id='$id'";
77 $result = mysqli_query($con, $sql);
78 header("Location: index.php");
79 exit();
80 }
81 }
82 ?>
83
84
85</body>
86</html>