<?php

if (isset($_REQUEST["cat"]) &&
isset($_REQUEST["sort"])) {


include_once './DataManager.php';

#Setup variables 
$cat = $_REQUEST["cat"];
$sort = $_REQUEST["sort"];

if ($cat==""){
$events = DataManager::searchAll($sort);
}else{
#Query the database to get the user details. 
$events = DataManager::searchByCategory($cat, $sort);
}
$outputArray = array();

$pom = 0;
foreach ($events as $event) {
$rowArray;
$rowArray = array(
'book_id' => $event['book_id'],
 'book_title' => $event['book_title'],
 'book_author' => $event['book_author'],
 'book_year' => $event['book_year'],
 'book_url' => $event['book_url'],
 'book_category' => $event['book_category'],
 'book_rating_plus' => $event['book_rating_plus'],
 'book_rating_minus' => $event['book_rating_minus'],
 'book_downloaded' => $event['book_downloaded']
);
$outputArray["event" . $pom] = $rowArray;
$pom++;
unset($rowArray);
}

echo json_encode($outputArray);

} else {
echo "Could not complete query. Missing parameter";
}
?>