{"id":232959,"date":"2023-02-02T16:00:00","date_gmt":"2023-02-02T13:00:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232959"},"modified":"2022-11-10T18:31:42","modified_gmt":"2022-11-10T15:31:42","slug":"hur-man-skapar-en-wordpress-sida-som-visar-kommentarsstatistik","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/sv\/hur-man-skapar-en-wordpress-sida-som-visar-kommentarsstatistik\/","title":{"rendered":"Hur man skapar en WordPress-sida som visar kommentarsstatistik?"},"content":{"rendered":"

WordPress \u00e4r baserat p\u00e5 PHP och MySQL. S\u00e5 den \u00e4r v\u00e4ldigt flexibel och kraftfull. Den h\u00e4r artikeln kommer att guida dig hur du skapar en sida som visar kommentarsstatistiken f\u00f6r din blogg. Till exempel en tabell med tv\u00e5 kolumner, f\u00f6rfattaren och antalet kommentarer.<\/p>\n

F\u00f6r att aktivera PHP-kod m\u00e5ste du installera ett plugin som l\u00e5ter dig inkludera PHP-kod i dina inl\u00e4gg\/sidor. Min rekommendation \u00e4r att s\u00f6ka efter [Simple Include HTML and PHP] p\u00e5 din wordpress kontrollpanel.<\/p>\n

Sedan m\u00e5ste du skapa en sida som \u00e5tminstone har f\u00f6ljande (markerad i r\u00f6tt).<\/p>\n

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

WordPress-plugin f\u00f6r att visa kommentarstatistik<\/p>\n

G\u00e5 sedan till din mapp med temat och skapa en fil som heter cmt.php<\/strong> och st\u00e4ll in fil\u00e5tkomstl\u00e4get till 644 (eller \u00e5tminstone l\u00e4sbart).<\/p>\n

PHP-koden f\u00f6r att fylla i filen \u00e4r:<\/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
Om du klickar p\u00e5 [F\u00f6rfattare] navigerar du till den angivna URL-adressen (i nytt f\u00f6nster), och om du klickar p\u00e5 [Antalet kommentarer] kommer du till deras senaste kommentar. URL-formatet kan beh\u00f6va justeras om det inte \u00e4r standardformatet [\/archives\/post_id].<\/p>\n
Exempelsidan kan ses h\u00e4r: https:\/\/justyy.com\/commentator<\/a> (p\u00e5 kinesiska).<\/p>\n
PHP-funktionen mysql_real_escape_string()<\/strong> \u00e4r avskriven men du kan fortfarande anv\u00e4nda esc_sql<\/strong> eller $wpdb->prepare()<\/strong> f\u00f6r att undvika str\u00e4ngar (som inneh\u00e5ller enkla eller dubbla citattecken) f\u00f6r SQL\/databas.<\/p>\n
Inspelningsk\u00e4lla:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Hur skapar man en WordPress-sida som visar kommentarsstatistik?<\/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":[838,848,901,807,724,868],"tags":[1173],"class_list":["post-232959","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-guide-foer-nyboerjare","category-handledningar","category-koda","category-php-9","category-utvecklaren","category-wordpress-9","tag-affiai-sv"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/232959","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/comments?post=232959"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/232959\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/media\/224768"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/media?parent=232959"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/categories?post=232959"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/tags?post=232959"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}