Advertisement
Guest User

Untitled

a guest
Mar 9th, 2016
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. $book = $_GET["book"];
  2. $email = $_SESSION["email"];
  3.  
  4. $servername = "";
  5. $username = "";
  6. $password = "";
  7. $dbname = "";
  8.  
  9. $conn = new mysqli($servername, $username, $password, $dbname);
  10. // Check connection
  11. if ($conn->connect_error) {
  12. die("Connection failed: " . $conn->connect_error);
  13. }
  14.  
  15. // sql to delete a record
  16. $sql = "DELETE FROM books WHERE email = '". $email ."' and name = '". $book ."'";
  17.  
  18. if ($conn->query($sql) === TRUE) {
  19. echo "Record deleted successfully";
  20. } else {
  21. echo "Error deleting record: " . $conn->error;
  22. }
  23.  
  24. $conn->close();
  25.  
  26.  
  27.  
  28. ?>
  29.  
  30. while($row = mysql_fetch_array($result)) {
  31.  
  32. echo "<div id='book'>
  33. <ol>
  34. <li>";
  35. echo $row['name'];
  36. echo "</li><li>";
  37. echo $row['price'];
  38. echo "</li>
  39. </ol>
  40. <form action='deleteBook.php' method='get'>
  41. <input type='hidden' name='book' value=". $row['name'] ." />
  42. <button type='submit'>Delete</button></form></div>";
  43.  
  44. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement