delete_candidates_id.php

   1 <?php
   2
   3 function handle_request($id, $input) {
   4     $db = new SQLite3('database.sqlite');
   5     $id = $db->querySingle("SELECT id FROM candidatos WHERE id = {$id}");
   6
   7     if (empty($id)) {
   8         header('HTTP/1.1 404 Not Found');
   9     } else {
  10         $db->exec("DELETE FROM candidatos WHERE id = {$id}");
  11         $db->exec("DELETE FROM votos WHERE candidato_id = {$id}");
  12     }
  13
  14     $db->close();
  15 }