{"id":663,"date":"2023-01-12T18:06:00","date_gmt":"2023-01-12T17:06:00","guid":{"rendered":"https:\/\/blog.pirulug.com\/?p=663"},"modified":"2026-07-14T17:40:28","modified_gmt":"2026-07-14T15:40:28","slug":"paginador-con-php","status":"publish","type":"post","link":"https:\/\/blog.pirulug.com\/?p=663","title":{"rendered":"Paginador con PHP"},"content":{"rendered":"<div class=\"separator\" style=\"clear: both;\">\n  <a\n    href=\"https:\/\/blog.pirulug.com\/wp-content\/uploads\/2023\/01\/unnamed.webp\"\n    style=\"display: block; padding: 1em 0; text-align: center; \"\n    ><img decoding=\"async\"\n      alt=\"\"\n      border=\"0\"\n      data-original-height=\"296\"\n      data-original-width=\"512\"\n      src=\"https:\/\/blog.pirulug.com\/wp-content\/uploads\/2023\/01\/unnamed.webp\"\n  \/><\/a>\n<\/div>\n<p>\n  Puedes crear un paginador de tablas en PHP utilizando la clase &quot;PDO&quot;<br \/>\n  para conectarte a tu base de datos y luego utilizar una combinaci\u00f3n de c\u00f3digo<br \/>\n  PHP y HTML para mostrar los datos en una tabla y agregar enlaces para navegar<br \/>\n  entre las p\u00e1ginas.\n<\/p>\n<p>\n  Aqu\u00ed hay un ejemplo de c\u00f3digo que muestra c\u00f3mo crear un paginador de tablas en<br \/>\n  PHP:\n<\/p>\n<pre><code class=\"language-php\">&lt;?php\n\/\/ Establecer la conexi\u00f3n a la base de datos\n$conn = new PDO(&quot;mysql:host=$servername;dbname=$dbname&quot;, $username, $password);\n\n\/\/ Establecer el n\u00famero de registros por p\u00e1gina\n$records_per_page = 5;\n\n\/\/ Obtener el n\u00famero total de registros\n$total_records = $conn-&gt;query(&quot;SELECT COUNT(*) FROM table_name&quot;)-&gt;fetchColumn();\n\n\/\/ Calcular el n\u00famero total de p\u00e1ginas\n$total_pages = ceil($total_records \/ $records_per_page);\n\n\/\/ Obtener la p\u00e1gina actual\nif (isset($_GET[&quot;page&quot;])) {\n    $page = $_GET[&quot;page&quot;];\n} else {\n    $page = 1;\n}\n\n\/\/ Calcular el registro inicial\n$start_from = ($page-1) * $records_per_page;\n\n\/\/ Obtener los registros de la tabla\n$stmt = $conn-&gt;prepare(&quot;SELECT * FROM table_name LIMIT :start_from, :records_per_page&quot;);\n$stmt-&gt;bindParam(&#039;:start_from&#039;, $start_from, PDO::PARAM_INT);\n$stmt-&gt;bindParam(&#039;:records_per_page&#039;, $records_per_page, PDO::PARAM_INT);\n$stmt-&gt;execute();\n$results = $stmt-&gt;fetchAll();\n\n\/\/ Mostrar los registros en una tabla HTML\necho &quot;&lt;table&gt;&quot;;\nforeach ($results as $row) {\n    echo &quot;&lt;tr&gt;&quot;;\n    echo &quot;&lt;td&gt;&quot; . $row[&#039;column1&#039;] . &quot;&lt;\/td&gt;&quot;;\n    echo &quot;&lt;td&gt;&quot; . $row[&#039;column2&#039;] . &quot;&lt;\/td&gt;&quot;;\n    echo &quot;&lt;td&gt;&quot; . $row[&#039;column3&#039;] . &quot;&lt;\/td&gt;&quot;;\n    echo &quot;&lt;\/tr&gt;&quot;;\n}\necho &quot;&lt;\/table&gt;&quot;;\n\n\/\/ Mostrar enlaces para navegar entre las p\u00e1ginas\necho &quot;&lt;div class=&#039;pagination&#039;&gt;&quot;;\nfor ($i=1; $i&lt;=$total_pages; $i++) {\n    echo &quot;&lt;a href=&#039;pagination.php?page=&quot;.$i.&quot;&#039;&gt;&quot;.$i.&quot;&lt;\/a&gt;&quot;;\n}\necho &quot;&lt;\/div&gt;&quot;;\n?&gt;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Puedes crear un paginador de tablas en PHP utilizando la clase &quot;PDO&quot; para conectarte a tu base de datos y luego utilizar una combinaci\u00f3n de c\u00f3digo PHP y HTML para mostrar los datos en una tabla y agregar enlaces para navegar entre las p\u00e1ginas. Aqu\u00ed hay un ejemplo de c\u00f3digo que muestra c\u00f3mo crear un [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[108],"class_list":["post-663","post","type-post","status-publish","format-standard","hentry","category-sin-categoria","tag-php"],"_links":{"self":[{"href":"https:\/\/blog.pirulug.com\/index.php?rest_route=\/wp\/v2\/posts\/663","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.pirulug.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.pirulug.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.pirulug.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.pirulug.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=663"}],"version-history":[{"count":1,"href":"https:\/\/blog.pirulug.com\/index.php?rest_route=\/wp\/v2\/posts\/663\/revisions"}],"predecessor-version":[{"id":665,"href":"https:\/\/blog.pirulug.com\/index.php?rest_route=\/wp\/v2\/posts\/663\/revisions\/665"}],"wp:attachment":[{"href":"https:\/\/blog.pirulug.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.pirulug.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.pirulug.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}