{"id":232952,"date":"2023-02-01T17:24:00","date_gmt":"2023-02-01T14:24:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232952"},"modified":"2022-11-10T18:29:50","modified_gmt":"2022-11-10T15:29:50","slug":"kuidas-kuvada-ajaveebi-statistikat-lehe-jaluses","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/et\/kuidas-kuvada-ajaveebi-statistikat-lehe-jaluses\/","title":{"rendered":"Kuidas kuvada ajaveebi statistikat lehe jaluses?"},"content":{"rendered":"<p>Peaaegu igal WordPressi teemal on <strong>footer.php<\/strong> fail, mis sisaldab lehe jaluse paigutust. Blogi statistika kuvamiseks iga lehe l\u00f5pus saate sisestada j\u00e4rgmise PHP+MySQL koodi.<\/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>Oma esimese postituse avaldamise kuup\u00e4ev on salvestatud PHP muutujas <strong>$start<\/strong> ja seet\u00f5ttu muutke seda vastavalt. \u00dclaltoodud PHP-kood t\u00e4idab kolme SQL-lauset kolme numbri jaoks: postituste arv, lehek\u00fclgede arv ja kommentaaride arv. P\u00e4evade vahe arvutatakse.<\/p>\n<p>Pange t\u00e4hele, et kui teil on WordPressi ajaveebi vahem\u00e4lu pistikprogramm, v\u00f5ib iga p\u00e4ev uuendatud teabe kuvamine sundida teie vahem\u00e4lu kord p\u00e4evas kehtetuks tunnistama.<\/p>\n<p><div id=\"PostUnique_PostSource\" style=\"padding-top: 50px\">:  <a target=\"_blank\" rel=\"noopener nofollow\" href=\"\/\/helloacm.com\" class=\"external external_icon\">helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kuidas kuvada ajaveebi statistikat lehe jaluses?<\/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":[894,842,802,812,863],"tags":[1165],"class_list":["post-232952","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kood","category-opetused","category-php-4","category-pistikprogrammid","category-wordpress-4","tag-affiai-et"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/posts\/232952","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=232952"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/posts\/232952\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/media\/223984"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/media?parent=232952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/categories?post=232952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/tags?post=232952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}