Advertisement
Guest User

delete student

a guest
Mar 21st, 2019
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. <?php
  2. require_once('Moore_Abigail_dbconnect.php');
  3.  
  4. //get ids
  5. $studentID = filter_input(INPUT_POST, 'studentID', FILTER_VALIDATE_INT);
  6.  
  7. //echo $studentID."<br>";
  8.  
  9. //delete student from db
  10.  
  11. if($studentID != false) {
  12. $query = 'Delete from students
  13. Where studentID = :studentID';
  14. $statement = $db->prepare($query);
  15. $statement->bindValue(':studentID', $studentID);
  16. $success = $statement->execute();
  17. $statement->closeCursor();
  18. }
  19. include('Moore_Abigail_index.php');
  20. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement