Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include("../assets/php/auth.php");
- include("../assets/php/config.php");
- include("../assets/php/pdo.php");
- if(isset($_POST['change'])){
- $rankname = $_POST['rankname'];
- $request_1 = $_POST['request_1'];
- $request_2 = $_POST['request_2'];
- $request_3 = $_POST['request_3'];
- $request_4 = $_POST['request_4'];
- $request_5 = $_POST['request_5'];
- $id = $_GET['id'];
- $stmt_update_ranks = $pdo->prepare("UPDATE ranks SET rankname=? WHERE id=?");
- $stmt_update_ranks->execute(array($rankname,$id));
- $stmt_update_request = $pdo->prepare("UPDATE request SET request_1=?, request_2=?, request_3, request_4, request_5 WHERE id=?");
- $stmt_update_request->execute(array($request_1,$request_2,$request_3,$request_4,$request_5,$id));
- header("Location: change.php");
- }
- ?>
- <!doctype html>
- <html>
- <head>
- <meta charset="utf-8">
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <title><?php echo $title; ?></title>
- <link rel="stylesheet" href="assets/css/bootstrap.css">
- <link rel="stylesheet" href="assets/css/style.css">
- <script src="assets/js/bootstrap.js"></script>
- </head>
- <body>
- <?php
- $id = $_GET['id'];
- $stmt = $pdo->query("SELECT * FROM ranks WHERE id=$id");
- $stmt_request = $pdo->query("SELECT * FROM request WHERE id=$id");
- $rows = $stmt->rowCount();
- if($rows > 0){
- $row = $stmt->fetch();
- $row_request = $stmt_request->fetch();
- if($row_request['request_2'] == 'Null'){
- $row_request['request_2'] = '';
- }
- if($row_request['request_3'] == 'Null'){
- $row_request['request_3'] = '';
- }
- if($row_request['request_4'] == 'Null'){
- $row_request['request_4'] = '';
- }
- if($row_request['request_5'] == 'Null'){
- $row_request['request_5'] = '';
- }
- echo '<form method="post">
- <input type="text" name="rankname" value="'.$row['rankname'].'" placeholder="Rang" requierd><br>
- <input type="text" name="request_1" value="'.$row_request['request_1'].'" placeholder="Anforderung" required><br>
- <input type="text" name="request_2" value="'.$row_request['request_2'].'" placeholder="Anforderung"><br>
- <input type="text" name="request_3" value="'.$row_request['request_3'].'" placeholder="Anforderung"><br>
- <input type="text" name="request_4" value="'.$row_request['request_4'].'" placeholder="Anforderung"><br>
- <input type="text" name="request_5" value="'.$row_request['request_5'].'" placeholder="Anforderung"><br>
- <input type="submit" name="change" value="Ändern">
- </form>
- ';
- }else{
- header("Location: change.php");
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement