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