Advertisement
Guest User

Untitled

a guest
May 27th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. <?php
  2. require 'database.php';
  3. $id = 0;
  4.  
  5. if ( !empty($_GET['id'])) {
  6. $id = $_REQUEST['id'];
  7. }
  8.  
  9. if ( !empty($_POST)) {
  10. // keep track post values
  11. $id = $_POST['id'];
  12.  
  13. // delete data
  14. $pdo = Database::connect();
  15. $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  16. $sql = "DELETE FROM customers WHERE id = ?";
  17. $q = $pdo->prepare($sql);
  18. $q->execute(array($id));
  19. Database::disconnect();
  20. header("Location: index.php");
  21.  
  22. }
  23. ?>
  24.  
  25. <!DOCTYPE html>
  26. <html lang="en">
  27. <head>
  28. <meta charset="utf-8">
  29. <link href="css/bootstrap.min.css" rel="stylesheet">
  30. <script src="js/bootstrap.min.js"></script>
  31. </head>
  32.  
  33. <body>
  34. <div class="container">
  35.  
  36. <div class="span10 offset1">
  37. <div class="row">
  38. <h3>Delete a Customer</h3>
  39. </div>
  40.  
  41. <form class="form-horizontal" action="delete.php" method="post">
  42. <input type="hidden" name="id" value="<?php echo $id;?>"/>
  43. <p class="alert alert-error">Are you sure to delete ?</p>
  44. <div class="form-actions">
  45. <button type="submit" class="btn btn-danger">Yes</button>
  46. <a class="btn" href="index.php">No</a>
  47. </div>
  48. </form>
  49. </div>
  50.  
  51. </div> <!-- /container -->
  52. </body>
  53. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement