post_candidates.php

   1 <?php
   2
   3 function handle_request($id, $input) {
   4     $input = json_decode($input, true);
   5
   6     $db = new SQLite3('database.sqlite');
   7     $db->exec("INSERT INTO candidatos (nombre) VALUES ('{$input['name']}')");
   8     $id = $db->lastInsertRowID();
   9     $candidate = $db->querySingle("SELECT id, nombre FROM candidatos WHERE id = {$id}", true);
  10     $db->close();
  11
  12     echo json_encode([
  13         'id' => $candidate['id'],
  14         'name' => $candidate['nombre'],
  15     ]);
  16 }