{"id":232983,"date":"2023-02-02T15:25:00","date_gmt":"2023-02-02T12:25:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232983"},"modified":"2022-11-10T18:38:30","modified_gmt":"2022-11-10T15:38:30","slug":"jak-stworzyc-strone-wordpress-ktora-pokazuje-statystyki-komentarzy","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/pl\/jak-stworzyc-strone-wordpress-ktora-pokazuje-statystyki-komentarzy\/","title":{"rendered":"Jak stworzy\u0107 stron\u0119 WordPress, kt\u00f3ra pokazuje statystyki komentarzy?"},"content":{"rendered":"

WordPress jest oparty na PHP i MySQL. Jest wi\u0119c bardzo elastyczny i pot\u0119\u017cny. Z tego artyku\u0142u dowiesz si\u0119, jak utworzy\u0107 stron\u0119, kt\u00f3ra pokazuje statystyki komentarzy do Twojego bloga. Na przyk\u0142ad tabela z dwiema kolumnami, autorem i liczb\u0105 jego komentarzy.<\/p>\n

Aby w\u0142\u0105czy\u0107 kod PHP, musisz zainstalowa\u0107 wtyczk\u0119, kt\u00f3ra pozwoli Ci do\u0142\u0105czy\u0107 kod PHP do Twoich post\u00f3w\/stron. Zalecam wyszukanie [Simple Include HTML and PHP] w panelu sterowania WordPress.<\/p>\n

Nast\u0119pnie musisz utworzy\u0107 stron\u0119, kt\u00f3ra ma co najmniej nast\u0119puj\u0105ce (zaznaczone na czerwono).<\/p>\n

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

Wtyczka WordPress do wy\u015bwietlania statystyk komentarzy<\/p>\n

Nast\u0119pnie przejd\u017a do folderu z motywem i utw\u00f3rz plik o nazwie cmt.php<\/strong> i ustaw tryb dost\u0119pu do pliku na 644 (lub przynajmniej czytelny).<\/p>\n

Kod PHP do wype\u0142nienia pliku to:<\/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
Klikni\u0119cie [Autor] spowoduje przej\u015bcie do podanego adresu URL (w nowym oknie), a klikni\u0119cie [Liczba komentarzy] doprowadzi do ich ostatniego komentarza. Format adresu URL mo\u017ce wymaga\u0107 dostosowania, je\u015bli nie jest standardowy [\/archives\/post_id].<\/p>\n
Przyk\u0142adow\u0105 stron\u0119 mo\u017cna obejrze\u0107 tutaj: https:\/\/justyy.com\/commentator<\/a> (w j\u0119zyku chi\u0144skim).<\/p>\n
Funkcja PHP mysql_real_escape_string()<\/strong> jest przestarza\u0142a, ale nadal mo\u017cesz u\u017cywa\u0107 esc_sql<\/strong> lub $wpdb->prepare()<\/strong> do ucieczki ci\u0105g\u00f3w (zawieraj\u0105cych pojedyncze lub podw\u00f3jne cudzys\u0142owy) dla SQL\/bazy danych.<\/p>\n
\u0179r\u00f3d\u0142o nagrywania:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Jak utworzy\u0107 stron\u0119 WordPress, kt\u00f3ra pokazuje statystyki komentarzy?<\/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":[721,897,805,836,845,866],"tags":[1169],"class_list":["post-232983","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-deweloper","category-kod","category-php-7","category-przewodnik-dla-poczatkujacych","category-samouczki","category-wordpress-7","tag-affiai-pl"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/posts\/232983","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/comments?post=232983"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/posts\/232983\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/media\/224768"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/media?parent=232983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/categories?post=232983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/tags?post=232983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}