· 8 years ago · Jan 21, 2018, 11:56 AM
1<!DOCTYPE html>
2<html>
3 <head>
4 <script>
5 function goPreviousMonth(month, year) {
6 if (month == 1) {
7 --year;
8 month = 13;
9
10 }
11 document.location.href = "<?php $_SERVER['PHP_SELF']; ?>?month=" + (month - 1) + "&year=" + year;
12 }
13
14 function goNextMonth(month, year) {
15 if (month == 12) {
16 ++year;
17 month = 0;
18
19 }
20 document.location.href = "<?php $_SERVER['PHP_SELF']; ?>?month=" + (month + 1) + "&year=" + year;
21 }
22 </script>
23
24 </head>
25 <body>
26 <?php
27 mysql_connect("localhost", "root", "") or die(mysql_error());
28 echo "MySQL-hez való kapcsolódás sikeres!<br/><hr/>";
29 $sql = "CREATE DATABASE IF NOT EXISTS calendario";
30
31 mysql_select_db("calendario") or die(mysql_error());
32 echo "Adatbázishoz való kapcsolódás sikeres!<br/><hr>";
33
34 $sql = "CREATE TABLE IF NOT EXISTS eventcalendar (
35 `ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
36
37`Title` VARCHAR( 65 ) NOT NULL ,
38`Detail` VARCHAR( 255 ) NOT NULL ,
39`eventDate` VARCHAR( 10 ) NOT NULL ,
40`dateAdded` DATE NOT NULL
41`time` TIME NOT NULL,
42) ENGINE = MYISAM";
43 ?>
44 <script>
45 function goLastMonth(month, year) {
46 if (month == 1) {
47 --year;
48 month = 13;
49 }
50 --month
51 var monthstring = "" + month + "";
52 var monthlength = monthstring.length;
53 if (monthlength <= 1) {
54 monthstring = "0" + monthstring;
55 }
56 document.location.href = "<?php $_SERVER['PHP_SELF']; ?>?month=" + monthstring + "&year=" + year;
57 }
58 function goNextMonth(month, year) {
59 if (month == 12) {
60 ++year;
61 month = 0;
62 }
63 ++month
64 var monthstring = "" + month + "";
65 var monthlength = monthstring.length;
66 if (monthlength <= 1) {
67 monthstring = "0" + monthstring;
68 }
69 document.location.href = "<?php $_SERVER['PHP_SELF']; ?>?month=" + monthstring + "&year=" + year;
70 }
71 </script>
72 <style>
73 .today{
74 background-color: #00ff00;
75 }
76 .event{
77 background-color: #FF8080;
78 }
79 </style>
80 </head>
81<body>
82 <?php
83 if (isset($_GET['day'])) {
84 $day = $_GET['day'];
85 } else {
86 $day = date("j");
87 }
88 if (isset($_GET['month'])) {
89 $month = $_GET['month'];
90 } else {
91 $month = date("n");
92 }
93 if (isset($_GET['year'])) {
94 $year = $_GET['year'];
95 } else {
96 $year = date("Y");
97 }
98 $currentTimeStamp = strtotime("$day-$month-$year");
99 $monthName = date("F", $currentTimeStamp);
100 $numDays = date("t", $currentTimeStamp);
101 $counter = 0;
102 ?>
103 <?php
104 if (isset($_GET['add'])) {
105 $title = $_POST['txttitle'];
106 $detail = $_POST['txtdetail'];
107 $eventdate = $month . "/" . $day . "/" . $year;
108 $time = $_POST['time'];
109 $sqlinsert = "INSERT into eventcalendar(Title,Detail,eventDate,dateAdded) values ('" . $title . "','" . $detail . "','" . $eventdate . "',now())";
110 $resultinginsert = mysql_query($sqlinsert);
111 if ($resultinginsert) {
112 echo "Az esemény sikeresen hozzáadva!";
113 } else {
114 echo "Az eseményt nem lehetett hozzáadni";
115 }
116 }
117 ?>
118
119 <table border='0'>
120 <tr>
121 <td><input style='width:50px;' type='button' value='<'name='previousbutton' onclick ="goLastMonth(<?php echo $month . "," . $year ?>)"></td>
122 <td colspan='5'><?php echo $monthName . ", " . $year; ?></td>
123 <td><input style='width:50px;' type='button' value='>'name='nextbutton' onclick ="goNextMonth(<?php echo $month . "," . $year ?>)"></td>
124 </tr>
125 <tr>
126 <td width='50px'>Vas</td>
127 <td width='50px'>Hét</td>
128 <td width='50px'>Ke</td>
129 <td width='50px'>Sze</td>
130 <td width='50px'>Csü</td>
131 <td width='50px'>Pé</td>
132 <td width='50px'>Szo</td>
133 </tr>
134 <?php
135 echo "<tr>";
136 for ($i = 1; $i < $numDays + 1; $i++, $counter++) {
137 $timeStamp = strtotime("$year-$month-$i");
138 if ($i == 1) {
139 $firstDay = date("w", $timeStamp);
140 for ($j = 0; $j < $firstDay; $j++, $counter++) {
141 echo "<td> </td>";
142 }
143 }
144 if ($counter % 7 == 0) {
145 echo"</tr><tr>";
146 }
147 $monthstring = $month;
148 $monthlength = strlen($monthstring);
149 $daystring = $i;
150 $daylength = strlen($daystring);
151 if ($monthlength <= 1) {
152 $monthstring = "0" . $monthstring;
153 }
154 if ($daylength <= 1) {
155 $daystring = "0" . $daystring;
156 }
157 $todaysDate = date("m/d/Y");
158 $dateToCompare = $monthstring . '/' . $daystring . '/' . $year;
159 echo "<td align='center' ";
160 if ($todaysDate == $dateToCompare) {
161 echo "class ='today'";
162 } else {
163 $sqlCount = "select * from eventcalendar where eventDate='" . $dateToCompare . "'";
164 $noOfEvent = mysql_num_rows(mysql_query($sqlCount));
165 if ($noOfEvent >= 1) {
166 echo "class='event'";
167 }
168 }
169 echo "><a href='" . $_SERVER['PHP_SELF'] . "?month=" . $monthstring . "&day=" . $daystring . "&year=" . $year . "&v=true'>" . $i . "</a></td>";
170 }
171 echo "</tr>";
172 ?>
173 </table>
174 <?php
175 if (isset($_GET['v'])) {
176 echo "<hr>";
177 echo "<a href='" . $_SERVER['PHP_SELF'] . "?month=" . $month . "&day=" . $day . "&year=" . $year . "&v=true&f=true'>Esemény hozzáadás</a>";
178 if (isset($_GET['f'])) {
179 include("eventform.php");
180 }
181 $sqlEvent = "select * FROM eventcalendar where eventDate='" . $month . "/" . $day . "/" . $year . "'";
182 $resultEvents = mysql_query($sqlEvent);
183 echo "<hr>";
184 while ($events = mysql_fetch_array($resultEvents)) {
185 echo "Esemény: " . $events['Title'] . "<br>";
186 echo "LeÃrás: " . $events['Detail'] . "<br>";
187 echo "Időpont: " .$_POST['time'] . "<br>";
188 }
189 }
190 ?>
191</body>
192</html>