Advertisement
Guest User

delete database user

a guest
Nov 24th, 2016
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. <?php
  2. $cookie_name = "loggedin";
  3. if (isset($_COOKIE[$cookie_name])) {
  4. $cookie_value = $_COOKIE[$cookie_name];
  5. }
  6.  
  7. $servername = "";
  8. $username = "";
  9. $password = "";
  10. $database = "";
  11.  
  12. $conn = mysqli_connect($servername, $username, $password, $database);
  13.  
  14. if (!$conn) {
  15. die("Database connection failed: ".mysqli_connect_error());
  16. }
  17.  
  18. $sql = "DELETE FROM users WHERE username='$cookie_value'";
  19.  
  20. if ($conn->query($sql) === TRUE) {
  21. header("Location: logout.php");
  22. }
  23. else {
  24. echo "Error deleting account: ".$conn->error;
  25. }
  26.  
  27. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement