Advertisement
Guest User

Untitled

a guest
Jan 30th, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.72 KB | None | 0 0
  1. if($user == $me){
  2. $sql_delete = "DELETE FROM replys WHERE id = '$id' AND rusername = '$me'";
  3. echo $sql_delete;
  4. mysql_query($sql_delete) or die(mysql_error());
  5. echo "Deleted";
  6. }
  7. else{
  8. }
  9. }
  10. ?>
  11.  
  12. <?php
  13. session_start();
  14. if(isset($_POST['DeleteThis'])){
  15.  
  16. $db_host = "localhost";
  17. $db_user = "root";
  18. $db_pass = "kindom";
  19. $db_name = "posters";
  20.  
  21. try {
  22. $user = $_SESSION['username'];
  23. $form = $_POST;
  24. $id = $form['id']);
  25. $me = $form['me'];
  26. if($me == $user){
  27.  
  28.  
  29. $db_conn = new PDO("mysql:host={$db_host};dbname={$db_name}",$db_user,$db_pass);
  30. $db_conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  31.  
  32. $stmt = $db_conn->prepare("UPDATE blog_post SET blog_title = :blog_title, blog_body = :blog_body WHERE BID = {$alter}");
  33.  
  34. //I have tried using this SQL statements
  35. //$query = "DELETE replys WHERE id = {$id} AND rusername = {$user}";
  36. //$query = "DELETE *replys WHERE id = :id AND rusername = :rusername";
  37. $query = "DELETE replys WHERE id = :id AND rusername = :rusername";
  38.  
  39.  
  40. $stmt->bindParam(':id', $id);
  41. $stmt->bindParam(':rusername', $user);
  42.  
  43.  
  44. $stmt->execute();
  45. echo "Deleted";
  46.  
  47. }
  48.  
  49. else{
  50. //Do nothing
  51. }
  52. }
  53. catch(PDOException $e)
  54. {
  55. echo "Error:" . $e->getMessage();
  56. }
  57. $db_conn = null;
  58.  
  59. }
  60.  
  61. ?>
  62.  
  63. <a href="javascript:void(0);" onclick="document.getElementById('deleterp').submit();"><i style="font-size:17px;color:#F00;" class="fa fa-trash"></i></a>
  64. <form id="deleterp" action="" method="POST">
  65. <input type="hidden" name="id" value="<?php echo $rpId;?>"/>
  66. <input type="hidden" name="DeleteThis" value="1"/>
  67. <input type="hidden" name="me" value="<?php echo $rplyuser;?>"/>
  68. </form></div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement