<?php
/**
 * Created by PhpStorm.
 * User: leanderschmedemann
 * Date: 04/04/2017
 * Time: 12:14
 */

require_once('includes.inc.php');
$db = new Database();
$error = 0;

$categories = $db->query(
    'SELECT "ID", "name" 
    FROM "Categories"'
)['data'];
$data = array();
foreach($categories as $cat) {
    $id = $cat['ID'];
    $name = $cat['name'];
    $category = array('id' => $id, 'name' => $name);
    $data[] = $category;
}

$response = Database::create_response($data, $error);
print_r($response);

?>