$created = $data['created'];
$query = "INSERT INTO poll VALUES(NULL, {$owner}, '{$title}', '{$question}', '{$is_open}', {$created})";
mysql_query($query) or die(mysql_error());
$query = "SELECT id, owner as ownerId, title, question, is_open as isOpen, created FROM poll WHERE title like '{$title}'";
$ret = queryArray($query, Flight::get('pollCols'));
echo Flight::json($ret[0]);
});
//---------
// UPDATE
//---------
// ! PUT does not work for unknown reasons here. So we circumvent this problem by using a post to a different url instead
Flight::route('POST /api/poll/put', function () {
$json = Flight::request()->data->json;
$data = json_decode($json, true);
$id = $data['id'];
$owner = $data['ownerId'];
$title = $data['title'];
$question = $data['question'];
$is_open = getBoolean($data['isOpen']);
$created = $data['created'];
$query = "UPDATE poll SET owner={$owner}, title='{$title}', question='{$question}', is_open='{$is_open}', created={$created} WHERE id={$id}";
mysql_query($query) or die(mysql_error());
$query = "SELECT id, owner as ownerId, title, question, is_open as isOpen, created FROM poll WHERE title like '{$title}'";
$ret = queryArray($query, Flight::get('pollCols'));
echo Flight::json($ret[0]);
});
Flight::route('*', function () {
echo 'Invalid path requested!';
});
Flight::set('dbConn', getDBconn());
Flight::start();
<?php
require_once '../sql/functions.php';
$db = getDBconn();
$rss = array();
!empty($_GET['rss']) ? $rss[] = array('rss' => $_GET['rss']) : ($rss[] = array('rss' => NULL));
!empty($_GET['id']) ? $rss[] = array('id' => $_GET['id']) : ($rss[] = array('id' => NULL));
!empty($_GET['format']) ? $rss[] = array('format' => $_GET['format']) : ($rss[] = array('format' => NULL));
constructRss($rss, $db);
