{"id":232941,"date":"2023-02-01T17:20:00","date_gmt":"2023-02-01T14:20:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232941"},"modified":"2022-11-10T18:27:11","modified_gmt":"2022-11-10T15:27:11","slug":"jak-wyswietlic-statystyki-bloga-w-stopce-strony","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/pl\/jak-wyswietlic-statystyki-bloga-w-stopce-strony\/","title":{"rendered":"Jak wy\u015bwietli\u0107 statystyki bloga w stopce strony?"},"content":{"rendered":"<p>Prawie ka\u017cdy motyw wordpress ma plik <strong>footer.php<\/strong>, kt\u00f3ry zawiera uk\u0142ad stopki strony. Mo\u017cesz wstawi\u0107 nast\u0119puj\u0105cy kod PHP+MySQL, aby wy\u015bwietli\u0107 statystyki bloga na ko\u0144cu ka\u017cdej strony.<\/p>\n<pre><code>&lt;?php\nglobal $wpdb;\/\/ &lt;a class=\"vglnk\" target=\"_blank\" href=\"https:\/\/helloacm.com\" rel=\"nofollow\"&gt;&lt;span&gt;https&lt;\/span&gt;&lt;span&gt;:\/\/&lt;\/span&gt;&lt;span&gt;helloacm&lt;\/span&gt;&lt;span&gt;.&lt;\/span&gt;&lt;span&gt;com&lt;\/span&gt;&lt;\/a&gt;\n$query = \"select count(1) from `wp_posts` where `post_status`='publish' and `post_type`='post'\";\n$cnt_posts = $wpdb-&gt;get_var($query);\n$query = \"select count(1) from `wp_posts` where `post_status`='publish' and `post_type`='page'\";\n$cnt_pages = $wpdb-&gt;get_var($query);\n$query = \"select count(1) from `wp_comments` where `comment_approved`=1\";\n$cnt_comments = $wpdb-&gt;get_var($query);\n$start = strtotime(\"2011-07-03 00:00:00\"); \u00a0\/\/ Need to replace the date to the date when you published your first article.\n$today = strtotime(date(\"Y-m-d h:i:s\"));\n$days = round(abs($today - $start) \/ 3600 \/ 24);\n?&gt;\n\u00a0\nBlog is up for &lt;?php echo $days;?&gt; days, and there are &lt;?php echo $cnt_posts;?&gt; posts and &lt;?php echo $cnt_pages;?&gt; pages, there are &lt;?php echo $cnt_comments;?&gt; comments.<\/code><\/pre>\n<p>Data opublikowania pierwszego posta jest przechowywana w zmiennej PHP <strong>$start<\/strong> i dlatego nale\u017cy j\u0105 odpowiednio zmodyfikowa\u0107. Powy\u017cszy kod PHP wykonuje trzy instrukcje SQL dla trzech liczb: liczby post\u00f3w, liczby stron i liczby komentarzy. Obliczana jest r\u00f3\u017cnica dni.<\/p>\n<p>Pami\u0119taj r\u00f3wnie\u017c, \u017ce je\u015bli masz wtyczk\u0119 pami\u0119ci podr\u0119cznej swojego bloga WordPress, wy\u015bwietlanie aktualizowanych codziennie informacji mo\u017ce spowodowa\u0107 uniewa\u017cnienie pami\u0119ci podr\u0119cznej raz dziennie.<\/p>\n<p><div id=\"PostUnique_PostSource\" style=\"padding-top: 50px\">\u0179r\u00f3d\u0142o nagrywania:  <a target=\"_blank\" rel=\"noopener nofollow\" href=\"\/\/helloacm.com\" class=\"external external_icon\">helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Jak wy\u015bwietli\u0107 statystyki bloga w stopce strony?<\/p>\n","protected":false},"author":1,"featured_media":223984,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[897,805,845,866,815],"tags":[1169],"class_list":["post-232941","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kod","category-php-7","category-samouczki","category-wordpress-7","category-wtyczki","tag-affiai-pl"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/posts\/232941","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=232941"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/posts\/232941\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/media\/223984"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/media?parent=232941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/categories?post=232941"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/tags?post=232941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}