get_report.php

   1 <?php
   2
   3 function handle_request($id, $input) {
   4     $list = [];
   5
   6     $db = new SQLite3('database.sqlite');
   7     $query1 = $db->query("SELECT * FROM candidatos");
   8
   9     while ($candidate = $query1->fetchArray(SQLITE3_ASSOC)) {
  10         $id = $candidate['id'];
  11         $votes = 0;
  12
  13         $query2 = $db->query("SELECT * FROM votos where candidato_id = {$id}");
  14
  15         while ($vote = $query2->fetchArray(SQLITE3_ASSOC)) {
  16             ++$votes;
  17         }
  18
  19         $list[] = [
  20             'id' => $id,
  21             'name' => $candidate['nombre'],
  22             'votes' => $votes,
  23         ];
  24     }
  25
  26     $db->close();
  27
  28     echo json_encode($list);
  29 }