StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POWhy at any search keyword all time appears pagination?
text
Body
copied!<p>I created pagination for my search page. Controller - </p> <pre><code>public function action_index() { if(!empty($_GET['search'])){ $pagination= Pagination::factory(array( 'total_items' => Model::factory('index')->get_count(), 'items_per_page' => 2, )); $this->template->content = View::factory('index/query') ->set('query', Model::factory('index')->get_articles_from_query($_GET['search'], $pagination->offset, $pagination->items_per_page)) ->set('pagination', $pagination->render()); } else{ $this->template->content = View::factory('index/error')->set('message', 'Nav rakstu ar šādu atslēgvārdu.'); } } </code></pre> <p>View -</p> <pre><code> <?php foreach ($query as $item): echo '<h2><a href="/article/' . $item['slug'] . '">' . $item['virsraksts'] . '</a></h2>'; echo '<p>' . nl2br($item['saturs']) . '</p>'; endforeach; endif; echo $pagination; ?> </code></pre> <p>Model - </p> <pre><code> public function get_articles_from_query($squery, $offset, $limit){ $query = DB::query(Database::SELECT, 'SELECT * FROM ieraksti WHERE virsraksts like :squery OR slug like :squery OR saturs like :squery ORDER By id DESC LIMIT :offset, :limit ') ->parameters(array(':squery' => "%$squery%", ':offset' => $offset, ':limit' => $limit))->execute()->as_array(); return $query; } </code></pre> <p>The pagination appears all time. I want to pagination, when articles found over 2. Where is the mistake? What is the mistake?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload