Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include('../assets/config.php');
- session_start();
- if(!isset($_SESSION['userid'])) {
- die('Bitte zuerst <a href="login.php">einloggen</a>');
- }
- if(isset($_GET['del']) and !empty($_GET['del'])){
- mysqli_query($db, 'DELETE FROM bewerbungen WHERE id = '.(int)$_GET['del']);
- }
- ?>
- <!doctype html>
- <html>
- <head>
- <meta charset="utf-8">
- <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
- <title>Unbenanntes Dokument</title>
- <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">
- <link href="https://fonts.googleapis.com/css?family=Exo+2|Kaushan+Script|Montserrat&display=swap" rel="stylesheet">
- <link rel="stylesheet" href="assets/css/style.css">
- <script src="https://kit.fontawesome.com/ced659535a.js"></script>
- </head>
- <body>
- <style>
- body {
- text-align: center;
- }
- </style>
- <h4>Developer Bewerbungen</h4>
- <?php
- $statementdeveloper = "SELECT * FROM bewerbungen where als = 'developer'";
- $resultdeveloper = mysqli_query($db, $statementdeveloper);
- while($row = mysqli_fetch_array($resultdeveloper)){
- if($row){
- echo'
- <form action="" method="POST">
- <p>Bewerbung: '.$row['id'].'</p>
- <p>Username: '.$row['username'].'</p>
- <p>Vorname: '.$row['vorname'].'</p>
- <p>Email: '.$row['email'].'</p>
- <p>Onlinezeiten: '.$row['onlinezeit'].'</p>
- <p>Kontakt: '.$row['kontakt'].'</p>
- <p><u>Bewerbungsschreiben</u><br>'.$row['bewerbung'].'</p>
- </form>
- <a href="bewerbungen.php?del='.$row['id'].'->ID">Löschen</a>
- <hr>
- ';
- }
- }
- ?>
- <h4>Supporter Bewerbungen</h4>
- <?php
- $statementsupporter = "Select * FROM bewerbungen where als = 'supporter'";
- $resultsupporter = mysqli_query($db, $statementsupporter);
- while($row = mysqli_fetch_array($resultsupporter)){
- if($row){
- echo'
- <form action="" method="POST">
- <p>Bewerbung: '.$row['id'].'</p>
- <p>Username: '.$row['username'].'</p>
- <p>Vorname: '.$row['vorname'].'</p>
- <p>Email: '.$row['email'].'</p>
- <p>Onlinezeiten: '.$row['onlinezeit'].'</p>
- <p>Kontakt: '.$row['kontakt'].'</p>
- <p><u>Bewerbungsschreiben</u><br>'.$row['bewerbung'].'</p>
- </form>
- <a href="bewerbungen.php?del='.$row['id'].'->ID">Löschen</a>
- <hr>
- ';
- }
- }
- ?>
- <h4>Builder Bewerbungen</h4>
- <?php
- $statementbuilder = "Select * FROM bewerbungen where als = 'builder'";
- $resultbuilder = mysqli_query($db, $statementbuilder);
- while($row = mysqli_fetch_array($resultbuilder)){
- if($row){
- echo'
- <form action="" method="POST">
- <p>Bewerbung: '.$row['id'].'</p>
- <p>Username: '.$row['username'].'</p>
- <p>Vorname: '.$row['vorname'].'</p>
- <p>Email: '.$row['email'].'</p>
- <p>Onlinezeiten: '.$row['onlinezeit'].'</p>
- <p>Kontakt: '.$row['kontakt'].'</p>
- <p><u>Bewerbungsschreiben</u><br>'.$row['bewerbung'].'</p>
- </form>
- <a href="bewerbungen.php?del='.$row['id'].'->ID">Löschen</a>
- <hr>
- ';
- }
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement