Here is complete code for pagination.<\/p>\r\n
<\/p>\r\n
<style>\r\n.pagination a, .pagination span {\r\n color: black;\r\n float: left;\r\n padding: 8px 16px;\r\n text-decoration: none;\r\n transition: background-color .3s;\r\n border: 1px solid #ddd;\r\n}\r\n\r\n.pagination a.active {\r\n background-color: #4CAF50;\r\n color: white;\r\n border: 1px solid #4CAF50;\r\n}\r\n\r\n.pagination a:hover:not(.active) {background-color: #ddd;}\r\n\r\n<\/style>\r\n<?php\r\n\/\/ Pagination configuration\r\n$servername = \"localhost\";\r\n$username = \"root\";\r\n$password = \"\";\r\n$db=\"sp_ypages\";\r\ntry {\r\n $conn = new PDO(\"mysql:host=$servername;dbname=$db\", $username, $password);\r\n $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\r\n}\r\ncatch(PDOException $e) {\r\n echo \"Connection failed: \" . $e->getMessage();\r\n}\r\n\r\n$recordsPerPage = 10; \/\/ Number of records to display per page\r\n$page = isset($_GET['page']) ? $_GET['page'] : 1; \/\/ Current page number\r\n\r\n\/\/ Calculate the offset for the SQL query\r\n$offset = ($page - 1) * $recordsPerPage;\r\n\r\n\/\/ Query to retrieve data with pagination\r\n$sql = \"SELECT * FROM businesses LIMIT :limit OFFSET :offset\";\r\n$stmt = $conn->prepare($sql);\r\n$stmt->bindValue(':limit', $recordsPerPage, PDO::PARAM_INT);\r\n$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);\r\n$stmt->execute();\r\n$result = $stmt->fetchAll(PDO::FETCH_ASSOC);\r\n\r\n\/\/ Query to count the total number of records\r\n$countSql = \"SELECT COUNT(*) AS count FROM businesses\";\r\n$countStmt = $conn->query($countSql);\r\n$totalRecords = $countStmt->fetch(PDO::FETCH_ASSOC)['count'];\r\n\r\n\/\/ Calculate the total number of pages\r\n$totalPages = ceil($totalRecords \/ $recordsPerPage);\r\n\r\n?>\r\n<!-- Display the HTML table with pagination -->\r\n<table style=\"font-family: cursive;\">\r\n <thead>\r\n <tr>\r\n <th>Name<\/th>\r\n <th>City<\/th>\r\n <\/tr>\r\n <\/thead>\r\n <tbody>\r\n <?php foreach ($result as $key => $val) { ?>\r\n <tr>\r\n <td><?php echo $val['name'];?><\/td>\r\n <td><?php echo $val['city'];?><\/td>\r\n <\/tr>\r\n <?php } ?>\r\n <\/tbody>\r\n<\/table>\r\n\r\n<!-- Display the pagination links -->\r\n<div class=\"pagination\">\r\n <?php\r\n $maxPagesToShow = 10; \/\/ Maximum number of pages to display in the pagination\r\n\r\n \/\/ Previous page link\r\n if ($page > 1) {\r\n echo '<a href=\"?page='.($page - 1).'\">Previous<\/a>';\r\n }\r\n if ($page > 1) {\r\n echo '<a href=\"?page=1\">1<\/a>';\r\n }\r\n\r\n \/\/ Page links\r\n $startPage = max(1, $page - floor($maxPagesToShow \/ 2));\r\n $endPage = min($startPage + $maxPagesToShow - 1, $totalPages);\r\n\r\n for ($i = $startPage; $i <= $endPage; $i++) {\r\n if ($i == $page) {\r\n echo '<span class=\"current\">'.$i.'<\/span>';\r\n } else {\r\n echo '<a href=\"?page='.$i.'\">'.$i.'<\/a>';\r\n }\r\n }\r\n\r\n \/\/ Ellipsis if there are more pages\r\n if ($endPage < $totalPages) {\r\n echo '<span class=\"ellipsis\">...<\/span>';\r\n echo '<a href=\"?page='.$totalPages.'\">'.$totalPages.'<\/a>';\r\n }\r\n\r\n \/\/ Next page link\r\n if ($page < $totalPages) {\r\n echo '<a href=\"?page='.($page + 1).'\">Next<\/a>';\r\n }\r\n ?>\r\n<\/div>\r\n<\/code><\/pre>","category_id":"1","is_private":"0","created_at":"2023-06-06T04:50:23.000000Z","updated_at":"2023-06-06T04:50:23.000000Z","category":{"id":1,"user_id":"1","name":"PHP","slug":"php-3ius","parent_id":null,"created_at":"2023-03-14T03:58:19.000000Z","updated_at":"2023-03-14T03:58:19.000000Z"},"user":{"id":1,"name":"R GONDAL","email":"rizikmw@gmail.com","email_verified_at":null,"two_factor_confirmed_at":null,"current_team_id":"1","profile_photo_path":null,"created_at":"2023-03-12T10:49:33.000000Z","updated_at":"2025-01-10T12:59:00.000000Z","profile_photo_url":"https:\/\/ui-avatars.com\/api\/?name=R+G&color=7F9CF5&background=EBF4FF"}},"pageDesc":"Here is complete code for pagination. <style> .pagination a, .pagination span { color: black; float: left; padding: 8px 16px; - Custom pagination in PHP using PDO (Updated: June 6, 2023) - Read more about Custom pagination in PHP using PDO at my programming site [SITE]","categories":[]}