Member Avatar for rjusman90

please help me out by giving a very easy code

  • 5 Contributors
  • 4 Replies
  • 260 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Jack_9

Dani AI

Generated

Original request from asked for a very simple pagination snippet. The tutorial links shared by and are useful for background; below is a minimal, safe PDO example that shows the core steps: sanitize the page number, compute an offset, fetch a page with LIMIT/OFFSET, and render simple Prev/Next + numeric links. As noted, PHP + MySQL is a common, appropriate pairing for this.

<?php
// minimal PDO pagination example — adjust DSN / credentials / table name
$pdo = new PDO('mysql:host=localhost;dbname=database;charset=utf8mb4','dbuser','dbpass',[
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
]);

$perPage = 10;
$page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
if ($page < 1) $page = 1;
$offset = ($page - 1) * $perPage;

// total rows -> total pages
$total = (int) $pdo->query('SELECT COUNT(*) FROM items')->fetchColumn();
$totalPages = max(1, (int) ceil($total / $perPage));

// fetch page
$stmt = $pdo->prepare('SELECT id, title FROM items ORDER BY id DESC LIMIT :limit OFFSET :offset');
$stmt->bindValue(':limit', $perPage, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

// output (escape HTML)
foreach ($rows as $r) {
    echo '<div>' . htmlspecialchars($r['title'], ENT_QUOTES, 'UTF-8') . '</div>';
}

// pager
if ($page > 1) echo '<a href="?page='.($page-1).'">&laquo; Prev</a> ';
for ($i = 1; $i <= $totalPages; $i++) {
    echo $i === $page ? " <strong>$i</strong> " : ' <a href="?page='.$i.'">'.$i.'</a> ';
}
if ($page < $totalPages) echo ' <a href="?page='.($page+1).'">Next &raquo;</a>';
?>

Notes and caveats: always cast/validate the page parameter and escape output with htmlspecialchars. Bind LIMIT/OFFSET as integers (PDO::PARAM_INT). For very large tables OFFSET pagination gets slow—consider keyset (cursor) pagination using a WHERE on an indexed column (e.g., WHERE id < :last_id ORDER BY id DESC LIMIT :perPage) for better performance. Finally, as suggested, reading a short tutorial helps solidify concepts; the two links above provide longer explanations and variations (AJAX, URL-preserving pagers, Bootstrap styling).

Recommended Answers

All 4 Replies

Member Avatar for malatamil


its easy to understand this will help you

Member Avatar for Jack_9

I'm confused with this question.I dont think that it is very good. But however in my experience with web development, If you want to make a solid Website running a good database php and MySql is the way to go.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.