Guest User

Untitled

a guest
Jun 15th, 2019
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.68 KB | None | 0 0
  1. <?php
  2. include('../assets/config.php');
  3. session_start();
  4. if(!isset($_SESSION['userid'])) {
  5. die('Bitte zuerst <a href="login.php">einloggen</a>');
  6. }
  7.  
  8.  
  9.  
  10.  
  11. ?>
  12. <!doctype html>
  13. <html>
  14. <head>
  15. <meta charset="utf-8">
  16. <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
  17. <title>Unbenanntes Dokument</title>
  18. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
  19. <link href="https://fonts.googleapis.com/css?family=Exo+2|Kaushan+Script|Montserrat&display=swap" rel="stylesheet">
  20. <link rel="stylesheet" href="assets/css/style.css">
  21. <script src="https://kit.fontawesome.com/ced659535a.js"></script>
  22. </head>
  23.  
  24. <body>
  25. <style>
  26. body {
  27. text-align: center;
  28. }
  29. </style>
  30. <h4>Developer Bewerbungen</h4>
  31. <?php
  32. $statementdeveloper = "SELECT * FROM bewerbungen where als = 'developer'";
  33. $resultdeveloper = mysqli_query($db, $statementdeveloper);
  34.  
  35. while($row = mysqli_fetch_array($resultdeveloper)){
  36. if($row){
  37. echo'
  38. <p>Bewerbung: '.$row['id'].'</p>
  39. <p>Username: '.$row['username'].'</p>
  40. <p>Vorname: '.$row['vorname'].'</p>
  41. <p>Email: '.$row['email'].'</p>
  42. <p>Onlinezeiten: '.$row['onlinezeit'].'</p>
  43. <p>Kontakt: '.$row['kontakt'].'</p>
  44. <p><u>Bewerbungsschreiben</u><br>'.$row['bewerbung'].'</p>
  45. <hr>
  46. ';
  47. }
  48. }
  49. ?>
  50. <h4>Supporter Bewerbungen</h4>
  51. <?php
  52. $statementsupporter = "Select * FROM bewerbungen where als = 'supporter'";
  53. $resultsupporter = mysqli_query($db, $statementsupporter);
  54.  
  55. while($row = mysqli_fetch_array($resultsupporter)){
  56. if($row){
  57. echo'
  58. <p>Bewerbung: '.$row['id'].'</p>
  59. <p>Username: '.$row['username'].'</p>
  60. <p>Vorname: '.$row['vorname'].'</p>
  61. <p>Email: '.$row['email'].'</p>
  62. <p>Onlinezeiten: '.$row['onlinezeit'].'</p>
  63. <p>Kontakt: '.$row['kontakt'].'</p>
  64. <p><u>Bewerbungsschreiben</u><br>'.$row['bewerbung'].'</p>
  65. <hr>
  66. ';
  67. }
  68. }
  69.  
  70. ?>
  71. <h4>Builder Bewerbungen</h4>
  72. <?php
  73. $statementbuilder = "Select * FROM bewerbung where als = 'builder'";
  74. $resultbuilder = mysqli_query($db, $statementbuilder);
  75.  
  76. while($row = mysqli_fetch_array($resultbuilder)){
  77. if($row){
  78. echo'
  79. <p>Bewerbung: '.$row['id'].'</p>
  80. <p>Username: '.$row['username'].'</p>
  81. <p>Vorname: '.$row['vorname'].'</p>
  82. <p>Email: '.$row['email'].'</p>
  83. <p>Onlinezeiten: '.$row['onlinezeit'].'</p>
  84. <p>Kontakt: '.$row['kontakt'].'</p>
  85. <p><u>Bewerbungsschreiben</u><br>'.$row['bewerbung'].'</p>
  86. <hr>
  87. ';
  88. }
  89. }
  90. ?>
  91. </body>
  92. </html>
Advertisement
Add Comment
Please, Sign In to add comment