API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 21st, 2017
100
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.31 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. //entry.php
  3. /*
  4. session_start();
  5. if(!isset($_SESSION["username"]))
  6. {
  7. header("location:login.php");
  8. }*/
  9. error_reporting(E_ALL);
  10. ?>
  11. <!DOCTYPE html>
  12. <html>
  13. <head>
  14. <meta charset="utf-8">
  15. <meta name="viewport" content="width=device-width, initial-scale=1">
  16. <title>Startseite Bearbeiten - Technica Dashboard</title>
  17.  
  18. <link href="css/bootstrap.min.css" rel="stylesheet">
  19. <link href="css/datepicker3.css" rel="stylesheet">
  20. <link href="css/styles.css" rel="stylesheet">
  21.  
  22. <!--Icons-->
  23. <script src="js/lumino.glyphs.js"></script>
  24.  
  25. <!--[if lt IE 9]>
  26. <script src="js/html5shiv.js"></script>
  27. <script src="js/respond.min.js"></script>
  28. <![endif]-->
  29. <style media="screen">
  30. .eintrag{
  31. cursor: pointer;
  32. padding: 15px;
  33. background: #f3f3f3;
  34. margin: 10px 0 10px 0;
  35. box-shadow: 0 1px 3px rgba(0,0,0,0.12), 0 1px 2px rgba(0,0,0,0.24);
  36. transition: all 0.3s cubic-bezier(.25,.8,.25,1);
  37. }
  38. .eintrag:hover{
  39. box-shadow: 0 10px 20px rgba(0,0,0,0.19), 0 6px 6px rgba(0,0,0,0.23);
  40. transform: translateY(-5px);
  41. }
  42. .add-product{
  43. border: none;
  44. padding: 10px 30px 10px 30px;
  45. box-shadow: 0 1px 3px rgba(0,0,0,0.12), 0 1px 2px rgba(0,0,0,0.24);
  46. transition: all 0.3s cubic-bezier(.25,.8,.25,1);
  47. background: #30a5ff;
  48. color: white;
  49. margin: 15px 0 15px 0;
  50. }
  51. .add-product:hover{
  52. box-shadow: 0 10px 20px rgba(0,0,0,0.19), 0 6px 6px rgba(0,0,0,0.23);
  53. transform: translateY(-5px);
  54. opacity: 1;
  55. color: white;
  56. }
  57. </style>
  58. </head>
  59.  
  60. <body>
  61. <nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
  62. <div class="container-fluid">
  63. <div class="navbar-header">
  64. <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#sidebar-collapse">
  65. <span class="sr-only">Toggle navigation</span>
  66. <span class="icon-bar"></span>
  67. <span class="icon-bar"></span>
  68. <span class="icon-bar"></span>
  69. </button>
  70. <a class="navbar-brand" href="#"><span>TECHNICA</span>DASHBOARD</a>
  71. <ul class="user-menu">
  72. <li class="dropdown pull-right">
  73. <a href="#" class="dropdown-toggle" data-toggle="dropdown"><svg class="glyph stroked male-user"><use xlink:href="#stroked-male-user"></use></svg> <?php echo $_SESSION['username'];?> <span class="caret"></span></a>
  74. <ul class="dropdown-menu" role="menu">
  75. <li><a href="#"><svg class="glyph stroked male-user"><use xlink:href="#stroked-male-user"></use></svg> Neuen Benutzer Registrieren</a></li>
  76. <li><a href="logout.php"><svg class="glyph stroked cancel"><use xlink:href="#stroked-cancel"></use></svg> Logout</a></li>
  77. </ul>
  78. </li>
  79. </ul>
  80. </div>
  81.  
  82. </div><!-- /.container-fluid -->
  83. </nav>
  84.  
  85. <div id="sidebar-collapse" class="col-sm-3 col-lg-2 sidebar" style="padding-top: 50px;">
  86. <ul class="nav menu">
  87. <li><a href="index.php"><svg class="glyph stroked dashboard-dial"><use xlink:href="#stroked-dashboard-dial"></use></svg> Dashboard</a></li>
  88. <li class="active"><a href="frontpage.php"><svg class="glyph stroked laptop computer and mobile"><use xlink:href="#stroked-laptop-computer-and-mobile"/></svg> Frontpage</a></li>
  89. <li><a href="ausleihen.php"><svg class="glyph stroked tag"><use xlink:href="#stroked-tag"/></svg> Ausleihen</a></li>
  90. <li role="presentation" class="divider"></li>
  91. <li><a href="/technica/" target="_blank"><svg class="glyph stroked app-window"><use xlink:href="#stroked-app-window"></use></svg> Webseite</a></li>
  92. </ul>
  93. </div><!--/.sidebar-->
  94.  
  95. <div class="col-sm-9 col-sm-offset-3 col-lg-10 col-lg-offset-2 main">
  96. <div class="row">
  97. <ol class="breadcrumb">
  98. <li><a href="#"><svg class="glyph stroked home"><use xlink:href="#stroked-home"></use></svg></a></li>
  99. <li class="active">Icons</li>
  100. </ol>
  101. </div><!--/.row-->
  102.  
  103. <div class="row">
  104. <div class="col-lg-12">
  105. <h1 class="page-header">Startseite</h1>
  106. </div>
  107. </div><!--/.row-->
  108.  
  109. <div class="row">
  110. <div class="col-lg-12">
  111. <div class="panel panel-default">
  112. <div class="panel-heading">Slider bearbeiten</div>
  113. <div class="panel-body">
  114. <img src="/technica/new-connection.php" alt="">
  115. <div class="canvas-wrapper">
  116.  
  117. <?php
  118. if (isset($_GET['editslide'])) {
  119. $id = $_GET['id'];
  120. include('technica/new-connection.php');
  121. $sql = "SELECT * FROM technica_frontpage WHERE id = $id";
  122. $result = $conn->query($sql);
  123. if ($result->num_rows > 0) {
  124. while($row = $result->fetch_assoc()) {?>
  125. <script src="/technica/js/jscolor.min.js"></script>
  126. <form action="frontpage.php?updateslide" method="post" enctype="multipart/form-data">
  127. <input type="hidden" name="id" value="<?php echo $id; ?>">
  128. <input type="hidden" name="oldheader" value="<?php echo $row['header']; ?>">
  129. <input type="hidden" name="oldbackground" value="<?php echo $row['background']; ?>">
  130. Text:<br><textarea name="text" rows="8" cols="80"><?php echo $row['text']; ?></textarea><br><br>
  131. URL:<br><input type="text" name="url" placeholder="URL zur verlinkten Seite"><br><br>
  132. Wenn du hier keine Datei angibst, bleibt die alte bestehen!<br>
  133. Überschrift:<input type="file" name="header"><br>
  134. Hintergrund:<input type="file" name="background"><br><br>
  135. Button Farbverlauf:<br>
  136. Farbe 1: <input class="jscolor" name="gradient1" value="<?php echo $row['gradient1']; ?>"><br>
  137. Farbe 2: <input class="jscolor" name="gradient2" value="<?php echo $row['gradient2']; ?>"><br>
  138. <input type="submit" name="" value="Eintrag speichern!" class="add-product" style="background:#21dc27;">
  139. </form>
  140. <a href="frontpage.php?delete&amp;id=<?php echo $id; ?>"><button class="add-product" style="background:#ff3030;">Diesen Eintrag löschen!</button></a><br>
  141. <a href="frontpage.php"><button type="button" name="button" class="add-product">Zurück</button></a>
  142. <?php }
  143. }
  144. mysqli_close($conn);
  145. }
  146. elseif (isset($_GET['updateslide'])) {
  147. $id = $_POST['id'];
  148. $text = $_POST['text'];
  149. $url = $_POST['url'];
  150. $gradient1 = $_POST['gradient1'];
  151. $gradient2 = $_POST['gradient2'];
  152. $oldheader = $_POST['oldheader'];
  153. $oldbackground = $_POST['oldbackground'];
  154. $upload_folder = 'technica/img/'; //Das Upload-Verzeichnis
  155. $filename1 = pathinfo($_FILES['header']['name'], PATHINFO_FILENAME);
  156. $extension1 = strtolower(pathinfo($_FILES['header']['name'], PATHINFO_EXTENSION));
  157. $filename2 = pathinfo($_FILES['background']['name'], PATHINFO_FILENAME);
  158. $extension2 = strtolower(pathinfo($_FILES['background']['name'], PATHINFO_EXTENSION));
  159.  
  160.  
  161. if ($_FILES['header']['size'] != 0){
  162. $allowed_extensions1 = 'png';
  163. if($extension1 != $allowed_extensions1) {
  164. die("Ungültige Dateiendung. Nur png-Dateien sind erlaubt");
  165. }
  166. $max_size1 = 500*1024; //500 KB
  167. if($_FILES['header']['size'] > $max_size1) {
  168. die("Bitte keine Dateien größer 500kb hochladen");
  169. }
  170. if(function_exists('exif_imagetype')) { //Die exif_imagetype-Funktion erfordert die exif-Erweiterung auf dem Server
  171. $allowed_types1 = IMAGETYPE_PNG;
  172. $detected_type1 = exif_imagetype($_FILES['header']['tmp_name']);
  173. if($detected_type1 != $allowed_types1) {
  174. die("Nur der Upload von Bilddateien ist gestattet");
  175. }
  176. }
  177. //Pfad zum Upload
  178. $new_path1 = $upload_folder.$filename1.'.'.$extension1;
  179. //Neuer Dateiname falls die Datei bereits existiert
  180. if(file_exists($new_path1)) { //Falls Datei existiert, hänge eine Zahl an den Dateinamen
  181. $id1 = 1;
  182. do {
  183. $new_path1 = $upload_folder.$filename1.'_'.$id1.'.'.$extension1;
  184. $id1++;
  185. } while(file_exists($new_path1));
  186. }
  187. $header = $filename1;
  188. move_uploaded_file($_FILES['header']['tmp_name'], $new_path1);
  189. unlink($upload_folder.$oldheader.'.'.$extension1);
  190. }
  191. if ($_FILES['header']['size'] == 0){
  192. $header = $oldheader;
  193. }
  194.  
  195. if ($_FILES['background']['size'] != 0){
  196. $allowed_extensions2 = 'jpg';
  197. if($extension2 != $allowed_extensions2) {
  198. die("Ungültige Dateiendung. Nur jpg-Dateien sind erlaubt");
  199. }
  200. $max_size2 = 500*1024; //500 KB
  201. if($_FILES['background']['size'] > $max_size2) {
  202. die("Bitte keine Dateien größer 500kb hochladen");
  203. }
  204. if(function_exists('exif_imagetype')) { //Die exif_imagetype-Funktion erfordert die exif-Erweiterung auf dem Server
  205. $allowed_types2 = IMAGETYPE_JPEG;
  206. $detected_type2 = exif_imagetype($_FILES['background']['tmp_name']);
  207. if($detected_type2 != $allowed_types2) {
  208. die("Nur der Upload von Bilddateien ist gestattet");
  209. }
  210. }
  211. //Pfad zum Upload
  212. $new_path2 = $upload_folder.$filename2.'.'.$extension2;
  213. //Neuer Dateiname falls die Datei bereits existiert
  214. if(file_exists($new_path2)) { //Falls Datei existiert, hänge eine Zahl an den Dateinamen
  215. $id2 = 1;
  216. do {
  217. $new_path2 = $upload_folder.$filename2.'_'.$id2.'.'.$extension2;
  218. $id++;
  219. } while(file_exists($new_path2));
  220. }
  221. $background = $filename2;
  222. move_uploaded_file($_FILES['background']['tmp_name'], $new_path2);
  223. unlink($upload_folder.$oldbackground.'.'.$extension2);
  224. }
  225. if ($_FILES['background']['size'] == 0){
  226. $background = $oldbackground;
  227. }
  228.  
  229.  
  230. include('technica/new-connection.php');
  231. $sql = "UPDATE technica_frontpage SET header='$header', background='$background', text='$text', gradient1='$gradient1', gradient2='$gradient2', url='$url' WHERE id=$id";
  232.  
  233. if ($conn->query($sql) === TRUE) {
  234. echo "Eintrag wurde erfolgreich gespeichert!";echo"<br><a href='frontpage.php'><button type='button' name='button' class='add-product'>Zurück</button></a>";
  235. } else {
  236. echo "Fehler beim speichern!: " . $conn->error;echo"<br><a href='frontpage.php'><button type='button' name='button' class='add-product'>Zurück</button></a>";
  237. }
  238. $conn->close();
  239. }
  240. elseif (isset($_GET['updatetext'])) {
  241. $text = nl2br($_POST["abouttext"]);
  242. $text = trim($text);
  243.  
  244. include('technica/new-connection.php');
  245. $sql = "UPDATE fronttext SET about='$text'";
  246.  
  247. if ($conn->query($sql) === TRUE) {
  248. echo "Eintrag wurde erfolgreich gespeichert!";echo"<br><a href='frontpage.php'><button type='button' name='button' class='add-product'>Zurück</button></a>";
  249. } else {
  250. echo "Fehler beim speichern!: " . $conn->error;echo"<br><a href='frontpage.php'><button type='button' name='button' class='add-product'>Zurück</button></a>";
  251. }
  252. $conn->close();
  253. }
  254. elseif (isset($_GET['add'])) {?>
  255. <script src="/technica/js/jscolor.min.js"></script>
  256. <form action="frontpage.php?added" method="post" enctype="multipart/form-data">
  257. Text:<textarea name="text" rows="8" style="min-width:100%;max-width:100%;"></textarea><br>
  258. Header:<input type="file" name="header" accept=".png"><br>
  259. Hintergrund:<input type="file" name="background" accept=".jpg"><br>
  260. Button Farbverlauf:<br>
  261. Farbe 1: <input class="jscolor" name="gradient1" value="<?php echo $row['gradient1']; ?>"><br>
  262. Farbe 2: <input class="jscolor" name="gradient2" value="<?php echo $row['gradient2']; ?>"><br>
  263. <input type="submit" name="" value="Eintrag hinzufügen!" class="add-product" style="background:#21dc27;">
  264. </form>
  265. <a href="frontpage.php"><button type="button" name="button" class="add-product">Zurück</button></a>
  266. <?php }
  267. elseif (isset($_GET['added'])) {
  268. $text = $_POST['text'];
  269. $gradient1 = $_POST['gradient1'];
  270. $gradient2 = $_POST['gradient2'];
  271. $upload_folder = 'technica/img/'; //Das Upload-Verzeichnis
  272. $filename1 = pathinfo($_FILES['header']['name'], PATHINFO_FILENAME);
  273. $extension1 = strtolower(pathinfo($_FILES['header']['name'], PATHINFO_EXTENSION));
  274. $filename2 = pathinfo($_FILES['background']['name'], PATHINFO_FILENAME);
  275. $extension2 = strtolower(pathinfo($_FILES['background']['name'], PATHINFO_EXTENSION));
  276.  
  277.  
  278. if ($_FILES['header']['size'] != 0){
  279. $allowed_extensions1 = 'png';
  280. if($extension1 != $allowed_extensions1) {
  281. die("Ungültige Dateiendung. Nur png-Dateien sind erlaubt<br><a href='frontpage.php'><button type='button' name='button' class='add-product'>Zurück</button></a>");
  282. }
  283. $max_size1 = 5000*1024; //500 KB
  284. if($_FILES['header']['size'] > $max_size1) {
  285. die("Bitte keine Dateien größer 5MB hochladen<br><a href='frontpage.php'><button type='button' name='button' class='add-product'>Zurück</button></a>");
  286. }
  287. if(function_exists('exif_imagetype')) { //Die exif_imagetype-Funktion erfordert die exif-Erweiterung auf dem Server
  288. $allowed_types1 = IMAGETYPE_PNG;
  289. $detected_type1 = exif_imagetype($_FILES['header']['tmp_name']);
  290. if($detected_type1 != $allowed_types1) {
  291. die("Nur der Upload von Bilddateien ist gestattet<br><a href='frontpage.php'><button type='button' name='button' class='add-product'>Zurück</button></a>");
  292. }
  293. }
  294. //Pfad zum Upload
  295. $new_path1 = $upload_folder.$filename1.'.'.$extension1;
  296. //Neuer Dateiname falls die Datei bereits existiert
  297. if(file_exists($new_path1)) { //Falls Datei existiert, hänge eine Zahl an den Dateinamen
  298. $id1 = 1;
  299. do {
  300. $new_path1 = $upload_folder.$filename1.'_'.$id1.'.'.$extension1;
  301. $id1++;
  302. } while(file_exists($new_path1));
  303. }
  304. $header = $filename1;
  305. move_uploaded_file($_FILES['header']['tmp_name'], $new_path1);
  306. }
  307. if ($_FILES['header']['size'] == 0){
  308. die("Es muss ein Bild hochgeladen werden!<br><a href='frontpage.php'><button type='button' name='button' class='add-product'>Zurück</button></a>");
  309. }
  310.  
  311. if ($_FILES['background']['size'] != 0){
  312. $allowed_extensions2 = 'jpg';
  313. if($extension2 != $allowed_extensions2) {
  314. die("Ungültige Dateiendung. Nur jpg-Dateien sind erlaubt<br><a href='frontpage.php'><button type='button' name='button' class='add-product'>Zurück</button></a>");
  315. }
  316. $max_size2 = 5000*1024; //500 KB
  317. if($_FILES['background']['size'] > $max_size2) {
  318. die("Bitte keine Dateien größer 5MB hochladen<br><a href='frontpage.php'><button type='button' name='button' class='add-product'>Zurück</button></a>");
  319. }
  320. if(function_exists('exif_imagetype')) { //Die exif_imagetype-Funktion erfordert die exif-Erweiterung auf dem Server
  321. $allowed_types2 = IMAGETYPE_JPEG;
  322. $detected_type2 = exif_imagetype($_FILES['background']['tmp_name']);
  323. if($detected_type2 != $allowed_types2) {
  324. die("Nur der Upload von Bilddateien ist gestattet<br><a href='frontpage.php'><button type='button' name='button' class='add-product'>Zurück</button></a>");
  325. }
  326. }
  327. //Pfad zum Upload
  328. $new_path2 = $upload_folder.$filename2.'.'.$extension2;
  329. //Neuer Dateiname falls die Datei bereits existiert
  330. if(file_exists($new_path2)) { //Falls Datei existiert, hänge eine Zahl an den Dateinamen
  331. $id2 = 1;
  332. do {
  333. $new_path2 = $upload_folder.$filename2.'_'.$id2.'.'.$extension2;
  334. $id++;
  335. } while(file_exists($new_path2));
  336. }
  337. $background = $filename2;
  338. move_uploaded_file($_FILES['background']['tmp_name'], $new_path2);
  339. }
  340. if ($_FILES['background']['size'] == 0){
  341. die("Es muss ein Bild hochgeladen werden!<br><a href='frontpage.php'><button type='button' name='button' class='add-product'>Zurück</button></a>");
  342. }
  343.  
  344. include('technica/new-connection.php');
  345. $sql = "INSERT INTO technica_frontpage (header, background, text, gradient1, gradient2)
  346. VALUES ('$header', '$background', '$text', '$gradient1', '$gradient2')";
  347.  
  348. if ($conn->query($sql) === TRUE) {
  349. echo "Eintrag wurde erfolgreich gespeichert!";echo"<br><a href='frontpage.php'><button type='button' name='button' class='add-product'>Zurück</button></a>";
  350. }
  351. $conn->close();
  352. }
  353. elseif (isset($_GET['delete'])) {
  354. $id = $_GET['id'];
  355. include('technica/new-connection.php');
  356. // sql to delete a record
  357. $sql = "DELETE FROM technica_frontpage WHERE id=$id";
  358.  
  359. if ($conn->query($sql) === TRUE) {
  360. echo "Eintrag erfolgreich gelöscht";
  361. } else {
  362. echo "Fehler beim löschen: " . $conn->error;
  363. }
  364. $conn->close();
  365. echo"<br><a href='frontpage.php'><button type='button' name='button' class='add-product'>Zurück</button></a>";
  366. }
  367. else {
  368. echo"<p>Klicke auf einen Eintrag um diesen zu ändern!</p><table>";
  369. echo "test";
  370. include('/technica/new-connection.php');
  371. echo "2test";
  372. $rowi = 1;
  373. $sql = "SELECT id, header FROM technica_frontpage";
  374. echo "2test";
  375. $statement = $conn->prepare($sql);
  376. echo "2test";
  377. $statement->execute();
  378. $result = $statement->get_result();
  379.  
  380. if ($result->num_rows != 0) {
  381. // output data of each row
  382. while($row = $result->fetch_assoc()) {
  383. echo "<div onclick=\"window.document.location='frontpage.php?editslide&amp;id=".$row['id'].":';\" class='eintrag'>
  384. <b><span style='margin-right: 15px;'>".$rowi."</span></b><span>".$row['header']."</span></div>";
  385. $rowi++;
  386. }
  387. }
  388. else{
  389. echo "Nothing found";
  390. }
  391. echo"</table><a href='frontpage.php?add'><button type='button' name='button' class='add-product'>Slide hinzugügen!</button></a>
  392. </div>
  393. </div>
  394. </div>
  395. </div>
  396. </div><!--/.row-->
  397. <div class='row'>
  398. <div class='col-lg-12'>
  399. <div class='panel panel-default'>
  400. <div class='panel-heading'><b>&apos;Über Uns&apos;</b> Text verwalten</div>
  401. <div class='panel-body'>
  402. <div class='canvas-wrapper'>
  403. <form action='frontpage.php?updatetext' method='post' enctype='multipart/form-data'>";
  404. require_once('technica/new-connection.php');
  405. $sql = "SELECT * FROM fronttext";
  406. $result = $conn->query($sql);
  407. $rowi = 1;
  408. if ($result->num_rows > 0) {
  409. // output data of each row
  410. while($row = $result->fetch_assoc()) {
  411. echo"<textarea name='abouttext' rows='11' style='min-width:100%;max-width:100%;'>"; echo strip_tags($row['about']); echo"</textarea><br>";
  412. $rowi++;
  413. }
  414. }
  415. mysqli_close($conn);
  416. echo"<input type='submit' name='' value='Text ändern!' class='add-product'>
  417. </form>
  418. </div>
  419. </div>
  420. </div>
  421. </div>
  422. </div><!--/.row-->";
  423. }
  424. ?>
  425. </div> <!--/.main-->
  426.  
  427. <script src="js/jquery-1.11.1.min.js"></script>
  428. <script src="js/bootstrap.min.js"></script>
  429. <script src="js/chart.min.js"></script>
  430. <script src="js/chart-data.js"></script>
  431. <script src="js/easypiechart.js"></script>
  432. <script src="js/easypiechart-data.js"></script>
  433. <script src="js/bootstrap-datepicker.js"></script>
  434. <script>
  435. $('#calendar').datepicker({
  436. });
  437.  
  438. !function ($) {
  439. $(document).on("click","ul.nav li.parent > a > span.icon", function(){
  440. $(this).find('em:first').toggleClass("glyphicon-minus");
  441. });
  442. $(".sidebar span.icon").find('em:first').addClass("glyphicon-plus");
  443. }(window.jQuery);
  444.  
  445. $(window).on('resize', function () {
  446. if ($(window).width() > 768) $('#sidebar-collapse').collapse('show')
  447. })
  448. $(window).on('resize', function () {
  449. if ($(window).width() <= 767) $('#sidebar-collapse').collapse('hide')
  450. })
  451. </script>
  452. </body>
  453. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!