<?php
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET, POST');
header("Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept");

require "JSONDB.php";

if(isset($_GET["limit"])) {
	$limit = $_GET["limit"];
} else {
	$limit = 10;
}

if(isset($_GET["offset"])) {
	$offset = $_GET["offset"];
} else {
	$offset = 0;
}

if(isset($_GET["sort"])) {
	$sort = $_GET["sort"];
} else {
	$sort = "";
}

if(isset($_GET["order"])) {
	$order = $_GET["order"];
} else {
	$order = "asc";
}

if(isset($_GET["search"])) {
	$search = $_GET["search"];
} else {
	$search = "";
}

$db = new JsonDB("./");

if($search == "") {
	$result = $db->selectAll("sample");
} else {
	$result = $db->select("sample", "name", $search);
}

//get the result size
$count = sizeof($result);

//order the array
if($order != "asc") {
	$result = array_reverse($result);
}

//get the subview of the array
$result = array_slice($result, $offset, $limit);


echo "{";
echo '"total": ' . $count . ',';
echo '"rows": ';
echo json_encode($result);
echo "}";