|
<?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); |
|
?> |