has('questions', ['qid' => $qid])) { die(); } $total = $database->count('responses', ['qid' => $qid]); $answers = $database->select('answers', ['aid', 'atext'], ['qid' => $qid]); $data['total'] = $total; $data['answers'] = []; foreach ($answers as $a) { $votes = $database->count('responses', ['aid' => $a['aid']]); $data['answers'][] = [ "id" => $a['aid'], "votes" => $votes, "percent" => ($votes / $total) * 100.0 . "%" ]; } $responses = $database->select('responses', ['name', 'aid'], ['qid' => $qid]); $data['responses'] = []; foreach ($responses as $r) { if ($r['name'] == null) { $r['name'] = "Anonymous"; } $data['responses'][] = [ "name" => $r['name'], "aid" => $r['aid'] ]; } echo json_encode($data);