| <?php | <?php |
| include("config.php"); | include("config.php"); |
| header("Content-Type: application/json"); | header("Content-Type: application/json"); |
| $result = Array(); | $result = Array(); |
| $page = filter_input(INPUT_GET, 'page',FILTER_SANITIZE_NUMBER_INT); | $page = filter_input(INPUT_GET, 'page', FILTER_SANITIZE_NUMBER_INT); |
| $perPage = filter_input(INPUT_GET, 'perPage',FILTER_SANITIZE_NUMBER_INT); | $perPage = filter_input(INPUT_GET, 'perPage', FILTER_SANITIZE_NUMBER_INT); |
| $offset = filter_input(INPUT_GET, 'offset',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"; | $query = "Select acnabn, service_name from dcaas_services order by acnabn"; |
| $total = $db->query("select count(*) from dcaas_services")->fetch(PDO::FETCH_NUM); | $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) { | foreach ($db->query($query . " limit $offset," . ($page * $perPage), PDO::FETCH_ASSOC) as $row) { |
| $result['records'][] = $row; | $result['records'][] = $row; |
| } | } |
| $result['queryRecordCount'] = intval($total[0]); | $result['queryRecordCount'] = intval($total[0]); |
| $result['totalRecordCount'] = intval($total[0]); | $result['totalRecordCount'] = intval($total[0]); |
| echo json_encode($result); | echo json_encode($result); |
| ?> | ?> |