· 8 years ago · May 16, 2018, 08:00 PM
1---------------------------index.php
2<!DOCTYPE html>
3<html>
4 <head>
5 <meta charset="UTF-8">
6 <title>Üzemmód választás</title>
7 </head>
8 <body style="text-align: center">
9 <h1>Határidőnapló</h1>
10 <h2>Válasszon a funkciók közül:</h2>
11 <input type="button" value="Napi teendők" onclick="window.location.href='napi.php'" style="width: 150px; height: 40px"/>
12 <input type="button" value="Heti teendők" onclick="window.location.href='heti.php'" style="width: 150px; height: 40px"/>
13 </body>
14</html>
15
16----------------------------------napi.php
17
18<!DOCTYPE html>
19 <?php
20 $datum = date("Y-m-d");
21 //Adatbázis létrehozása
22 $conn = new mysqli("localhost", "root", "");
23 if ($conn->connect_error) {die("Kapcsolódási hiba: " . $conn->connect_error);}
24 $sqldb = "CREATE DATABASE IF NOT EXISTS hataridonaplos_feladat CHARACTER SET utf8 COLLATE utf8_hungarian_ci;";
25 if ($conn->query($sqldb) === TRUE) {} else {echo "Sikertelen az adatbázis létrehozás: " . $conn->error;}
26 $conn->close();
27 //Tábla létrehozása
28 $conn = new mysqli("localhost", "root", "", "hataridonaplos_feladat");
29 $sqltabla = "CREATE TABLE IF NOT EXISTS `napi` (
30 `nap` VARCHAR(20),
31 `8` VARCHAR(20),
32 `9` VARCHAR(20),
33 `10` VARCHAR(20),
34 `11` VARCHAR(20),
35 `12` VARCHAR(20),
36 `13` VARCHAR(20),
37 `14` VARCHAR(20),
38 `15` VARCHAR(20),
39 `16` VARCHAR(20),
40 `17` VARCHAR(20),
41 `18` VARCHAR(20),
42 `19` VARCHAR(20)
43 )";
44 if ($conn->query($sqltabla) === TRUE) {} else {echo "Sikertelen az tábla létrehozás: " . $conn->error;}
45 $conn->close();
46 //mentés gomb lenyomására
47 if ($_SERVER["REQUEST_METHOD"] == "POST") {
48 $ment8 = $_REQUEST["8"];
49 $ment9 = $_REQUEST["9"];
50 $ment10 = $_REQUEST["10"];
51 $ment11 = $_REQUEST["11"];
52 $ment12 = $_REQUEST["12"];
53 $ment13 = $_REQUEST["13"];
54 $ment14 = $_REQUEST["14"];
55 $ment15 = $_REQUEST["15"];
56 $ment16 = $_REQUEST["16"];
57 $ment17 = $_REQUEST["17"];
58 $ment18 = $_REQUEST["18"];
59 $ment19 = $_REQUEST["19"];
60 //adatbázis feltöltés
61 $conn = mysqli_connect("localhost", "root", "", "hataridonaplos_feladat");
62 $sql = "SELECT * FROM napi WHERE nap = ?";
63 if ($stmt = mysqli_prepare($conn, $sql)) {
64 mysqli_stmt_bind_param($stmt, "s", $datum);
65 if (mysqli_stmt_execute($stmt)) {
66 mysqli_stmt_store_result($stmt);
67 if (mysqli_stmt_num_rows($stmt) == 1) {
68 $sqlekezet = "set names 'utf8'";
69 if ($conn->query($sqlekezet) === TRUE) {} else {echo "Hibás parancs: " . $sqlekezet . "<br>" . $conn->error;}
70 if (mysqli_query($conn, "UPDATE `napi` SET
71 `8` = '$ment8',
72 `9` = '$ment9',
73 `10` = '$ment10',
74 `11` = '$ment11',
75 `12` = '$ment12',
76 `13` = '$ment13',
77 `14` = '$ment14',
78 `15` = '$ment15',
79 `16` = '$ment16',
80 `17` = '$ment17',
81 `18` = '$ment18',
82 `19` = '$ment19'
83 WHERE `nap` = '$datum'")) {
84 } else {die("Az adatai mentése meghiúsult!");}
85 } else {
86 $sqlekezet = "set names 'utf8'";
87 if ($conn->query($sqlekezet) === TRUE) {} else {echo "Hibás parancs: " . $sqlekezet . "<br>" . $conn->error;}
88 if (mysqli_query($conn, "INSERT INTO `napi`
89 (`nap`,`8`,`9`,`10`,`11`,`12`,`13`,`14`,`15`,`16`,`17`,`18`,`19`)
90 VALUES
91 ('$datum','$ment8','$ment9','$ment10','$ment11','$ment12','$ment13','$ment14','$ment15','$ment16','$ment17','$ment18','$ment18');")) {
92 } else {die("Az adatai mentése meghiúsult!");}
93 }
94 } else {die("error");}
95 }
96 mysqli_stmt_close($stmt);
97 $conn->close();}
98 //helyettesÃtÅ‘ adatok kiolvasása
99 $conn = new mysqli("localhost", "root", "", "hataridonaplos_feladat");
100 $adatok = mysqli_query($conn, "SELECT `8`, `9`, `10`, `11`, `12`, `13`, `14`, `15`, `16`, `17`, `18`, `19` FROM napi WHERE nap = '$datum'");
101 $adat = mysqli_fetch_array($adatok);
102 $tolt8 = $adat["8"];
103 $tolt9 = $adat["9"];
104 $tolt10 = $adat["10"];
105 $tolt11 = $adat["11"];
106 $tolt12 = $adat["12"];
107 $tolt13 = $adat["13"];
108 $tolt14 = $adat["14"];
109 $tolt15 = $adat["15"];
110 $tolt16 = $adat["16"];
111 $tolt17 = $adat["17"];
112 $tolt18 = $adat["18"];
113 $tolt19 = $adat["19"];
114 $conn->close();
115 ?>
116<html>
117 <head>
118 <meta charset="UTF-8">
119 <title>Napi teendők</title>
120 </head>
121 <body style="text-align: center">
122 <h1>Napi teendők:</h1>
123 <h3>Ezen a napon: <?php echo $datum;?></h3>
124 <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post">
125 <table style="text-align: center; width: 300px; margin: auto;">
126 <tr>
127 <td><b>Mikor?</b></td>
128 <td><b>Teendő:</b></td>
129 </tr>
130 <tr>
131 <td>08:00-09:00</td>
132 <td><input type="text" name="8" placeholder="Szabad" value="<?php echo $tolt8; ?>"></td>
133 </tr>
134 <tr>
135 <td>09:00-10:00</td>
136 <td><input type="text" name="9" placeholder="Szabad" value="<?php echo $tolt9; ?>"></td>
137 </tr>
138 <tr>
139 <td>10:00-11:00</td>
140 <td><input type="text" name="10" placeholder="Szabad" value="<?php echo $tolt10; ?>"></td>
141 </tr>
142 <tr>
143 <td>11:00-12:00</td>
144 <td><input type="text" name="11" placeholder="Szabad" value="<?php echo $tolt11; ?>"></td>
145 </tr>
146 <tr>
147 <td>12:00-13:00</td>
148 <td><input type="text" name="12" placeholder="Szabad" value="<?php echo $tolt12; ?>"></td>
149 </tr>
150 <tr>
151 <td>13:00-14:00</td>
152 <td><input type="text" name="13" placeholder="Szabad" value="<?php echo $tolt13; ?>"></td>
153 </tr>
154 <tr>
155 <td>14:00-15:00</td>
156 <td><input type="text" name="14" placeholder="Szabad" value="<?php echo $tolt14; ?>"></td>
157 </tr>
158 <tr>
159 <td>15:00-16:00</td>
160 <td><input type="text" name="15" placeholder="Szabad" value="<?php echo $tolt15; ?>"></td>
161 </tr>
162 <tr>
163 <td>16:00-17:00</td>
164 <td><input type="text" name="16" placeholder="Szabad" value="<?php echo $tolt16; ?>"></td>
165 </tr>
166 <tr>
167 <td>17:00-18:00</td>
168 <td><input type="text" name="17" placeholder="Szabad" value="<?php echo $tolt17; ?>"></td>
169 </tr>
170 <tr>
171 <td>18:00-19:00</td>
172 <td><input type="text" name="18" placeholder="Szabad" value="<?php echo $tolt18; ?>"></td>
173 </tr>
174 <tr>
175 <td>19:00-20:00</td>
176 <td><input type="text" name="19" placeholder="Szabad" value="<?php echo $tolt19; ?>"></td>
177 </tr>
178 </table>
179 <br/>
180 <input type="submit" value="Mentés" name="mentes" style="width: 100px; height: 40px" />
181 <input type="button" value="Vissza" name="vissza" style="width: 100px; height: 40px" onclick="window.location.href='index.php'" />
182 </form>
183 </body>
184</html>
185
186
187-------------------------------------heti.php
188
189<!DOCTYPE html>
190 <?php
191 $datum = date("Y-m-d");
192 $date = new DateTime($datum);
193 $het = $date->format("W");
194 //Adatbázis létrehozása
195 $conn = new mysqli("localhost", "root", "");
196 if ($conn->connect_error) {die("Kapcsolódási hiba: " . $conn->connect_error);}
197 $sqldb = "CREATE DATABASE IF NOT EXISTS hataridonaplos_feladat CHARACTER SET utf8 COLLATE utf8_hungarian_ci;";
198 if ($conn->query($sqldb) === TRUE) {} else {echo "Sikertelen az adatbázis létrehozás: " . $conn->error;}
199 $conn->close();
200 //Tábla létrehozása
201 $conn = new mysqli("localhost", "root", "", "hataridonaplos_feladat");
202 $sqltabla = "CREATE TABLE IF NOT EXISTS `heti` (
203 `het` VARCHAR(20),
204 `hede` VARCHAR(20),
205 `kede` VARCHAR(20),
206 `szede` VARCHAR(20),
207 `csude` VARCHAR(20),
208 `pede` VARCHAR(20),
209 `szode` VARCHAR(20),
210 `vade` VARCHAR(20),
211 `hedu` VARCHAR(20),
212 `kedu` VARCHAR(20),
213 `szedu` VARCHAR(20),
214 `csudu` VARCHAR(20),
215 `pedu` VARCHAR(20),
216 `szodu` VARCHAR(20),
217 `vadu` VARCHAR(20),
218 `hees` VARCHAR(20),
219 `kees` VARCHAR(20),
220 `szees` VARCHAR(20),
221 `csues` VARCHAR(20),
222 `pees` VARCHAR(20),
223 `szoes` VARCHAR(20),
224 `vaes` VARCHAR(20)
225 )";
226 if ($conn->query($sqltabla) === TRUE) {} else {echo "Sikertelen az tábla létrehozás: " . $conn->error;}
227 $conn->close();
228 //mentés gomb lenyomására
229 if ($_SERVER["REQUEST_METHOD"] == "POST") {
230 $mhede = $_REQUEST["hede"];
231 $mkede = $_REQUEST["kede"];
232 $mszede = $_REQUEST["szede"];
233 $mcsude = $_REQUEST["csude"];
234 $mpede = $_REQUEST["pede"];
235 $mszode = $_REQUEST["szode"];
236 $mvade = $_REQUEST["vade"];
237 $mhedu = $_REQUEST["hedu"];
238 $mkedu = $_REQUEST["kedu"];
239 $mszedu = $_REQUEST["szedu"];
240 $mcsudu = $_REQUEST["csudu"];
241 $mpedu = $_REQUEST["pedu"];
242 $mszodu = $_REQUEST["szodu"];
243 $mvadu = $_REQUEST["vadu"];
244 $mhees = $_REQUEST["hees"];
245 $mkees = $_REQUEST["kees"];
246 $mszees = $_REQUEST["szees"];
247 $mcsues = $_REQUEST["csues"];
248 $mpees = $_REQUEST["pees"];
249 $mszoes = $_REQUEST["szoes"];
250 $mvaes = $_REQUEST["vaes"];
251 //adatbázis feltöltés
252 $conn = mysqli_connect("localhost", "root", "", "hataridonaplos_feladat");
253 $sql = "SELECT * FROM heti WHERE het = ?";
254 if ($stmt = mysqli_prepare($conn, $sql)) {
255 mysqli_stmt_bind_param($stmt, "s", $het);
256 if (mysqli_stmt_execute($stmt)) {
257 mysqli_stmt_store_result($stmt);
258 if (mysqli_stmt_num_rows($stmt) == 1) {
259 $sqlekezet = "set names 'utf8'";
260 if ($conn->query($sqlekezet) === TRUE) {} else {echo "Hibás parancs: " . $sqlekezet . "<br>" . $conn->error;}
261 if (mysqli_query($conn, "UPDATE `heti` SET
262 `hede` = '$mhede',
263 `kede` = '$mkede',
264 `szede` = '$mszede',
265 `csude` = '$mcsude',
266 `pede` = '$mpede',
267 `szode` = '$mszode',
268 `vade` = '$mvade',
269 `hedu` = '$mhedu',
270 `kedu` = '$mkedu',
271 `szedu` = '$mszedu',
272 `csudu` = '$mcsudu',
273 `pedu` = '$mpedu',
274 `szodu` = '$mszodu',
275 `vadu` = '$mvadu',
276 `hees` = '$mhees',
277 `kees` = '$mkees',
278 `szees` = '$mszees',
279 `csues` = '$mcsues',
280 `pees` = '$mpees',
281 `szoes` = '$mszoes',
282 `vaes` = '$mvaes'
283 WHERE `het` = '$het'")) {
284 } else {die("Az adatai mentése meghiúsult!");}
285 } else {
286 $sqlekezet = "set names 'utf8'";
287 if ($conn->query($sqlekezet) === TRUE) {} else {echo "Hibás parancs: " . $sqlekezet . "<br>" . $conn->error;}
288 if (mysqli_query($conn, "INSERT INTO `heti`
289 (`het`,`hede`,`kede`,`szede`,`csude`,`pede`,`szode`,`vade`,`hedu`,`kedu`,`szedu`,`csudu`,`pedu`,`szodu`,`vadu`,`hees`,`kees`,`szees`,`csues`,`pees`,`szoes`,`vaes`)
290 VALUES
291 ('$het','$mhede','$mkede','$mszede','$mcsude','$mpede','$mszode','$mvade','$mhedu','$mkedu','$mszedu','$mcsudu','$mpedu','$mszodu','$mvadu','$mhees','$mkees','$mszees','$mcsues','$mpees','$mszoes','$mvaes');")) {
292 } else {die("Az adatai mentése meghiúsult!");}
293 }
294 } else {die("error");}
295 }
296 mysqli_stmt_close($stmt);
297 $conn->close();}
298 //helyettesÃtÅ‘ adatok kiolvasása
299 $conn = new mysqli("localhost", "root", "", "hataridonaplos_feladat");
300 $adatok = mysqli_query($conn, "SELECT `hede`,`kede`,`szede`,`csude`,`pede`,`szode`,`vade`,`hedu`,`kedu`,`szedu`,`csudu`,`pedu`,`szodu`,`vadu`,`hees`,`kees`,`szees`,`csues`,`pees`,`szoes`,`vaes` FROM heti WHERE het = '$het'");
301 $adat = mysqli_fetch_array($adatok);
302 $hede = $adat["hede"];
303 $kede = $adat["kede"];
304 $szede = $adat["szede"];
305 $csude = $adat["csude"];
306 $pede = $adat["pede"];
307 $szode = $adat["szode"];
308 $vade = $adat["vade"];
309 $hedu = $adat["hedu"];
310 $kedu = $adat["kedu"];
311 $szedu = $adat["szedu"];
312 $csudu = $adat["csudu"];
313 $pedu = $adat["pedu"];
314 $szodu = $adat["szodu"];
315 $vadu = $adat["vadu"];
316 $hees = $adat["hees"];
317 $kees = $adat["kees"];
318 $szees = $adat["szees"];
319 $csues = $adat["csues"];
320 $pees = $adat["pees"];
321 $szoes = $adat["szoes"];
322 $vaes = $adat["vaes"];
323 $conn->close();
324 ?>
325<html>
326 <head>
327 <meta charset="UTF-8">
328 <title>Napi teendők</title>
329 </head>
330 <body style="text-align: center">
331 <h1>Heti teendők:</h1>
332 <h3>Ezen a héten: <?php echo $het;?>. hét</h3>
333 <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post">
334 <table style="text-align: center; width: 300px; margin: auto;">
335 <tr>
336 <td><b>Mikor?</b></td>
337 <td><b>Hétfő</b></td>
338 <td><b>Kedd</b></td>
339 <td><b>Szerda</b></td>
340 <td><b>Csütörtök</b></td>
341 <td><b>Péntek</b></td>
342 <td><b>Szombat</b></td>
343 <td><b>Vasárnap</b></td>
344 </tr>
345 <tr>
346 <td><b>Délelőtt</b></td>
347 <td><input type="text" name="hede" placeholder="Szabad" value="<?php echo $hede; ?>"></td>
348 <td><input type="text" name="kede" placeholder="Szabad" value="<?php echo $kede; ?>"></td>
349 <td><input type="text" name="szede" placeholder="Szabad" value="<?php echo $szede; ?>"></td>
350 <td><input type="text" name="csude" placeholder="Szabad" value="<?php echo $csude; ?>"></td>
351 <td><input type="text" name="pede" placeholder="Szabad" value="<?php echo $pede; ?>"></td>
352 <td><input type="text" name="szode" placeholder="Szabad" value="<?php echo $szode; ?>"></td>
353 <td><input type="text" name="vade" placeholder="Szabad" value="<?php echo $vade; ?>"></td>
354 </tr>
355 <tr>
356 <td><b>Délután</b></td>
357 <td><input type="text" name="hedu" placeholder="Szabad" value="<?php echo $hedu; ?>"></td>
358 <td><input type="text" name="kedu" placeholder="Szabad" value="<?php echo $kedu; ?>"></td>
359 <td><input type="text" name="szedu" placeholder="Szabad" value="<?php echo $szedu; ?>"></td>
360 <td><input type="text" name="csudu" placeholder="Szabad" value="<?php echo $csudu; ?>"></td>
361 <td><input type="text" name="pedu" placeholder="Szabad" value="<?php echo $pedu; ?>"></td>
362 <td><input type="text" name="szodu" placeholder="Szabad" value="<?php echo $szodu; ?>"></td>
363 <td><input type="text" name="vadu" placeholder="Szabad" value="<?php echo $vadu; ?>"></td>
364 </tr>
365 <tr>
366 <td><b>Este</b></td>
367 <td><input type="text" name="hees" placeholder="Szabad" value="<?php echo $hees; ?>"></td>
368 <td><input type="text" name="kees" placeholder="Szabad" value="<?php echo $kees; ?>"></td>
369 <td><input type="text" name="szees" placeholder="Szabad" value="<?php echo $szees; ?>"></td>
370 <td><input type="text" name="csues" placeholder="Szabad" value="<?php echo $csues; ?>"></td>
371 <td><input type="text" name="pees" placeholder="Szabad" value="<?php echo $pees; ?>"></td>
372 <td><input type="text" name="szoes" placeholder="Szabad" value="<?php echo $szoes; ?>"></td>
373 <td><input type="text" name="vaes" placeholder="Szabad" value="<?php echo $vaes; ?>"></td>
374 </tr>
375 </table>
376 <br/>
377 <input type="submit" value="Mentés" name="mentes" style="width: 100px; height: 40px" />
378 <input type="button" value="Vissza" name="vissza" style="width: 100px; height: 40px" onclick="window.location.href='index.php'" />
379 </form>
380 </body>
381</html>