php-schedule/schedule.php at master · padabou/php-schedule · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
<?php

try{
    include("dbconnect.php");
}catch(PDOException $e){
    var_dump($e->getMessage());
    echo "Database connexion error";
}

$bdd->query("SET NAMES 'utf8'");

if(isset($_GET['month'])) {
    $dateToGet = $_GET['month'];
} else {
    $dateToGet = date("m-Y");
}

$date = date_create_from_format("d-m-Y", "01-" . $dateToGet);
$date_next_month = date_create_from_format('d-m-Y', "01-" . $dateToGet)->add(new DateInterval('P1M'));
$date_previous_month = date_create_from_format('d-m-Y', "01-" . $dateToGet)->sub(new DateInterval('P1M'));
$labelMonth = array("00" => "December", "01" => "January", "02" => "Februar", "03" => "March", "04" => "April", "05" => "May", "06" => "June", "07" => "July", "08" => "August", "09" => "September", "10" => "October", "11" => "November", "12" => "December", "13" => "January");
$labelWeek = array("1" => "Monday", "2" => "Tuesday", "3" => "Wednesday", "4" => "Thursday", "5" => "Friday", "6" => "Saturday", "0" => "Sunday");

?>

<!DOCTYPE html>
<html lang="fr" xmlns:og="http://ogp.me/ns#">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <title>My best schedule</title>
    <meta name="description"
          content="My schedule :-)">
    <meta name="viewport" content="initial-scale=1, width=device-width" />

    <link rel="stylesheet"  type="text/css" href="css/normalize.css">
    <link rel="stylesheet"  type="text/css" href="css/main.css">
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">

</head>
<body>
<?php include "header.php"; ?>
<section>

    <article>
        <div class="wrapper">

            <div class="logo">
                <img src="img/calendar.png" alt="Logo" title="Logo"/>
            </div>
            <div class="content">
                <div id="titre" class="titre">
                    <h1><?php echo "Schedule"; ?></h1>
                    <h2><?php echo $labelMonth[$date->format("m")] . " " . $date->format("Y") ?></h2>
                </div>
                <div>
                    <a rel="nofollow" href="/schedule.php?month=<?php echo $date_previous_month->format("m-Y"); ?>"><< Previous Month</a> - <a rel="nofollow" href="/schedule.php?month=<?php echo $date_next_month->format("m-Y"); ?>">Next Month >></a>
                </div>
                <div>
                        <h2 class="titre">
                            My Schedule
                        </h2>
                        <?php
                        $event = array();
                        $sql = "SELECT e.date_event, e.description, e.label FROM `event` e  WHERE '".$date->format("m-Y")."' = DATE_FORMAT(e.date_event, '%m-%Y') order by e.date_event";
                        foreach  ($bdd->query($sql) as $row) {
                            $date_plongee = date_create_from_format("Y-m-d", $row['date_event']);

                            $event[$date_plongee->format("d")] = $row;
                        }
                        ?><div class="month">
                        <?php
                        for ($i = 1; $i <= $date->format('t'); $i++) {
                            $dateTmp = date_create_from_format("d-m-Y", $i . '-' . $dateToGet);
                            if($dateTmp->format("w") == 1 || $i == 1) {
                                echo '<div class="week">';
                            }
                            if($dateTmp->format("w") == 0 || $dateTmp->format("w") == 6) {
                                $cellStyle = "day weekend";
                            } else {
                                $cellStyle = "day";
                            }
                            echo '<div class="'.$cellStyle.'"><div class="labelDay">' . $labelWeek[$dateTmp->format("w")] . " " . $dateTmp->format("d") . "</div>";
                            if(!isset($event[ $dateTmp->format("d")])) {
                                echo "<div class='labelDayNoEvent'>No Event</div>";
                            } else {
                                if(isset($event[ $dateTmp->format("d")])) {
                                    echo "<div class='labelDayEvent'>".$event[$dateTmp->format("d")]["label"]."</div>";
                                    echo "<div class='labelDayEvent'>".$event[$dateTmp->format("d")]["description"]."</div>";
                                }
                            }
                            echo '</div>';
                            if($dateTmp->format("w") == 0) {
                                echo '</div>';
                            }
                        }
                        ?>
                    </div>
                </div>


            </div>
        </div>
    </article>
</section>
<footer>
    <div style="text-align: center">
    Image by <a href="https://pixabay.com/fr/users/skeeze-272447/?utm_source=link-attribution&utm_medium=referral&utm_campaign=image&utm_content=1237237">skeeze</a>
    </div>
</footer>
</body>
</html>