· 6 years ago · Jul 10, 2019, 08:52 AM
1CREATE TABLE IF NOT EXISTS `videos` (
2 `video_id` int(11) NOT NULL,
3 `video_title` varchar(255) NOT NULL,
4 `video_url` varchar(255) DEFAULT NULL,
5 `video_link` varchar(255) DEFAULT NULL,
6 `video_date` date DEFAULT NULL,
7 `video_category` varchar(255) DEFAULT NULL,
8 `video_description` longtext,
9 `video_keywords` varchar(255) NOT NULL,
10 `added` datetime DEFAULT NULL
11) ENGINE=InnoDB AUTO_INCREMENT=291 DEFAULT CHARSET=utf8;
12
13function adminAddVideo() {
14 global $conn;
15
16 echo "<div class='row'>";
17 echo "<div class='col-md-6 col-md-offset-3'>";
18 echo "<h2>Nové video</h2>";
19
20 echo "<form action='add' method='post'>";
21 echo "<div class='form-group'>";
22 echo "<label for='title'>Názov videa</label>";
23 echo "<input type='text' class='form-control' name='video_title'>";
24 echo "</div>";
25
26 echo "<div class='form-group'>";
27 echo "<label for='title'>SEO</label>";
28 echo "<input type='text' class='form-control' name='video_url' placeholder='Napr. greckokatolicky-magazin-11-vydanie'>";
29 echo "</div>";
30
31 echo "<div class='form-group'>";
32 echo "<label for='title'>URL odkaz</label>";
33 echo "<input type='text' class='form-control' name='video_link' placeholder='Pridáva sa len kód, ktorý je na konci YT videa (za v='>";
34 echo "</div>";
35
36 echo "<div class='form-group'>";
37 echo "<label for='title'>Dátum pridania</label>";
38 echo "<input type='text' class='form-control' name='video_date' placeholder='RRRR-MM-DD'>";
39 echo "</div>";
40
41 echo "<div class='form-group'>";
42 echo "<label for='title'>Popis</label>";
43 echo "<textarea rows='10' class='form-control' name='video_description'></textarea>";
44 // echo "<div id='charNum'>dsa</div>";
45 echo "</div>";
46
47 echo "<div class='form-group'>";
48 echo "<label for='title'>Keywords</label>";
49 echo "<input type='text' class='form-control' name='video_keywords' placeholder='Kľúčové slová, napr. klokocov, put'>";
50 echo "</div>";
51
52 echo "<div class='form-group'>";
53 echo "<label for='title'>Kategória</label>";
54 echo "<select class='selectpicker' name='video_category'>";
55 echo "<option value='dejiny-greckokatolikov'>Dejiny Gréckokatolíkov</option>";
56 echo "<option value='homilie'>Homílie</option>";
57 echo "<option value='grkat-magazin'>Gréckokatolícky Magazín</option>";
58 echo "<option value='spevy'>Spevy</option>";
59 echo "<option value='zaznamy'>Záznamy</option>";
60 echo "</select>";
61 echo "</div>";
62
63 echo "<div class='form-group'>";
64 echo "<input type='submit' class='btn btn-primary' name='admin_add_video' value='Pridať video '>";
65 echo "<br /><a href='/admin'>Návrat</a>";
66 echo "</div>";
67
68 echo "</form>";
69
70 echo "</div>";
71 echo "</div>";
72
73 if (isset($_POST['admin_add_video'])) {
74 $video_id = $_POST['video_id'];
75 $video_title = $_POST['video_title'];
76 $video_url = $_POST['video_url'];
77 $video_link = $_POST['video_link'];
78 $video_date = $_POST['video_date'];
79 $video_category = $_POST['video_category'];
80 $video_keywords = $_POST['video_keywords'];
81 $video_description = $_POST['video_description'];
82
83 if (($video_title == "")OR($video_link == "")) {
84 echo "<div class='formerror text-center'>Nevyplnili ste všetky položky.</div>";
85 }
86 else {
87 $sql = "INSERT INTO videos (video_title, video_url, video_link, video_date, video_category, video_description, video_keywords, added) VALUES ('$video_title','$video_url','$video_link','$video_date','$video_category','$video_description','$video_keywords',NOW())";
88
89
90 if ($conn->multi_query($sql) === TRUE) {
91 echo "Video bolo úspešne pridané";
92} else {
93 echo "Error: " . $sql . "<br>" . $conn->error;
94}
95
96$conn->close();
97 // header ("refresh:3;url=index.php");
98 }
99 }
100}