· 8 years ago · Apr 24, 2018, 09:22 PM
1<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
2<?php
3 $host = 'localhost';
4 $user = 'root';
5 $heslo = '';
6 $databaze = 'zavody';
7
8 $connect = mysql_connect($host, $user, $heslo)
9 or die("Nepodařilo se připojit do databáze");
10 $database = mysql_select_db($databaze, $connect)
11 or die("Nepodařilo se zvolit databázi");
12 $mysql_kodovani = mysql_set_charset('utf8');
13?>
14
15<form action="" method="post">
16 <input type="text" name="nazev_zavodu" value="Název závodu"/>
17 <input type="text" name="datum" value="Datum"/><br>
18 <textarea cols = "37" rows = "5" name="poznamka" >Poznámka</textarea><br>
19 <input type="submit" name="submit" value="Odeslat" />
20</form>
21
22<?php
23 if(isset($_POST['submit']))
24 {
25 if((isset($_POST['nazev_zavodu'])) && (!empty($_POST['nazev_zavodu'])) && (isset($_POST['datum'])) && (!empty($_POST['datum'])) && (isset($_POST['poznamka'])) && (!empty($_POST['poznamka'])))
26 {
27 $nazev_zavodu = $_POST['nazev_zavodu'];
28 $datum = $_POST['datum'];
29 $poznamka = $_POST['poznamka'];
30 $sql = "INSERT INTO `zavod` (`nazev_zavodu` ,`datum` ,`poznamky`) VALUES ('$nazev_zavodu', '$datum', '$poznamka');";
31 $query = mysql_query($sql);
32 }
33 }
34?>
35
36
37
38
39
40
41<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
42<?php
43 $host = 'localhost';
44 $user = 'root';
45 $heslo = '';
46 $databaze = 'zavody';
47
48 $connect = mysql_connect($host, $user, $heslo)
49 or die("Nepodařilo se připojit do databáze");
50 $database = mysql_select_db($databaze, $connect)
51 or die("Nepodařilo se zvolit databázi");
52 $mysql_kodovani = mysql_set_charset('utf8');
53?>
54
55<form action="" method="post">
56 <input type="text" name="startovni_cislo" value="startovnà ÄÃslo"/>
57<select name="kategorie">
58 <option value="1 kat">1 kat</option>
59 <option value="2 kat">2 kat</option>
60 <option value="3 kat">3 kat</option>
61 <option value="4 kat">4 kat</option>
62 <option value="5 kat">5 kat</option>
63 <option value="6 kat">6 kat</option>
64 <option value="7 kat">7 kat</option>
65 <option value="8 kat">8 kat</option>
66 <option value="9 kat">9 kat</option>
67 <option value="10 kat">10 kat</option>
68 <option value="11 kat">11 kat</option>
69</select>
70 <input type="text" name="jmeno" value="jmeno"/>
71 <input type="text" name="prijmeni" value="pÅ™ijmenÃ"/>
72 <input type="text" name="spol_jmeno" value="jméno spolujezdce"/>
73 <input type="text" name="spol_prijmeni" value="pÅ™Ãjmenà spolujezdce"/>
74 <input type="text" name="psc" value="psÄ"/>
75 <input type="text" name="mesto" value="město"/>
76 <input type="text" name="stroj" value="stroj"/>
77 <input type="text" name="mobil" value="mobil"/>
78 <input type="text" name="email" value="email"/>
79 <input type="submit" name="submit" value="Odeslat" />
80</form>
81
82<?php
83 if(isset($_POST['submit']))
84 {
85 if((isset($_POST['startovni_cislo'])) && (!empty($_POST['startovni_cislo'])) && (isset($_POST['kategorie'])) && (!empty($_POST['kategorie'])) && (isset($_POST['jmeno'])) && (!empty($_POST['jmeno'])) && (isset($_POST['prijmeni'])) && (!empty($_POST['prijmeni'])) && (isset($_POST['spol_jmeno'])) && (!empty($_POST['spol_jmeno'])) && (isset($_POST['spol_prijmeni'])) && (!empty($_POST['spol_prijmeni'])) && (isset($_POST['psc'])) && (!empty($_POST['psc'])) && (isset($_POST['mesto'])) && (!empty($_POST['mesto'])) && (isset($_POST['stroj'])) && (!empty($_POST['stroj'])) && (isset($_POST['mobil'])) && (!empty($_POST['mobil'])) && (isset($_POST['email'])) && (!empty($_POST['email'])))
86 {
87 $startovni_cislo = $_POST['startovni_cislo'];
88 $kategorie = $_POST['kategorie'];
89 $jmeno = $_POST['jmeno'];
90 $prijmeni = $_POST['prijmeni'];
91 $spol_jmeno = $_POST['spol_jmeno'];
92 $spol_prijmeni = $_POST['spol_prijmeni'];
93 $psc = $_POST['psc'];
94 $mesto = $_POST['mesto'];
95 $stroj = $_POST['stroj'];
96 $mobil = $_POST['mobil'];
97 $email = $_POST['email'];
98 $sql = "INSERT INTO `jezdci` (`startovni_cislo`, `kategorie`, `jmeno`, `prijmeni`, `spol_jmeno`, `spol_prijmeni`, `psc`, `mesto`, `stroj`, `mobil`, `email`) VALUES ('$startovni_cislo', '$kategorie', '$jmeno', '$prijmeni', '$spol_jmeno', '$spol_prijmeni', '$psc', '$mesto', '$stroj', '$mobil', '$email');";
99 $query = mysql_query($sql);
100 }
101 }
102?>
103
104
105
106
107
108<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
109<?php
110 $host = 'localhost';
111 $user = 'root';
112 $heslo = '';
113 $databaze = 'zavody';
114
115 $connect = mysql_connect($host, $user, $heslo)
116 or die("Nepodařilo se připojit do databáze");
117 $database = mysql_select_db($databaze, $connect)
118 or die("Nepodařilo se zvolit databázi");
119 $mysql_kodovani = mysql_set_charset('utf8');
120?>
121
122<form action="" method="post">
123 <input type="text" name="startovni_cislo" value="startovnà ÄÃslo"/>
124
125<select name="nazev_zavodu">
126<?php
127 $sql = "SELECT * FROM `zavod`;";
128 $query = mysql_query($sql);
129 while($zaznam = mysql_fetch_array($query))
130 {
131 echo '<option value="'.$zaznam['nazev_zavodu'].'">'.$zaznam['nazev_zavodu'].'</option>';
132 }
133?>
134</select>
135 <input type="submit" name="submit" value="Odeslat" />
136</form>
137
138<?php
139 if(isset($_POST['submit']))
140 {
141 if(isset($_POST['startovni_cislo']) && !empty($_POST['startovni_cislo']))
142 {
143 $startovni_cislo = $_POST['startovni_cislo'];
144 $nazev_zavodu = $_POST['nazev_zavodu'];
145 $sql = "SELECT * FROM `spojka` , `zavod` WHERE `spojka`.`startovni_cislo` = '$startovni_cislo' AND `spojka`.`ID_zavodu` = `zavod`.`ID_zavodu` AND `zavod`.`nazev_zavodu` = '$nazev_zavodu';";
146 $query = mysql_query($sql);
147 while($zaznam = mysql_fetch_array($query))
148 {
149 $sql2 = "SELECT * FROM `casy` WHERE `ID_cas` = '".$zaznam['ID_casy']."' ORDER BY `ID_cas` ASC;";
150 $query2 = mysql_query($sql2);
151 while($zaznam2 = mysql_fetch_array($query2))
152 {
153 echo $zaznam2['cas'];
154 echo '<br>';
155 }
156 }
157 }
158 }
159?>
160
161
162
163
164<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
165<?php
166 $host = 'localhost';
167 $user = 'root';
168 $heslo = '';
169 $databaze = 'zavody';
170
171 $connect = mysql_connect($host, $user, $heslo)
172 or die("Nepodařilo se připojit do databáze");
173 $database = mysql_select_db($databaze, $connect)
174 or die("Nepodařilo se zvolit databázi");
175 $mysql_kodovani = mysql_set_charset('utf8');
176?>
177
178<form action="" method="post">
179 <input type="text" name="startovni_cislo" value="Startovnà ÄÃslo"/>
180 <input type="submit" name="submit" value="Odeslat"/>
181</form>
182
183<?php
184 if(isset($_POST['submit']))
185 {
186 if((isset($_POST['startovni_cislo'])) && (!empty($_POST['startovni_cislo'])))
187 {
188 $startovni_cislo = $_POST['startovni_cislo'];
189 $sql = "DELETE FROM `jezdci` WHERE `startovni_cislo` = '$startovni_cislo'";
190 $query = mysql_query($sql);
191 }
192 }
193?>
194
195
196
197
198<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
199<?php
200 $host = 'localhost';
201 $user = 'root';
202 $heslo = '';
203 $databaze = 'zavody';
204
205 $connect = mysql_connect($host, $user, $heslo)
206 or die("Nepodařilo se připojit do databáze");
207 $database = mysql_select_db($databaze, $connect)
208 or die("Nepodařilo se zvolit databázi");
209 $mysql_kodovani = mysql_set_charset('utf8');
210?>
211
212<form action="" method="GET">
213 <input type="text" name="startovni_cislo" value="startovnà ÄÃslo"/>
214 <input type="submit" name="submit" value="Odeslat" />
215</form>
216
217<?php
218 if(isset($_POST['submit']))
219 {
220 if((isset($_POST['startovni_cislo'])) && (!empty($_POST['startovni_cislo'])) && (isset($_POST['kategorie'])) && (!empty($_POST['kategorie'])) && (isset($_POST['jmeno'])) && (!empty($_POST['jmeno'])) && (isset($_POST['prijmeni'])) && (!empty($_POST['prijmeni'])) && (isset($_POST['spol_jmeno'])) && (!empty($_POST['spol_jmeno'])) && (isset($_POST['spol_prijmeni'])) && (!empty($_POST['spol_prijmeni'])) && (isset($_POST['psc'])) && (!empty($_POST['psc'])) && (isset($_POST['mesto'])) && (!empty($_POST['mesto'])) && (isset($_POST['stroj'])) && (!empty($_POST['stroj'])) && (isset($_POST['mobil'])) && (!empty($_POST['mobil'])) && (isset($_POST['email'])) && (!empty($_POST['email'])))
221 {
222 $startovni_cislo = $_POST['startovni_cislo'];
223 $kategorie = $_POST['kategorie'];
224 $jmeno = $_POST['jmeno'];
225 $prijmeni = $_POST['prijmeni'];
226 $spol_jmeno = $_POST['spol_jmeno'];
227 $spol_prijmeni = $_POST['spol_prijmeni'];
228 $psc = $_POST['psc'];
229 $mesto = $_POST['mesto'];
230 $stroj = $_POST['stroj'];
231 $mobil = $_POST['mobil'];
232 $email = $_POST['email'];
233 $sql = "UPDATE `jezdci` SET `startovni_cislo` = '$startovni_cislo',`kategorie` = '$kategorie',`jmeno` = '$jmeno',`prijmeni` = '$prijmeni',`spol_jmeno` = '$spol_jmeno',`spol_prijmeni` = '$spol_prijmeni',`psc` = '$psc',`mesto` = '$mesto',`stroj` = '$stroj',`mobil` = '$mobil',`email` = '$email' WHERE `jezdci`.`startovni_cislo` = ".$_GET['startovni_cislo'];
234 $query = mysql_query($sql);
235 }
236 }
237
238 if(isset($_GET['startovni_cislo'])){
239 $sql = "SELECT * FROM `jezdci` WHERE `startovni_cislo` = " . $_GET['startovni_cislo'];
240 $query = mysql_query($sql);
241 while($zaznam = mysql_fetch_array($query))
242 {
243?>
244<form action="" method="post">
245 <input type="text" name="startovni_cislo" value="<?php echo $zaznam["startovni_cislo"];?>"/>
246<select name="kategorie">
247 <option value="1 kat" <?php if ($zaznam['kategorie'] == 1) { echo 'selected="selected"'; } ?>>1 kat</option>
248 <option value="2 kat"<?php if ($zaznam['kategorie'] == 2) { echo 'selected="selected"'; } ?>>2 kat</option>
249 <option value="3 kat"<?php if ($zaznam['kategorie'] == 3) { echo 'selected="selected"'; } ?>>3 kat</option>
250 <option value="4 kat"<?php if ($zaznam['kategorie'] == 4) { echo 'selected="selected"'; } ?>>4 kat</option>
251 <option value="5 kat"<?php if ($zaznam['kategorie'] == 5) { echo 'selected="selected"'; } ?>>5 kat</option>
252 <option value="6 kat"<?php if ($zaznam['kategorie'] == 6) { echo 'selected="selected"'; } ?>>6 kat</option>
253 <option value="7 kat"<?php if ($zaznam['kategorie'] == 7) { echo 'selected="selected"'; } ?>>7 kat</option>
254 <option value="8 kat"<?php if ($zaznam['kategorie'] == 8) { echo 'selected="selected"'; } ?>>8 kat</option>
255 <option value="9 kat"<?php if ($zaznam['kategorie'] == 9) { echo 'selected="selected"'; } ?>>9 kat</option>
256 <option value="10 kat"<?php if ($zaznam['kategorie'] == 10) { echo 'selected="selected"'; } ?>>10 kat</option>
257 <option value="11 kat"<?php if ($zaznam['kategorie'] == 11) { echo 'selected="selected"'; } ?>>11 kat</option>
258</select>
259 <input type="text" name="jmeno" value="<?php echo $zaznam["jmeno"];?>"/>
260 <input type="text" name="prijmeni" value="<?php echo $zaznam["prijmeni"];?>"/>
261 <input type="text" name="spol_jmeno" value="<?php echo $zaznam["spol_jmeno"];?>"/>
262 <input type="text" name="spol_prijmeni" value="<?php echo $zaznam["spol_prijmeni"];?>"/>
263 <input type="text" name="psc" value="<?php echo $zaznam["psc"];?>"/>
264 <input type="text" name="mesto" value="<?php echo $zaznam["mesto"];?>"/>
265 <input type="text" name="stroj" value="<?php echo $zaznam["stroj"];?>"/>
266 <input type="text" name="mobil" value="<?php echo $zaznam["mobil"];?>"/>
267 <input type="text" name="email" value="<?php echo $zaznam["email"];?>"/>
268 <input type="submit" name="submit" value="Odeslat"/>
269</form>
270
271<?php
272}
273?>
274
275<?php
276}
277?>
278
279
280
281
282
283<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
284<?php
285 $host = 'localhost';
286 $user = 'root';
287 $heslo = '';
288 $databaze = 'zavody';
289
290 $connect = mysql_connect($host, $user, $heslo)
291 or die("Nepodařilo se připojit do databáze");
292 $database = mysql_select_db($databaze, $connect)
293 or die("Nepodařilo se zvolit databázi");
294 $mysql_kodovani = mysql_set_charset('utf8');
295?>
296
297<form action="" method="post">
298 <input type="text" name="startovni_cislo" value="startovnà ÄÃslo"/>
299 <input type="text" name="cas" value="Äas"/>
300 <input type="submit" name="submit" value="Odeslat" />
301</form>
302
303<?php
304 if(isset($_POST['submit']))
305 {
306 if((isset($_POST['cas'])) && (!empty($_POST['cas'])) && (isset($_POST['startovni_cislo'])) && (!empty($_POST['startovni_cislo'])))
307 {
308 $cas = $_POST['cas'];
309 $startovni_cislo = $_POST['startovni_cislo'];
310 $sql = "INSERT INTO `casy` (`cas`) VALUES ('$cas');";
311 $query = mysql_query($sql);
312 $sql = "SELECT LAST_INSERT_ID();";
313 $query = mysql_query($sql);
314 while($zaznam = mysql_fetch_array($query))
315 {
316 $ID_cas = $zaznam['LAST_INSERT_ID()'];
317 }
318 $sql = "SELECT * FROM `zavod` ORDER BY `ID_zavodu` DESC LIMIT 1";
319 $query = mysql_query($sql);
320 while($zaznam = mysql_fetch_array($query))
321 {
322 $ID_zavod = $zaznam['ID_zavodu'];
323 }
324 $sql = "INSERT INTO `spojka` ( `ID_casy` , `ID_zavodu` , `startovni_cislo` ) VALUES ('$ID_cas', '$ID_zavod', '$startovni_cislo');";
325 $query = mysql_query($sql);
326 }
327 }
328?>
329
330
331
332<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
333
334<form action="" method="post">
335 <input type="text" name="nazev" value="Jméno DB"/>
336 <input type="submit" name="submit" value="Vytvořit DB"/>
337</form>
338
339<?php
340 $host = 'localhost';
341 $user = 'root';
342 $heslo = '';
343
344 $connect = mysql_connect($host, $user, $heslo)
345 or die("Nepodařilo se připojit do databáze");
346 $mysql_kodovani = mysql_set_charset('utf8');
347?>
348
349<?php
350 if(isset($_POST['submit']))
351 {
352 $filename = "NazevDB.txt";
353 unlink($filename);
354
355 if (file_exists("NazevDB.txt"))
356 {
357 $soubor=fopen("NazevDB.txt", "r+");
358 }
359 else
360 {
361 $soubor=fopen("NazevDB.txt", "w");
362 }
363 rewind($soubor);
364 fwrite($soubor,$_POST['nazev'],30);
365 $databaze = $_POST['nazev'];
366
367 fclose($soubor);
368
369 $sql = "CREATE DATABASE IF NOT EXISTS ".$databaze;
370 $query = mysql_query($sql);
371 $database = mysql_select_db($databaze, $connect)
372 or die("Nepodařilo se zvolit databázi");
373 $sql = "CREATE TABLE IF NOT EXISTS `casy_nedele` (`startovni_cislo` int(11) NOT NULL, `cas_00` time NOT NULL, `cas_01` time NOT NULL);";
374 $query = mysql_query($sql);
375 $sql = "CREATE TABLE IF NOT EXISTS `casy_sobota` (`startovni_cislo` int(11) NOT NULL,`cas_00` time NOT NULL,`cas_01` time NOT NULL);";
376 $query = mysql_query($sql);
377 $sql = "CREATE TABLE IF NOT EXISTS `startovacilistina` (`startovni_cislo` int(11) NOT NULL,`sobota` tinyint(1) NOT NULL DEFAULT '0',`nedele` tinyint(1) NOT NULL DEFAULT '0');";
378 $query = mysql_query($sql);
379 $sql = "CREATE TABLE IF NOT EXISTS `zavod` (`nazev_zavodu` char(255) NOT NULL,`datum` date NOT NULL,`poznamky` char(255) NOT NULL)";
380 $query = mysql_query($sql);
381 }
382?>