How to Implement Simple Database Pagination in PHP?-Mysql Tutorial-php.cn

Home

Database

How to Implement Simple Database Pagination in PHP?

Jan 21, 2025 pm 07:07 PM

&lt;?php
// Database connection (replace with your credentials)
$host = 'localhost';
$dbname = 'your_database';
$user = 'your_user';
$password = 'your_password';

try {
    $dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $password);
    $dbh-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    die("Database connection failed: " . $e-&gt;getMessage());
}


// Get total number of records
$stmt = $dbh-&gt;query('SELECT COUNT(*) FROM your_table');
$totalRecords = $stmt-&gt;fetchColumn();


// Pagination settings
$recordsPerPage = 20;
$totalPages = ceil($totalRecords / $recordsPerPage);
$currentPage = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$currentPage = max(1, min($currentPage, $totalPages)); // Ensure page number is within valid range

$offset = ($currentPage - 1) * $recordsPerPage;


// Fetch data for current page
$stmt = $dbh-&gt;prepare("SELECT * FROM your_table LIMIT :limit OFFSET :offset");
$stmt-&gt;bindParam(':limit', $recordsPerPage, PDO::PARAM_INT);
$stmt-&gt;bindParam(':offset', $offset, PDO::PARAM_INT);
$stmt-&gt;execute();
$data = $stmt-&gt;fetchAll(PDO::FETCH_ASSOC);


// Display data
echo "&lt;h2&gt;Data (Page " . $currentPage . " of " . $totalPages . ")&lt;/h2&gt;";
if ($data) {
    echo "&lt;ul&gt;";
    foreach ($data as $row) {
        echo "&lt;li&gt;" . implode(", ", $row) . "&lt;/li&gt;"; // Adjust as needed for your table structure
    }
    echo "&lt;/ul&gt;";
} else {
    echo "&lt;p&gt;No data found for this page.&lt;/p&gt;";
}



// Display pagination links
echo "&lt;div class='pagination'&gt;";
for ($i = 1; $i &lt;= $totalPages; $i++) {
    $activeClass = ($i == $currentPage) ? 'active' : '';
    echo "&lt;a href='?page=" . $i . "' class='" . $activeClass . "'&gt;" . $i . "&lt;/a&gt;";
}
echo "&lt;/div&gt;";


?&gt;

&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;head&gt;
&lt;title&gt;Simple Pagination&lt;/title&gt;
&lt;style&gt;
.pagination a {
    display: inline-block;
    padding: 8px 12px;
    margin: 0 4px;
    text-decoration: none;
    border: 1px solid #ccc;
}

.pagination a.active {
    background-color: #4CAF50;
    color: white;
}
&lt;/style&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;/body&gt;
&lt;/html&gt;

Copy after login

How to Implement Simple Database Pagination in PHP?

This improved example includes:

Error Handling: A try-catch block handles potential database connection errors.
Prepared Statements: Uses prepared statements to prevent SQL injection vulnerabilities. This is crucial for security.
Input Validation: While the original example used filter_input, it lacked comprehensive validation. This version ensures the page number is a positive integer and within the valid range.
Clearer Data Display: The data is displayed in a more user-friendly format (an unordered list). You'll need to adapt the implode part to match your database table's column names.
Complete HTML: Provides a complete HTML structure for better rendering.
CSS Styling: Basic CSS is included to style the pagination links.
Placeholder Values: Remember to replace "your_database", "your_user", "your_password", and "your_table" with your actual database credentials and table name.

Remember to create the necessary database and table before running this code. This enhanced example provides a more robust and secure solution for pagination in PHP.

The above is the detailed content of How to Implement Simple Database Pagination in PHP?. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn