Advertisement
Guest User

Untitled

a guest
Mar 19th, 2019
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.13 KB | None | 0 0
  1. <?php
  2. session_start();
  3. require "config/database.php";
  4. include "templates/header.php";
  5.  
  6. if($_SESSION["role"] != "Admin"){
  7.   header("Location: index.php");
  8.   exit();
  9. }
  10. ?>
  11.  
  12. <?php
  13.  
  14. if (isset($_GET['id'])){
  15.     $id = $_GET['id'];
  16.  
  17.     $sql = 'SELECT * FROM users WHERE id=:id';
  18.     $stmt = $conn->prepare($sql);
  19.     $stmt->bindValue(':id', $id);
  20.     $stmt->execute();
  21.     $row = $stmt->fetch();
  22.  
  23.  
  24.     $userFirstname = $row['firstname'];
  25.     $userLastname = $row['lastname'];
  26.     $userUsername = $row['username'];
  27.     $userPassword = $row['password'];
  28.     $userRole = $row['role'];
  29. }
  30.  
  31.  
  32. if (isset($_POST['update'])){
  33.  
  34.     $firstname = $_POST['firstname'];
  35.     $lastname = $_POST['lastname'];
  36.     $username = $_POST['username'];
  37.     $password = $_POST['password'];
  38.     $role = $_POST['role'];
  39.  
  40.     if (empty($firstname) || empty($lastname) || empty($username) || empty($password)){
  41.         echo "Not all fields filled!";
  42.     } else {
  43.         $sql = "UPDATE users SET firstname = :firstname, lastname = :lastname, username = :username, password = :password, role = :role WHERE id = :id";
  44.  
  45.         $stmt = $conn->prepare($sql);
  46.    
  47.         $stmt->bindValue(':id', $id);
  48.         $stmt->bindValue(':firstname', $firstname);
  49.         $stmt->bindValue(':lastname', $lastname);
  50.         $stmt->bindValue(':username', $username);
  51.         $stmt->bindValue(':password', $password);
  52.         $stmt->bindValue(':role', $role);
  53.    
  54.         $stmt->execute();
  55.         header("Location: views/admin.php");
  56.     }
  57. }
  58. ?>
  59.  
  60. <form method="POST">
  61.     <input type="text" name="firstname" Value=<?php echo $userFirstname;?>>
  62.     <input type="text" name="lastname" Value=<?php echo $userLastname;?>>
  63.     <input type="text" name="username" Value=<?php echo $userUsername;?>>
  64.     <input type="password" name="password" Value=<?php echo $userPassword;?>>
  65.     <select name="role">
  66.       <option value="Admin">Admin</option>
  67.       <option value="Chef">Chef</option>
  68.       <option value="Waiter">Waiter</option>
  69.       <option value="Bartender">Bartender</option>
  70.     </select>
  71.     <input type="submit" name="update" Value="Update user">
  72.     </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement