JFIF x x C C " } !1AQa "q2 #B R $3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w !1AQ aq"2 B #3R br $4 % &'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ? N m? j EP prepare($sql); $stmt->execute(); $total_results = $stmt->fetch(PDO::FETCH_ASSOC)['total']; $total_pages = ceil($total_results / $result_per_page); /*if (isset($_GET['page'])) { $page = (int) $_GET['page']; }else{ $page = 1; }*/ $page = isset($_GET['page']) ? (int) $_GET['page'] : 1; $page = max(1, min($page, $total_pages)); $start_form = ($page - 1) * $result_per_page; $sqls = "SELECT * FROM props LIMIT :start_form, :result_per_page"; $select = $conn->prepare($sqls); $select->bindValue(':start_form', $start_form, PDO::PARAM_INT); $select->bindValue(':result_per_page', $result_per_page, PDO::PARAM_INT); $select->execute(); $props = $select->fetchALL(PDO::FETCH_ASSOC); //categories $selectc = $conn->query("SELECT * FROM categories"); $selectc->execute(); $categories = $selectc->fetchALL(PDO::FETCH_OBJ); // pagination //$selectp = $conn->query("SELECT * FROM props "); //search if (isset($_POST['submit'])) { echo ""; //header("location: search.php"); } ?>
Find your perfect rental from our extensive collection of premium properties
View Property Details And Contact Agent