Example #1
0
<?php

require '../config.php';
require '../classes/Database.php';
require '../classes/Event.php';
require '../classes/EventCategory.php';
require '../classes/Location.php';
$db = new Database(DB_SERVER, DB_USER, DB_PASS, DB_DATABASE);
$out = [];
if (isset($_GET['code'])) {
    $code = $_GET['code'];
    if (isset($_GET['type']) && $_GET['type'] == 'short') {
        $e = Event::selectShort($db, $code, FALSE);
        if ($e != NULL) {
            $out = $e;
        }
    } else {
        $e = Event::select($db, $code, FALSE);
        //print_r($e);
        if ($e != NULL) {
            $cat = EventCategory::select($db, $e[Event::EVENT_CAT_ID]);
            $e["cat_name"] = $category = $cat->getName();
            $locid = $e[Event::EVENT_LOCATIONID];
            $loc = Location::select($db, $locid);
            $location = isset($loc) ? $loc->getName() : "notset";
            $loc_type = isset($loc) ? $loc->getType() : "notset";
            $loc_lon = isset($loc) ? $loc->getLongitude() : "notset";
            $loc_latt = isset($loc) ? $loc->getLattitude() : "notset";
            $e['location_name'] = $location;
            $e['location_type'] = $loc_type;
            $e['location_lattitude'] = $loc_latt;