How can PHP PDO and pagination techniques be utilized to improve the readability and maintainability of code?

Issue: Using PHP PDO and pagination techniques can improve the readability and maintainability of code by separating database logic from presentation logic and allowing for easier navigation through large datasets. Code snippet: 

// Establish a PDO connection
$pdo = new PDO('mysql:host=localhost;dbname=database', 'username', 'password');

// Set up pagination variables
$limit = 10;
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$offset = ($page - 1) * $limit;

// Prepare and execute a query using PDO
$stmt = $pdo->prepare("SELECT * FROM table LIMIT :limit OFFSET :offset");
$stmt->bindParam(':limit', $limit, PDO::PARAM_INT);
$stmt->bindParam(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();

// Fetch and display results
while ($row = $stmt->fetch()) {
    echo $row['column1'] . ' - ' . $row['column2'] . '<br>';
}

// Generate pagination links
$total_records = $pdo->query("SELECT COUNT(*) FROM table")->fetchColumn();
$total_pages = ceil($total_records / $limit);

for ($i = 1; $i <= $total_pages; $i++) {
    echo '<a href="?page=' . $i . '">' . $i . '</a> ';
}

Keywords

PHP PDO pagination readability maintainability

Related Questions