post_vote.php

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