PHP SubmissionDatabase Examples

Example #1

File: setup.php Project: andreasunteidig/meetingPoint

<?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);

Example #2

File: index.php Project: andreasunteidig/meetingPoint

 /**
  *
  * @url GET /?submissions/$id
  */
 function deleteSubmission($id)
 {
     $db = new SubmissionDatabase();
     $result = $db->deleteSubmission($id);
     return array();
 }