php - Pagination - number of pages -

this pagination:

if (isset(filter_input_array(input_get)["page"])) {     $page= filter_input(input_get, 'page', filter_sanitize_special_chars); } else {     $page= 1; }  $request= "";  if (filter_input_array(input_post)) {     $request= filter_input(input_post, 'request', filter_sanitize_special_chars); } else if (isset(filter_input_array(input_get)["request"])) {     $request= filter_input(input_get, 'request', filter_sanitize_special_chars); } 

database:

$sql = db::getinstance()->query("select * users limit " . (($page* 50) - 50) . ",50"); 

index.php

<nav role="navigation">    <ul class="cd-pagination custom-buttons">        <li class="arrows"><a href="index.php?page=<?php          if ($page > 1) {            $prev= $page - 1;            echo escape($prev);          } else {            echo 1;          }?>&request=<?php echo escape($request) ?>">prev</a></li>           <li class="arrows">          <a href="index.php?page=<?php echo escape(++$page); ?>&request=          <?php echo escape($request) ?>">next</a></li>    </ul> </nav>  

it works fine this, show number of pages not prev/next. looked soulution on internet nothing worked...

query without limit:

select * users;

get number of rows query. can't see db class don't know implementation using. check out documentation num_rows

then need do: ceil($numrows / $numberofresultsperpage); number of pages.