function readAll($page, $from_record_num, $records_per_page) { $query = "SELECT * FROM tbl_ut_user LIMIT {$from_record_num}, {$records_per_page}"; $stmt = $this->conn->prepare($query); $stmt->execute(); return $stmt; } } // page given in URL parameter, default page is one $page = isset($_GET['page']) ? $_GET['page'] : 1; // set number of records per page $records_per_page = 5; // calculate for the query LIMIT clause $from_record_num = $records_per_page * $page - $records_per_page; $pag = new Pagination(); $stmt = $pag->readAll($page, $from_record_num, $records_per_page); $num = $stmt->rowCount(); // display the products if there are any if ($num > 0) { echo "<table class='table table-hover table-responsive table-bordered'>"; echo "<tr>"; echo "<th>Product</th>"; echo "</tr>"; while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { extract($row); echo "<tr>"; echo "<td>{$name1}</td>"; echo "</tr>"; } echo "</table>"; // paging buttons will be here