Veel data opsplitsen in pagina's?

$records_per_page = 10;
$page = (int)$_GET['page']; //0-based, dus 0 = pagina 1, enz
$offset = $page * $records_per_page;
$sql = "select * from tabel limit $offset,$records_per_page";
//en die dan weergeven

Ah, je was me al iets voor.
Ik had dit gevonden.:

                       include 'database.php';
                       $results_per_page = 20; // number of results per page
                       $pdo = Database::connect();

                       if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };
                       $start_from = ($page-1) * $results_per_page;

                       $sql = "SELECT * FROM metingen ORDER BY Id DESC LIMIT $start_from, ".$results_per_page;
                        foreach ($pdo->query($sql) as $row) {
                            echo '<tr>';
                            echo '<td>'. $row['Id'] . '</td>';
                            enz.....

Maar nu komt het, onder die 20 weergaves zouden de pagina's moeten komen.
Zij hebben dit als code.:

$sql = "SELECT COUNT(ID) AS total FROM metingen";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$total_pages = ceil($row["total"] / $results_per_page); // calculate total pages with results

for ($i=1; $i<=$total_pages; $i++) {  // print links for all pages
            echo "<a href='index_metingen.php?page=".$i."'";
            if ($i==$page)  echo " class='curPage'";
            echo ">".$i."</a> ";
};

Alleen dat stukje laat geen pagina's zien, ga er dan ook vanuit omdat het niet via pdo loopt, maar hoe dan wel?

update

reeds zelf gevonden door een beetje puzzelen en dit is nu werkend.

$sql = "SELECT COUNT(Id) AS total FROM metingen";
  $q = $pdo->prepare($sql);
        $q->execute(array($Id));
        $data = $q->fetch(PDO::FETCH_ASSOC);
$total_pages = ceil($data["total"] / $results_per_page); // calculate total pages with results

for ($i=1; $i<=$total_pages; $i++) {  // print links for all pages
            echo "<a href='index_metingen.php?page=".$i."'";
            if ($i==$page)  echo " class='curPage'";
            echo ">".$i."</a> ";
};

Wat je zoekt heet pagination.