Advertisement
Guest User

Untitled

a guest
Jun 18th, 2018
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. <?php
  2. require 'includes/dbconnect.php';
  3.  
  4. if(isset($_GET['id'])){
  5. $id = $_GET['id'];
  6. }
  7.  
  8. $sql = 'SELECT * FROM users WHERE user_id = :id';
  9. $query = $pdo->prepare($sql);
  10. $query->execute(['id' => $id]);
  11.  
  12. $user = $query->fetch();
  13.  
  14. if(isset($_POST['submit'])){
  15. $username = $_POST['username'];
  16. $email = $_POST['email'];
  17.  
  18. $sql = 'UPDATE users SET username = :username, email = :email WHERE user_id = :id ';
  19. $query = $pdo->prepare($sql);
  20. $query->bindParam('username', $username);
  21. $query->bindParam('email', $email);
  22. $query->bindParam('id', $id);
  23.  
  24. $query->execute();
  25.  
  26. header("Location: users.php");
  27. }
  28. ?>
  29.  
  30. <div class="mt-2">
  31. <div class="container">
  32. <form method="post">
  33. <input type="text" name="username" value="<?php echo $user['username']; ?>" placeholder="Enter your username"><br>
  34. <input type="text" name="email" value="<?php echo $user['email']; ?>" placeholder="Enter your email"><br>
  35. <input type="submit" name="submit" value="Submit">
  36. </form>
  37. </div>
  38. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement