{"id":232997,"date":"2023-02-02T15:57:00","date_gmt":"2023-02-02T12:57:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232997"},"modified":"2022-11-10T18:41:14","modified_gmt":"2022-11-10T15:41:14","slug":"kuidas-luua-wordpressi-lehte-mis-naeitab-kommentaaride-statistikat","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/et\/kuidas-luua-wordpressi-lehte-mis-naeitab-kommentaaride-statistikat\/","title":{"rendered":"Kuidas luua WordPressi lehte, mis n\u00e4itab kommentaaride statistikat?"},"content":{"rendered":"

WordPress p\u00f5hineb PHP-l ja MySQL-il. Seega on see v\u00e4ga paindlik ja v\u00f5imas. See artikkel juhendab teid, kuidas luua leht, mis n\u00e4itab teie ajaveebi kommentaaride statistikat. N\u00e4iteks kahe veeruga tabel, autor ja tema kommentaaride arv.<\/p>\n

PHP-koodi lubamiseks peate installima plugina, mis v\u00f5imaldab teil oma postitustesse\/lehtedesse lisada PHP-koodi. Minu soovitus on otsida oma WordPressi juhtpaneelilt s\u00f5na [Simple Include HTML and PHP].<\/p>\n

Seej\u00e4rel peate looma lehe, millel on v\u00e4hemalt j\u00e4rgmine teave (m\u00e4rgitud punasega).<\/p>\n

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

WordPressi pistikprogramm kommentaaride statistika kuvamiseks<\/p>\n

Seej\u00e4rel minge oma teema kausta ja looge fail nimega cmt.php<\/strong> ning m\u00e4\u00e4rake failile juurdep\u00e4\u00e4su re\u017eiimiks 644 (v\u00f5i v\u00e4hemalt loetavaks).<\/p>\n

PHP-kood faili t\u00e4itmiseks on:<\/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
Kl\u00f5psates valikul [Autor], navigeeritakse esitatud URL-ile (uues aknas) ja nupul [Kommentaaride arv] kl\u00f5psamine viib tema viimase kommentaarini. Kui see ei ole standardne [\/archives\/post_id], v\u00f5ib olla vaja kohandada URL-i vormingut.<\/p>\n
N\u00e4idislehte saab vaadata siit: https:\/\/justyy.com\/commentator<\/a> (hiina keeles).<\/p>\n
PHP funktsioon mysql_real_escape_string()<\/strong> on amortiseerunud, kuid saate siiski kasutada esc_sql-i<\/strong> v\u00f5i $wpdb->prepare()<\/strong> stringide (mis sisaldavad \u00fche- v\u00f5i topeltjutum\u00e4rke) p\u00f5genemiseks SQL-i\/andmebaasi jaoks.<\/p>\n
:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Kuidas luua WordPressi leht, mis n\u00e4itab kommentaaride statistikat?<\/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":[718,833,894,842,802,863],"tags":[1165],"class_list":["post-232997","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-arendaja","category-juhend-algajatele","category-kood","category-opetused","category-php-4","category-wordpress-4","tag-affiai-et"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/posts\/232997","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/comments?post=232997"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/posts\/232997\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/media\/224768"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/media?parent=232997"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/categories?post=232997"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/tags?post=232997"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}