{"id":233030,"date":"2023-02-02T15:59:00","date_gmt":"2023-02-02T12:59:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=233030"},"modified":"2022-11-10T18:50:16","modified_gmt":"2022-11-10T15:50:16","slug":"comment-creer-une-page-wordpress-qui-affiche-les-statistiques-des-commentaires","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/fr\/comment-creer-une-page-wordpress-qui-affiche-les-statistiques-des-commentaires\/","title":{"rendered":"Comment cr\u00e9er une page WordPress qui affiche les statistiques des commentaires ?"},"content":{"rendered":"

WordPress est bas\u00e9 sur PHP et MySQL. Il est donc tr\u00e8s flexible et puissant. Cet article vous expliquera comment cr\u00e9er une page qui affiche les statistiques des commentaires de votre blog. Par exemple, un tableau \u00e0 deux colonnes, l’auteur et le nombre de ses commentaires.<\/p>\n

Afin d’activer le code PHP, vous devrez installer un plugin qui vous permet d’inclure du code PHP dans vos publications\/pages. Ma recommandation est de rechercher [Simple Inclure HTML et PHP] dans votre panneau de contr\u00f4le wordpress.<\/p>\n

Ensuite, vous devez cr\u00e9er une page contenant au moins les \u00e9l\u00e9ments suivants (marqu\u00e9s en rouge).<\/p>\n

\"Comment<\/a><\/p>\n

Plugin WordPress pour afficher les statistiques des commentaires<\/p>\n

Ensuite, allez dans votre dossier du th\u00e8me et cr\u00e9ez un fichier nomm\u00e9 cmt.php<\/strong> et d\u00e9finissez le mode d’acc\u00e8s au fichier sur 644 (ou au moins lisible).<\/p>\n

Le code PHP \u00e0 renseigner dans le fichier est :<\/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
En cliquant sur [Auteur], vous acc\u00e9dez \u00e0 l’URL fournie (dans une nouvelle fen\u00eatre) et en cliquant sur [Le nombre de commentaires], vous acc\u00e9dez \u00e0 leur dernier commentaire. Le format de l’URL devra peut-\u00eatre \u00eatre ajust\u00e9 s’il n’est pas le format standard [\/archives\/post_id].<\/p>\n
La page d’exemple peut \u00eatre consult\u00e9e ici\u00a0: https:\/\/justyy.com\/commentator<\/a> (en chinois).<\/p>\n
La fonction PHP mysql_real_escape_string()<\/strong> est d\u00e9pr\u00e9ci\u00e9e mais vous pouvez toujours utiliser esc_sql<\/strong> ou $wpdb->prepare()<\/strong> pour \u00e9chapper les cha\u00eenes (contenant des guillemets simples ou doubles) pour SQL\/base de donn\u00e9es.<\/p>\n
Source d’enregistrement:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Comment cr\u00e9er une page WordPress qui affiche les statistiques des commentaires ?<\/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":[893,717,832,801,841,862],"tags":[1167],"class_list":["post-233030","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-code-2","category-developpeur","category-guide-pour-les-debutants","category-php-3","category-tutoriels","category-wordpress-3","tag-affiai-fr"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/posts\/233030","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/comments?post=233030"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/posts\/233030\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/media\/224768"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/media?parent=233030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/categories?post=233030"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/tags?post=233030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}