--- a/data.json.php +++ b/data.json.php @@ -1,1 +1,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); +?>