· 5 years ago · Oct 10, 2020, 11:10 AM
1//* _aplication.php
2<?php
3
4function selectDatabase()
5{
6 return new PDO(
7 'mysql:dbname=dtn04;host=localhost',
8 'root',
9 'root',
10 [PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"]
11 );
12}
13
14function inputDatabase()
15{
16 return new PDO(
17 'mysql:dbname=dtn04;host=localhost',
18 'root',
19 'root',
20 [PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"]
21 );
22}
23//* web_add_form.php
24<?php
25
26require __DIR__ . '/_application.php';
27
28$db = selectDatabase();
29
30$dbinput = inputDatabase();
31
32
33$sqlLabel = $db->query("SELECT * FROM cat_label ORDER BY label_name ASC");
34
35$sqlStyle = $db->query("SELECT * FROM cat_style ORDER BY style_name ASC");
36
37$sqlFormat = $db->query("SELECT * FROM cat_format ORDER BY format_name ASC");
38
39$sqlType = $db->query("SELECT * FROM cat_type ORDER BY type_name ASC");
40
41$sqlCountry = $db->query("SELECT * FROM cat_country ORDER BY country_name ASC");
42
43
44
45
46if (isset($_POST['aktion']) > 0) {
47 if ($_POST['aktion'] === 'odeslat') {
48 //* $deleteStatement = $db->prepare("DELETE FROM lieder WHERE id = :lied_id");
49 //* $deleteStatement->execute(['lied_id' => $_GET['id']]);
50
51
52 $sqlInserRelease = $dbinput->prepare("
53 INSERT INTO cat_release (id_release, release_catnr, release_name, release_year, release_artist_id, release_add_date, release_label_id, release_style_id, release_country_id, release_format_id, release_type_id, release_scene_id)
54 VALUES ('',:rel_catnr, :rel_name,'','','', :rel_label_id, :rel_style_id, :rel_country_id, :rel_format_id, :rel_type_id,'')
55 ");
56
57 $sqlInserRelease->execute([
58 'rel_catnr' => $_POST['inpCatNr'],
59 'rel_name' => $_POST['inpRlsName'],
60 //release year
61 'rel_label_id' => $_POST['inpLabel'],
62 'rel_style_id' => $_POST['inpStyle'],
63 'rel_country_id' => $_POST['inpCountry'],
64 'rel_format_id' => $_POST['inpFormat'],
65 'rel_type_id' => $_POST['inpType']
66 ]);
67 }
68
69 }
70
71
72var_dump($_POST);
73?>
74
75<div id="web_form" class="text-left" style="border-top-style: solid;padding-top: 50px;">
76
77 <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" name="add_form" method="POST">
78
79 <table border="1">
80 <tr>
81 <th>CAT Nr:</th><th>Release Name:</th><th>Label</th><th>Format</th><th>Type</th><th>Style</th><th>Country</th><th>RLS DATE</th>
82 </tr>
83 <tr>
84 <td><input type="text" name="inpCatNr" id="inp_cat_nr"></td>
85 <td><input type="text" name="inpRlsName" id="inp_rls_name"></td>
86 <td><select class="form-control form-control-sm" name="inpLabel" id="sel_label">
87 <option selected>Choose...</option>
88 <?php while ($datenSqlLabel = $sqlLabel->fetch(PDO::FETCH_ASSOC)) : ?>
89 <option value="<?= htmlspecialchars($datenSqlLabel['id_label']); ?>"><?= htmlspecialchars($datenSqlLabel['label_name']); ?></option>
90 <?php endwhile; ?>
91 </select>
92 </td>
93
94 <td><select class="form-control form-control-sm" name="inpFormat" id="sel_format">
95 <option selected>Choose...</option>
96 <?php while ($datenSqlFormat = $sqlFormat->fetch(PDO::FETCH_ASSOC)) : ?>
97 <option value="<?= htmlspecialchars($datenSqlFormat['id_format']); ?>"><?= htmlspecialchars($datenSqlFormat['format_name']); ?></option>
98 <?php endwhile; ?>
99 </select>
100 </td>
101
102 <td><select class="form-control form-control-sm" name="inpType" id="sel_type">
103 <option selected>Choose...</option>
104 <?php while ($datenSqlType = $sqlType->fetch(PDO::FETCH_ASSOC)) : ?>
105 <option value="<?= htmlspecialchars($datenSqlType['id_type']); ?>"><?= htmlspecialchars($datenSqlType['type_name']); ?></option>
106 <?php endwhile; ?>
107 </select>
108 </td>
109
110 <td><select class="form-control form-control-sm" name="inpStyle" id="sel_style">
111 <option selected>Choose...</option>
112 <?php while ($datenSqlStyle = $sqlStyle->fetch(PDO::FETCH_ASSOC)) : ?>
113 <option value="<?= htmlspecialchars($datenSqlStyle['id_style']); ?>"><?= htmlspecialchars($datenSqlStyle['style_name']); ?></option>
114 <?php endwhile; ?>
115 </select>
116 </td>
117
118 <td><select class="form-control form-control-sm" name="inpCountry" id="sel_country">
119 <option selected>Choose...</option>
120 <?php while ($datenSqlCountry = $sqlCountry->fetch(PDO::FETCH_ASSOC)) : ?>
121 <option value="<?= htmlspecialchars($datenSqlCountry['id_country']); ?>"><?= htmlspecialchars($datenSqlCountry['country_name']); ?></option>
122 <?php endwhile; ?>
123 </select></td>
124
125 <td><button type="submit" name="aktion" value="odeslat">Odeslat</button></td>
126 </table>
127 </form>
128 </p>
129 </div>
130/* sql
131-- phpMyAdmin SQL Dump
132-- version 4.8.5
133-- https://www.phpmyadmin.net/
134--
135-- Počítač: 127.0.0.1:3306
136-- Vytvořeno: Sob 10. říj 2020, 12:56
137-- Verze serveru: 5.7.26
138-- Verze PHP: 7.2.18
139
140SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
141SET AUTOCOMMIT = 0;
142START TRANSACTION;
143SET time_zone = "+00:00";
144
145
146/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
147/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
148/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
149/*!40101 SET NAMES utf8mb4 */;
150
151--
152-- Databáze: `dtn04`
153--
154
155-- --------------------------------------------------------
156
157--
158-- Struktura tabulky `cat_artist`
159--
160
161DROP TABLE IF EXISTS `cat_artist`;
162CREATE TABLE IF NOT EXISTS `cat_artist` (
163 `id_artist` int(11) NOT NULL AUTO_INCREMENT,
164 `artist_name` varchar(32) NOT NULL,
165 `artist_desc` longtext,
166 `artist_url` longtext,
167 PRIMARY KEY (`id_artist`)
168) ENGINE=InnoDB DEFAULT CHARSET=latin1;
169
170-- --------------------------------------------------------
171
172--
173-- Struktura tabulky `cat_country`
174--
175
176DROP TABLE IF EXISTS `cat_country`;
177CREATE TABLE IF NOT EXISTS `cat_country` (
178 `id_country` int(11) NOT NULL AUTO_INCREMENT,
179 `country_code` char(2) NOT NULL COMMENT 'Two-letter country code (ISO 3166-1 alpha-2)',
180 `country_name` varchar(64) NOT NULL COMMENT 'English country name',
181 `country_full_name` varchar(128) NOT NULL COMMENT 'Full English country name',
182 `country_iso3` char(3) NOT NULL COMMENT 'Three-letter country code (ISO 3166-1 alpha-3)',
183 PRIMARY KEY (`id_country`),
184 UNIQUE KEY `country_name` (`country_code`) USING BTREE
185) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
186
187--
188-- Vypisuji data pro tabulku `cat_country`
189--
190
191INSERT INTO `cat_country` (`id_country`, `country_code`, `country_name`, `country_full_name`, `country_iso3`) VALUES
192(1, 'AL', 'Albania', 'Republic of Albania', 'ALB'),
193(2, 'AN', 'Netherlands Antilles', 'Netherlands Antilles', 'ANT'),
194(3, 'AT', 'Austria', 'Republic of Austria', 'AUT'),
195(4, 'BA', 'Bosnia and Herzegovina', 'Bosnia and Herzegovina', 'BIH'),
196(5, 'BE', 'Belgium', 'Kingdom of Belgium', 'BEL'),
197(6, 'BG', 'Bulgaria', 'Republic of Bulgaria', 'BGR'),
198(7, 'CH', 'Switzerland', 'Swiss Confederation', 'CHE'),
199(8, 'CZ', 'Czech Republic', 'Czech Republic', 'CZE'),
200(9, 'DE', 'Germany', 'Federal Republic of Germany', 'DEU'),
201(10, 'DK', 'Denmark', 'Kingdom of Denmark', 'DNK'),
202(11, 'EE', 'Estonia', 'Republic of Estonia', 'EST'),
203(12, 'ES', 'Spain', 'Kingdom of Spain', 'ESP'),
204(13, 'FI', 'Finland', 'Republic of Finland', 'FIN'),
205(14, 'FR', 'France', 'French Republic', 'FRA'),
206(15, 'GB', 'United Kingdom', 'United Kingdom of Great Britain & Northern Ireland', 'GBR'),
207(16, 'GE', 'Georgia', 'Georgia', 'GEO'),
208(17, 'GL', 'Greenland', 'Greenland', 'GRL'),
209(18, 'GR', 'Greece', 'Hellenic Republic Greece', 'GRC'),
210(19, 'HR', 'Croatia', 'Republic of Croatia', 'HRV'),
211(20, 'HU', 'Hungary', 'Republic of Hungary', 'HUN'),
212(21, 'IE', 'Ireland', 'Ireland', 'IRL'),
213(22, 'IT', 'Italy', 'Italian Republic', 'ITA'),
214(23, 'LT', 'Lithuania', 'Republic of Lithuania', 'LTU'),
215(24, 'LU', 'Luxembourg', 'Grand Duchy of Luxembourg', 'LUX'),
216(25, 'LV', 'Latvia', 'Republic of Latvia', 'LVA'),
217(26, 'MA', 'Morocco', 'Kingdom of Morocco', 'MAR'),
218(27, 'MC', 'Monaco', 'Principality of Monaco', 'MCO'),
219(28, 'MD', 'Moldova', 'Republic of Moldova', 'MDA'),
220(29, 'ME', 'Montenegro', 'Republic of Montenegro', 'MNE'),
221(30, 'MK', 'Macedonia', 'Republic of Macedonia', 'MKD'),
222(31, 'MT', 'Malta', 'Republic of Malta', 'MLT'),
223(32, 'NL', 'Netherlands', 'Kingdom of the Netherlands', 'NLD'),
224(33, 'NO', 'Norway', 'Kingdom of Norway', 'NOR'),
225(34, 'PL', 'Poland', 'Republic of Poland', 'POL'),
226(35, 'PT', 'Portugal', 'Portuguese Republic', 'PRT'),
227(36, 'RO', 'Romania', 'Romania', 'ROU'),
228(37, 'RS', 'Serbia', 'Republic of Serbia', 'SRB'),
229(38, 'RU', 'Russian Federation', 'Russian Federation', 'RUS'),
230(39, 'SE', 'Sweden', 'Kingdom of Sweden', 'SWE'),
231(40, 'SI', 'Slovenia', 'Republic of Slovenia', 'SVN'),
232(41, 'SK', 'Slovakia', 'Slovakia (Slovak Republic)', 'SVK'),
233(42, 'SM', 'San Marino', 'Republic of San Marino', 'SMR'),
234(43, 'TR', 'Turkey', 'Republic of Turkey', 'TUR'),
235(44, 'UA', 'Ukraine', 'Ukraine', 'UKR'),
236(45, 'VA', 'Vatican City', 'Holy See (Vatican City State)', 'VAT');
237
238-- --------------------------------------------------------
239
240--
241-- Struktura tabulky `cat_format`
242--
243
244DROP TABLE IF EXISTS `cat_format`;
245CREATE TABLE IF NOT EXISTS `cat_format` (
246 `id_format` int(11) NOT NULL AUTO_INCREMENT,
247 `format_name` varchar(100) NOT NULL,
248 `format_ico` varchar(100) DEFAULT NULL,
249 PRIMARY KEY (`id_format`)
250) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
251
252--
253-- Vypisuji data pro tabulku `cat_format`
254--
255
256INSERT INTO `cat_format` (`id_format`, `format_name`, `format_ico`) VALUES
257(1, 'Vinyl 10\"', 'ico_vinyl_10.jpg'),
258(2, 'Vinyl 12\"', 'ico_vinyl_12.jpg'),
259(3, 'MP3 WEB', 'ico_mp3_web.jpg'),
260(4, 'MP3 WEB FREE', 'ico_mp3_web_free.jpg'),
261(5, 'MP3 VINYL RIP', 'ico_mp3_vinyl_rip.jpg'),
262(6, 'FLAC WEB', 'ico_flac_web.jpg'),
263(7, 'FLAC WEB FREE', 'ico_flac_web_free.jpg'),
264(8, 'FLAC VINYL RIP', 'ico_flac_vinyl_rip.jpg'),
265(9, 'STREAM WEB', 'ico_stream_web.jpg'),
266(10, 'CD', 'ico_cd.jpg'),
267(11, 'TAPE', 'ico_tape.jpg'),
268(12, 'Vinyl 7\"', 'ico_vinyl_10.jpg');
269
270-- --------------------------------------------------------
271
272--
273-- Struktura tabulky `cat_label`
274--
275
276DROP TABLE IF EXISTS `cat_label`;
277CREATE TABLE IF NOT EXISTS `cat_label` (
278 `id_label` int(11) NOT NULL AUTO_INCREMENT,
279 `label_name` varchar(100) NOT NULL,
280 `label_desc` longtext,
281 `label_url` longtext,
282 PRIMARY KEY (`id_label`)
283) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
284
285--
286-- Vypisuji data pro tabulku `cat_label`
287--
288
289INSERT INTO `cat_label` (`id_label`, `label_name`, `label_desc`, `label_url`) VALUES
290(1, 'Yaya 23 Records', 'German label born in 2008 around YaYa23 record shop now in Finowstrasse 25, Friedrichshain, Berlin. ', 'https://soundcloud.com/yaya23-records'),
291(2, 'Cult Collective', 'Cult Collective started as OBS.CUR in 2008. In that period it has grown into a movement of music, straight from the soul.\r\n\r\nAfter more then a decade OBS.CUR evolved into a new entity which resonates even on a broader spectrum of frequencies. Nowadays Cult Collective holds over 10 vinyl labels in different styles, ranging from Techno to Rave, from Acid to Hardcore.\r\n\r\nOur bookings agency started in 2017 as a way to start working together on an increasing amount of bookings. Today, we host 30 acts in multiple genres. In collaboration with promoters and crews we host label-nights all over Europe.\r\n\r\nThe Rave Cult cannot be denied. ', 'https://cult-collective.com/'),
292(3, 'Astral Tek', 'Czech hardtek label.', '');
293
294-- --------------------------------------------------------
295
296--
297-- Struktura tabulky `cat_master_release`
298--
299
300DROP TABLE IF EXISTS `cat_master_release`;
301CREATE TABLE IF NOT EXISTS `cat_master_release` (
302 `id_master_release` int(11) NOT NULL AUTO_INCREMENT,
303 `release_id` int(11) DEFAULT NULL,
304 PRIMARY KEY (`id_master_release`),
305 KEY `fk_cat_master_release` (`release_id`)
306) ENGINE=InnoDB DEFAULT CHARSET=latin1;
307
308-- --------------------------------------------------------
309
310--
311-- Struktura tabulky `cat_release`
312--
313
314DROP TABLE IF EXISTS `cat_release`;
315CREATE TABLE IF NOT EXISTS `cat_release` (
316 `id_release` int(11) NOT NULL AUTO_INCREMENT,
317 `release_catnr` varchar(255) NOT NULL,
318 `release_name` varchar(255) NOT NULL,
319 `release_year` int(11) DEFAULT NULL,
320 `release_artist_id` int(11) NOT NULL,
321 `release_add_date` timestamp NULL DEFAULT NULL,
322 `release_label_id` int(11) NOT NULL,
323 `release_style_id` int(11) NOT NULL,
324 `release_coutry_id` int(11) NOT NULL,
325 `release_format_id` int(11) NOT NULL,
326 `release_type_id` int(11) NOT NULL,
327 `release_scene_id` int(11) NOT NULL,
328 PRIMARY KEY (`id_release`),
329 KEY `fk_cat_release_cat_artist` (`release_artist_id`),
330 KEY `fk_cat_release_cat_label` (`release_label_id`),
331 KEY `fk_cat_release_cat_style` (`release_style_id`),
332 KEY `fk_cat_release_cat_coutry` (`release_coutry_id`),
333 KEY `fk_cat_release_cat_format` (`release_format_id`),
334 KEY `fk_cat_release_cat_type` (`release_type_id`),
335 KEY `fk_cat_release_cat_scene` (`release_scene_id`)
336) ENGINE=InnoDB DEFAULT CHARSET=latin1;
337
338-- --------------------------------------------------------
339
340--
341-- Struktura tabulky `cat_scene`
342--
343
344DROP TABLE IF EXISTS `cat_scene`;
345CREATE TABLE IF NOT EXISTS `cat_scene` (
346 `id_scene` int(11) NOT NULL AUTO_INCREMENT,
347 `scene_rls_name` varchar(255) NOT NULL,
348 `scene_nfo` varchar(255) DEFAULT NULL,
349 `scene_add` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
350 PRIMARY KEY (`id_scene`)
351) ENGINE=InnoDB DEFAULT CHARSET=latin1;
352
353-- --------------------------------------------------------
354
355--
356-- Struktura tabulky `cat_style`
357--
358
359DROP TABLE IF EXISTS `cat_style`;
360CREATE TABLE IF NOT EXISTS `cat_style` (
361 `id_style` int(11) NOT NULL AUTO_INCREMENT,
362 `style_name` varchar(100) DEFAULT NULL,
363 PRIMARY KEY (`id_style`)
364) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
365
366--
367-- Vypisuji data pro tabulku `cat_style`
368--
369
370INSERT INTO `cat_style` (`id_style`, `style_name`) VALUES
371(1, 'Acid'),
372(2, 'Acid Mental'),
373(3, 'Acid Tribe'),
374(4, 'Mentalcore'),
375(5, 'Hardtek'),
376(6, 'Happytek'),
377(7, 'Raggatek'),
378(8, 'Hardfloor'),
379(9, 'Punpin Tribe'),
380(10, 'Oldschool Tribe'),
381(11, 'Acidcore'),
382(12, 'Breaks'),
383(13, 'Electro Breaks'),
384(14, 'Tribecore'),
385(15, 'Frenschcore'),
386(16, 'Experimental'),
387(17, 'Electronic'),
388(18, 'Hardcore');
389
390-- --------------------------------------------------------
391
392--
393-- Struktura tabulky `cat_track`
394--
395
396DROP TABLE IF EXISTS `cat_track`;
397CREATE TABLE IF NOT EXISTS `cat_track` (
398 `id_track` int(11) NOT NULL AUTO_INCREMENT,
399 `release_id` int(11) NOT NULL,
400 `track_nr` int(11) NOT NULL,
401 `track_titel` varchar(100) NOT NULL,
402 `track_pay` varchar(255) DEFAULT NULL,
403 `label_id` int(11) NOT NULL,
404 PRIMARY KEY (`id_track`),
405 KEY `fk_cat_track_cat_release` (`release_id`),
406 KEY `fk_cat_track_cat_track` (`label_id`)
407) ENGINE=InnoDB DEFAULT CHARSET=latin1;
408
409-- --------------------------------------------------------
410
411--
412-- Struktura tabulky `cat_type`
413--
414
415DROP TABLE IF EXISTS `cat_type`;
416CREATE TABLE IF NOT EXISTS `cat_type` (
417 `id_type` int(11) NOT NULL AUTO_INCREMENT,
418 `type_name` varchar(100) DEFAULT NULL,
419 `type_ico` varchar(100) DEFAULT NULL,
420 PRIMARY KEY (`id_type`)
421) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
422
423--
424-- Vypisuji data pro tabulku `cat_type`
425--
426
427INSERT INTO `cat_type` (`id_type`, `type_name`, `type_ico`) VALUES
428(1, 'ALBUM', 'ico_album.jpg'),
429(2, 'EP', 'ico_ep.jpg'),
430(3, 'SINGLE', 'ico_single.jpg'),
431(4, 'DJ SET', 'ico_dj_set.jpg'),
432(5, 'LIVE SET', 'ico_live_set.jpg');
433
434--
435-- Omezení pro exportované tabulky
436--
437
438--
439-- Omezení pro tabulku `cat_master_release`
440--
441ALTER TABLE `cat_master_release`
442 ADD CONSTRAINT `fk_cat_master_release` FOREIGN KEY (`release_id`) REFERENCES `cat_release` (`id_release`) ON DELETE NO ACTION ON UPDATE NO ACTION;
443
444--
445-- Omezení pro tabulku `cat_release`
446--
447ALTER TABLE `cat_release`
448 ADD CONSTRAINT `fk_cat_release_cat_artist` FOREIGN KEY (`release_artist_id`) REFERENCES `cat_artist` (`id_artist`) ON DELETE NO ACTION ON UPDATE NO ACTION,
449 ADD CONSTRAINT `fk_cat_release_cat_coutry` FOREIGN KEY (`release_coutry_id`) REFERENCES `cat_country` (`id_country`),
450 ADD CONSTRAINT `fk_cat_release_cat_label` FOREIGN KEY (`release_label_id`) REFERENCES `cat_label` (`id_label`) ON DELETE NO ACTION ON UPDATE NO ACTION,
451 ADD CONSTRAINT `fk_cat_release_cat_release` FOREIGN KEY (`release_format_id`) REFERENCES `cat_format` (`id_format`) ON DELETE NO ACTION ON UPDATE NO ACTION,
452 ADD CONSTRAINT `fk_cat_release_cat_scene` FOREIGN KEY (`release_scene_id`) REFERENCES `cat_scene` (`id_scene`) ON DELETE NO ACTION ON UPDATE NO ACTION,
453 ADD CONSTRAINT `fk_cat_release_cat_style` FOREIGN KEY (`release_style_id`) REFERENCES `cat_style` (`id_style`) ON DELETE NO ACTION ON UPDATE NO ACTION,
454 ADD CONSTRAINT `fk_cat_release_cat_type` FOREIGN KEY (`release_type_id`) REFERENCES `cat_type` (`id_type`) ON DELETE NO ACTION ON UPDATE NO ACTION;
455
456--
457-- Omezení pro tabulku `cat_track`
458--
459ALTER TABLE `cat_track`
460 ADD CONSTRAINT `fk_cat_track_cat_release` FOREIGN KEY (`release_id`) REFERENCES `cat_release` (`id_release`) ON DELETE NO ACTION ON UPDATE NO ACTION,
461 ADD CONSTRAINT `fk_cat_track_cat_track` FOREIGN KEY (`label_id`) REFERENCES `cat_label` (`id_label`) ON DELETE NO ACTION ON UPDATE NO ACTION;
462COMMIT;
463
464/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
465/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
466/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
467