<?php
// Include your database connection file here
include "admin/config.php";

if (isset($_GET['offset']) && is_numeric($_GET['offset'])) {
    $offset = $_GET['offset'];

    $sqlloc = "SELECT * FROM `tbl_location` LIMIT $offset, 8";
    $runloc = mysqli_query($db, $sqlloc) or die("Query Not run");

    $locations = array();
    $sqll = "SELECT * FROM `tbl_seo` WHERE se_id=1";
    $runl = mysqli_query($db,$sqll) or die("Query Not run");
    $datal = mysqli_fetch_assoc($runl);
    $wspath=$datal['site_path'];
    while ($dataloc = mysqli_fetch_assoc($runloc)) {
        $location = array(
            'wspath' => $wspath,
            'loc_slug' => $dataloc['loc_slug'],
            'loc_name' => $dataloc['loc_name']
        );
        $locations[] = $location;
    }

    echo json_encode($locations);
} else {
    echo "Invalid offset";
}
?>