Jab aapki website par hazaron products ya posts hote hain, toh aap unhe ek sath ek hi page par nahi dikhate. Agar aisa karenge toh website bohot slow ho jayegi. Iske liye hum Pagination (Page 1, Page 2, Page 3...) ka use karte hain.

SQL mein pagination banane ke liye do sabse zaroori keywords hain: LIMIT aur OFFSET.

Chaliye inko pure HTML, PHP code aur calculation ke sath asan Hindi mein samajhte hain.

1. LIMIT (Ek page par kitna data dikhana hai)

LIMIT database ko batata hai ki use ek baar mein maximum kitne rows (records) nikal kar dene hain.

• Syntax: SELECT * FROM table_name LIMIT 10; (Yeh sirf pehle 10 records laakar dega).

2. OFFSET / SKIP (Purana data skip karne ke liye)

OFFSET database ko batata hai ki shuruaat ke kitne records ko chhodkar (skip karke) aage se data ginna shuru karna hai.

• Syntax: SELECT * FROM table_name LIMIT 10 OFFSET 20; (Yeh shuru ke 20 records ko chhod dega, aur uske baad ke agle 10 records laakar dega).

Pagination Ka Formula (Asli Logic)

Maan lijiye hum ek page par 10 items ($limit = 10) dikhana chahte hain:

• Page 1: Hum chahte hain record 1 se 10 tak dikhe (Matlab 0 skip karna hai).

  LIMIT 10 OFFSET 0

• Page 2: Hum chahte hain shuru ke 10 records skip ho jayein aur 11 se 20 tak dikhe.

  LIMIT 10 OFFSET 10

• Page 3: Hum chahte hain shuru ke 20 records skip ho jayein aur 21 se 30 tak dikhe.

  LIMIT 10 OFFSET 20

PHP mein iska formula hota hai: Offset = (Page_Number - 1) * Limit

HTML aur PHP Code Example

HTML (Pagination Links/Buttons):

Yeh wo buttons hain jo aapko website ke neeche dikhte hain (1, 2, 3...).

HTML

<div class="pagination">
    <a href="index.php?page=1">1</a>
    <a href="index.php?page=2">2</a>
    <a href="index.php?page=3">3</a>
</div>

PHP Backend Code (index.php):

PHP

<?php
include("dbconnection.php");

// 1. Ek page par kitna data dikhana hai (Limit)
$limit = 10; 

// 2. Check karna ki user kis page par hai, agar kuch nahi select toh Default Page = 1
$page = isset($_GET['page']) ? $_GET['page'] : 1;

// 3. Formula lagakar Offset/Skip nikalna
$offset = ($page - 1) * $limit;

// 4. SQL Query lagana LIMIT aur OFFSET ke sath
$query = "SELECT * FROM Products LIMIT $limit OFFSET $offset";
$result = mysqli_query($con, $query);

// Data ko HTML table ya cards me show karne ke liye loop
while($row = mysqli_fetch_array($result)) {
    echo "<p>" . $row['name'] . " - ₹" . $row['price'] . "</p>";
}
?>

Quick Revision Table (10 Items Per Page Ke Hisab Se)

Page Number	LIMIT (Kitna data chahiye)	OFFSET (Kitna skip karna hai)	SQL Query Ka Roop
Page 1	10	0	LIMIT 10 OFFSET 0
Page 2	10	10	LIMIT 10 OFFSET 10
Page 3	10	20	LIMIT 10 OFFSET 20

💡 Tip: Kuch databases ya frameworks mein OFFSET ki jagah LIMIT 10, 20 likha jata hai, jahan pehla number (10) offset hota hai aur doosra number (20) limit hota hai. Dono ka kaam bilkul same hai.

Kya aap yeh seekhna chahte hain ki total pages ki ginti (Total Pages = Total Records / Limit) database se automatic kaise calculate ki jaati hai?

=====================================================================

Go TO one Page php1   >    

What is CRUD? Basic Database Operations Explained for Beginners php 1

Go TO one Page php2  >

SQL Filters & Conditions Tutorial: WHERE, AND, OR, IN, BETWEEN Explained php 2

Go TO one Page php3  >

SQL Search & Sorting Guide: Learn LIKE, ORDER BY, ASC, & DESC Easily php 3

Go TO one Page php4  >

SQL Pagination Tutorial: Master LIMIT and OFFSET (SKIP) in Databases php4

Go TO one Page php5  >

SQL Calculations & Groups Guide: Learn COUNT, SUM, AVG, GROUP BY & HAVING php 5

Go TO one Page php6  >

SQL Tables Linking Tutorial: JOIN vs UNION Differences Explained Easily php 6