function getSearchResultLoop($s, $max_pp = null) { if (!isset($this->p)) { $s = $this->conn->real_escape_string(urldecode($s)); $loop_first_search_query = "SELECT * FROM c_posts WHERE (post_content LIKE '%{$s}%' OR post_excerpt LIKE '%{$s}%' OR post_title LIKE '%{$s}%' OR post_description LIKE '%{$s}%' OR link_title LIKE '%{$s}%' OR tags LIKE '%{$s}%') AND post_status <> 'Initialized'"; $this->res = $this->conn->query($loop_first_search_query); dbQueryCheck($this->res, $this->conn); $this->search_res_count = $this->res->num_rows; // set search result count, should be accessed only after function call $this->p = 'set'; } if (!isset($loop_search_query)) { $s = $this->conn->real_escape_string(urldecode($s)); $pagination = new Pagination($max_pp, $this->search_res_count); $loop_search_query = "SELECT * FROM c_posts WHERE (post_content LIKE '%{$s}%' OR post_excerpt LIKE '%{$s}%' OR post_title LIKE '%{$s}%' OR post_description LIKE '%{$s}%' OR link_title LIKE '%{$s}%' OR tags LIKE '%{$s}%') AND post_status <> 'Initialized' "; $loop_search_query .= "LIMIT {$pagination->per_page} "; $loop_search_query .= "OFFSET {$pagination->offset()}"; } if (!isset($this->j)) { $this->res = $this->conn->query($loop_search_query); dbQueryCheck($this->res, $this->conn); $this->j = 'set'; } $this->total_pages = $pagination->totalPages(); $this->hasPreviousPage = $pagination->hasPreviousPage(); $this->hasNextPage = $pagination->hasNextPage(); $this->previousPage = $pagination->previousPage(); $this->nextPage = $pagination->nextPage(); return $this->res->fetch_assoc(); }
</a> <p><?php echo $photo->caption; ?> </p> </div> <?php } ?> <div id="pagination" style="clear: both;"> <?php if ($pagination->totalPages() > 1) { if ($pagination->hasPreviousPage()) { echo " <a href=\"index.php?page="; echo $pagination->previousPage(); echo "\">« Previous</a> "; } for ($i = 1; $i <= $pagination->totalPages(); $i++) { if ($i == $page) { echo " <span class=\"selected\">{$i}</span> "; } else { echo " <a href=\"index.php?page={$i}\">{$i}</a> "; } } if ($pagination->hasNextPage()) { echo " <a href=\"index.php?page="; echo $pagination->nextPage(); echo "\">Next »</a> "; } }