<?php
require "SubmissionDatabase.php";
// DB TESTS
echo "<h1>SUBMISSIONS DB</h1>";
$db = new SubmissionDatabase();
$db->create();
//create topics id,title,text,image,category_id
$db->insertSubmission(array("id" => null, "title" => "Life", "text_question" => "Lorem ipsum?", "text_result" => "Lorem ipsum!", "image_question" => "blabla?", "image_result" => "sladhkjsad.jpg", "category" => "event"));
$db->insertSubmission(array("id" => null, "title" => "Life", "text_question" => null, "text_result" => null, "image_question" => "blabla?", "image_result" => "sladhkjsad.jpg", "category" => "location"));
$result = $db->listSubmissions();
var_dump($result);
/**
* @noAuth
* @url GET /?submissions
*/
function listSubmissions()
{
$db = new SubmissionDatabase();
$result = $db->listSubmissions();
return $result;
}
