{"id":232973,"date":"2023-02-02T15:45:00","date_gmt":"2023-02-02T12:45:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232973"},"modified":"2022-11-10T18:35:27","modified_gmt":"2022-11-10T15:35:27","slug":"como-crear-una-pagina-de-wordpress-que-muestre-estadisticas-de-comentarios","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/es\/como-crear-una-pagina-de-wordpress-que-muestre-estadisticas-de-comentarios\/","title":{"rendered":"\u00bfC\u00f3mo crear una p\u00e1gina de WordPress que muestre estad\u00edsticas de comentarios?"},"content":{"rendered":"

WordPress est\u00e1 basado en PHP y MySQL. Por lo tanto, es muy flexible y potente. Este art\u00edculo lo guiar\u00e1 sobre c\u00f3mo crear una p\u00e1gina que muestre las estad\u00edsticas de comentarios para su blog. Por ejemplo, una tabla con dos columnas, el autor y el n\u00famero de sus comentarios.<\/p>\n

Para habilitar el c\u00f3digo PHP, deber\u00e1 instalar un complemento que le permita incluir c\u00f3digo PHP en sus publicaciones\/p\u00e1ginas. Mi recomendaci\u00f3n es buscar [Simple Incluir HTML y PHP] en \u200b\u200bsu panel de control de wordpress.<\/p>\n

Luego, debe crear una p\u00e1gina que tenga al menos lo siguiente (marcado en rojo).<\/p>\n

\"\u00bfC\u00f3mo<\/a><\/p>\n

Complemento de WordPress para mostrar estad\u00edsticas de comentarios<\/p>\n

Luego vaya a su carpeta del tema y cree un archivo que se llame cmt.php<\/strong> y establezca el modo de acceso al archivo en 644 (o al menos legible).<\/p>\n

El c\u00f3digo PHP para llenar el archivo es:<\/p>\n

<?php\n\/\/<a class=\"vglnk\" target=\"_blank\" href=\"https:\/\/helloacm.com\" rel=\"nofollow\"><span>https<\/span><span>:\/\/<\/span><span>helloacm<\/span><span>.<\/span><span>com<\/span><\/a>\n\u00a0 global $wpdb;\n\u00a0 $query = \"\n \u00a0 \u00a0select \n \u00a0 \u00a0 \u00a0`comment_author`, \n \u00a0 \u00a0 \u00a0`comment_author_url`,\n \u00a0 \u00a0 \u00a0count(1) as `cnt` \n \u00a0 \u00a0from\n \u00a0 \u00a0 \u00a0`wp_comments`\n \u00a0 \u00a0where\n \u00a0 \u00a0 \u00a0`comment_approved` = 1 \u00a0 \u00a0 \u00a0\n \u00a0 \u00a0group by \n \u00a0 \u00a0 \u00a0`comment_author`\n \u00a0 \u00a0order by\n \u00a0 \u00a0 \u00a0`cnt` desc\n \u00a0 \u00a0limit 10 \n \u00a0\";\n\u00a0 \n\u00a0 $result = $wpdb->get_results($query);\n\u00a0 if ($result) {\n\u00a0 \u00a0 echo \"<table width='100%' style='border:0'>\";\n\u00a0 \u00a0 echo \"<tr><b><td>Author<\/td><td>The Number of Comments<\/td><\/b><\/tr>\";\n\u00a0 \u00a0 foreach ($result as $author) {\n\u00a0 \u00a0 \u00a0 echo \"<tr>\";\n\u00a0 \u00a0 \u00a0 $a = esc_sql($author->comment_author);\n\u00a0 \u00a0 \u00a0 $query = \"\n \u00a0 \u00a0 \u00a0 \u00a0select \n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0`comment_post_id`,\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0`comment_id`\n \u00a0 \u00a0 \u00a0 \u00a0from\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0`wp_comments`\n \u00a0 \u00a0 \u00a0 \u00a0where\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0`comment_approved` = 1 and\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0`comment_author` = '$a'\n \u00a0 \u00a0 \u00a0 \u00a0order by\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0`comment_date` desc\n \u00a0 \u00a0 \u00a0 \u00a0limit 1 \u00a0 \u00a0 \u00a0\n \u00a0 \u00a0 \u00a0\";\n\u00a0 \u00a0 \u00a0 $latest = $wpdb->get_row($query);\n\u00a0 \u00a0 \u00a0 echo \"<td><a href='$author->comment_author_url' target='_blank' title='$author->comment_author'>\".$author->comment_author.\"<\/a><\/td>\";\n\u00a0 \u00a0 \u00a0 echo \"<td><a title='$author->comment_author' href='\/archives\/$latest->comment_post_id\/#comment-$latest->comment_id'>\".$author->cnt.\"<\/a><\/td>\"; \u00a0 \u00a0 \u00a0\n\u00a0 \u00a0 \u00a0 echo \"<\/tr>\";\n\u00a0 \u00a0 }\n\u00a0 \u00a0 echo \"<\/table>\";\n\u00a0 } \n?><\/code><\/pre>\n
Al hacer clic en [Autor] se navegar\u00e1 a la URL provista (en una nueva ventana), y al hacer clic en [El n\u00famero de comentarios] se acceder\u00e1 a su \u00faltimo comentario. Es posible que sea necesario ajustar el formato de URL si no es el est\u00e1ndar [\/archives\/post_id].<\/p>\n
La p\u00e1gina de ejemplo se puede ver aqu\u00ed: https:\/\/justyy.com\/commentator<\/a> (en chino).<\/p>\n
La funci\u00f3n de PHP mysql_real_escape_string()<\/strong> est\u00e1 obsoleta pero a\u00fan puede usar esc_sql<\/strong> o $wpdb->prepare()<\/strong> para escapar cadenas (que contienen comillas simples o dobles) para SQL\/base de datos.<\/p>\n
Fuente de grabaci\u00f3n:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
\u00bfC\u00f3mo crear una p\u00e1gina de WordPress que muestre estad\u00edsticas de comentarios?<\/p>\n","protected":false},"author":1,"featured_media":224768,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[892,716,831,800,840,861],"tags":[1172],"class_list":["post-232973","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-codigo","category-desarrollador","category-guia-para-principiantes","category-php-2","category-tutoriales","category-wordpress-2","tag-affiai-es"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/posts\/232973","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/comments?post=232973"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/posts\/232973\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/media\/224768"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/media?parent=232973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/categories?post=232973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/tags?post=232973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}