add sitemap
[dcaas.git] / data.json.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<?php
include("config.php");
header("Content-Type: application/json");
$result = Array();
$page = filter_input(INPUT_GET, 'page', FILTER_SANITIZE_NUMBER_INT);
$perPage = filter_input(INPUT_GET, 'perPage', FILTER_SANITIZE_NUMBER_INT);
$offset = filter_input(INPUT_GET, 'offset', FILTER_SANITIZE_NUMBER_INT);
$query = "Select acnabn, service_name from dcaas_services order by acnabn";
$total = $db->query("select count(*) from dcaas_services")->fetch(PDO::FETCH_NUM);
foreach ($db->query($query . " limit $offset," . ($page * $perPage), PDO::FETCH_ASSOC) as $row) {
    $result['records'][] = $row;
}
$result['queryRecordCount'] = intval($total[0]);
$result['totalRecordCount'] = intval($total[0]);
echo json_encode($result);
?>