add sitemap
[dcaas.git] / data.json.php
blob:a/data.json.php -> blob:b/data.json.php
--- a/data.json.php
+++ b/data.json.php
@@ -2,13 +2,13 @@
 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);
+$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;
+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]);