{"id":233027,"date":"2023-02-02T11:59:00","date_gmt":"2023-02-02T08:59:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=233027"},"modified":"2023-02-02T11:59:45","modified_gmt":"2023-02-02T08:59:45","slug":"comment-creer-une-page-wordpress-pour-lister-tous-les-commentaires","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/fr\/comment-creer-une-page-wordpress-pour-lister-tous-les-commentaires\/","title":{"rendered":"Comment cr\u00e9er une page WordPress pour lister tous les commentaires ?"},"content":{"rendered":"

J’ai cr\u00e9\u00e9 cette page<\/a> et cette page<\/a> et cette page<\/a> pour afficher tous les commentaires page par page. Pour que vous puissiez garder une trace de tous les commentaires post\u00e9s tri\u00e9s par chronologie (le plus r\u00e9cent en premier).<\/p>\n

Tout d’abord, vous devrez cr\u00e9er une page et mettre le contenu suivant (qui permet d’inclure un fichier source PHP dans une page\/poste wordpress)\u00a0:<\/p>\n

[ include ]list-of-comments.php[\/ include ]<\/code><\/pre>\n
Cr\u00e9ez ensuite un PHP<\/a> contenant le code source suivant\u00a0:<\/p>\n
<php\n\/\/ Author: <a class=\"vglnk\" target=\"_blank\" href=\"https:\/\/helloacm.com\/how-to-create-a-wordpress-page-to-list-all-comments\/\" rel=\"nofollow\"><span>https<\/span><span>:\/\/<\/span><span>helloacm<\/span><span>.<\/span><span>com<\/span><span>\/<\/span><span>how<\/span><span>-<\/span><span>to<\/span><span>-<\/span><span>create<\/span><span>-<\/span><span>a<\/span><span>-<\/span><span>wordpress<\/span><span>-<\/span><span>page<\/span><span>-<\/span><span>to<\/span><span>-<\/span><span>list<\/span><span>-<\/span><span>all<\/span><span>-<\/span><span>comments<\/span><span>\/<\/span><\/a>\n\u00a0 global $wpdb;\n\u00a0 \n\u00a0 $query = \"\n \u00a0 \u00a0select \n \u00a0 \u00a0 \u00a0 \u00a0count(1) \n \u00a0 \u00a0from \n \u00a0 \u00a0 \u00a0 \u00a0`wp_comments`,`wp_posts` \n \u00a0 \u00a0where \n \u00a0 \u00a0 \u00a0 \u00a0`wp_comments`.`comment_approved` = 1 and \n \u00a0 \u00a0 \u00a0 \u00a0`wp_comments`.`comment_post_ID` = `wp_posts`.`ID` and \n \u00a0 \u00a0 \u00a0 \u00a0`wp_posts`.`post_status` = 'publish'\n \u00a0\";\n\u00a0 $total = $wpdb->get_var($query);\n\u00a0 \n\u00a0 $per = 25; \/\/ default comments per page\n\u00a0 $page = get_query_var('page');\n\u00a0 if (!$page) {\n\u00a0 \u00a0 $page = 1;\n\u00a0 }\n\u00a0 \n\u00a0 $totalpages = ceil($total \/ $per);\n\u00a0 if ($page > $totalpages) {\n\u00a0 \u00a0 $page = 1;\n\u00a0 }\n\u00a0 \n\u00a0 $lowerbound = ($page - 1) * $per;\n\u00a0 $upperbound = $lowerbound + $per;\n\u00a0 $lmt=\" limit \". $lowerbound. \",\". $per;\n\u00a0 \n\u00a0 $query = \"select \n \u00a0 \u00a0`comment_post_ID`,\n \u00a0 \u00a0`comment_author`,\n \u00a0 \u00a0`comment_author_email`,\n \u00a0 \u00a0`comment_author_url`,\n \u00a0 \u00a0`comment_date_gmt`,\n \u00a0 \u00a0`comment_content`,\n \u00a0 \u00a0`post_title`,\n \u00a0 \u00a0`post_name` \u00a0\n \u00a0 from \n \u00a0 \u00a0`wp_comments`,`wp_posts` \n \u00a0 where \n \u00a0 \u00a0`wp_comments`.`comment_approved` = 1 and \n \u00a0 \u00a0`wp_comments`.`comment_post_ID` = `wp_posts`.`ID` and \n \u00a0 \u00a0`wp_posts`.`post_status` = 'publish' \n \u00a0 order by \n \u00a0 \u00a0`comment_ID` desc $lmt\";\n\u00a0 \n\u00a0 $result = $wpdb->get_results($query);\n\u00a0 \n\u00a0 echo \"Total <B>$total<\/B> Comments ($page\/$totalpages Pages) - \"; \u00a0\n\u00a0 if ($page > 1) {\n\u00a0 \u00a0 echo \"<a href='?page=\".($page-1).\"'>Newer Comments<\/a> - \";\n\u00a0 }\n\u00a0 if ($page < $totalpages) {\n\u00a0 \u00a0 echo \"<a href='?page=\".($page+1).\"'>Older Comments<\/a>\";\n\u00a0 }\n\u00a0 \n\u00a0 echo \"<BR\/><BR\/>\"; \u00a0\n\u00a0 if ($result) {\n\u00a0 \u00a0 $i = $lowerbound + 1;\n\u00a0 \u00a0 foreach ($result as $comment) {\n\u00a0 \u00a0 \u00a0 $created_at = $comment->comment_date_gmt;\n\u00a0 \u00a0 \u00a0 $text = strip_tags($comment->comment_content, \"<p><br><div><img><span><pre><video><audio>\");\n\u00a0 \u00a0 \u00a0 $author = $comment->comment_author;\n\u00a0 \u00a0 \u00a0 $email = $comment->comment_author_email;\n\u00a0 \u00a0 \u00a0 $url = $comment->comment_author_url;\n\u00a0 \u00a0 \u00a0 $post_id = $comment->comment_post_ID;\n\u00a0 \u00a0 \u00a0 $post_title = $comment->post_title;\n\u00a0 \u00a0 \u00a0 $post_name = $comment->post_name;\n\u00a0 \u00a0 \u00a0 echo \"<B>$i<\/B>. <i>$created_at<\/i> <a rel=nofollow target=_blank href='$url'>$author<\/a> Comments on <a href='<a class=\"vglnk\" target=\"_blank\" href=\"https:\/\/helloacm.com\/$post_name\/\" rel=\"nofollow\"><span>https<\/span><span>:\/\/<\/span><span>helloacm<\/span><span>.<\/span><span>com<\/span><span>\/$<\/span><span>post<\/span><span>_<\/span><span>name<\/span><span>\/<\/span><\/a>'>$post_title<\/a>: <BR\/><div>$text<\/div>\";\n\u00a0 \u00a0 \u00a0 $i++;\n\u00a0 \u00a0 \u00a0 echo \"<BR\/><BR\/>\"; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\n\u00a0 \u00a0 }\n\u00a0 } \u00a0\n\u00a0 \n\u00a0 if ($page < $totalpages) {\n\u00a0 \u00a0 echo \"<a href='?page=\".($page+1).\"'>Older Comments<\/a> - \";\n\u00a0 }\n\u00a0 if ($page > 1) {\n\u00a0 \u00a0 echo \"<a href='?page=\".($page-1).\"'>Newer Comments<\/a>\";\n\u00a0 }<\/code><\/pre>\n
Ensuite, vous aurez besoin d’un plugin wordpress<\/a> par exemple Simple PHP Include<\/a> pour inclure le fichier PHP dans une page. Assurez-vous de vider le cache de la page de commentaires. Les commentaires par d\u00e9faut affich\u00e9s par page sont de 25, mais vous pouvez facilement personnaliser cette variable.<\/p>\n
Vous devez \u00e9galement v\u00e9rifier et d\u00e9finir les URL pr\u00e9f\u00e9rables correctes pour la publication, dans mon cas, l’URL est au format \/post_name.<\/p>\n
Le SQL<\/a> sous-jacent consiste simplement \u00e0 combiner la page **wp_comments**<\/code>et **wp_posts**<\/code>de sorte que lors de la liste des commentaires, il n’affiche que les commentaires approuv\u00e9s dans l’ordre d\u00e9croissant du temps (les commentaires les plus r\u00e9cents r\u00e9pertori\u00e9s en premier) avec le titre des messages.<\/p>\n
Source d’enregistrement:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Comment cr\u00e9er une page WordPress pour lister tous les commentaires ?<\/p>\n","protected":false},"author":1,"featured_media":224757,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[893,832,801,841,862],"tags":[1167],"class_list":["post-233027","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-code-2","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\/233027","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=233027"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/posts\/233027\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/media\/224757"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/media?parent=233027"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/categories?post=233027"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/tags?post=233027"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}