{"id":68510,"date":"2020-03-11T12:32:51","date_gmt":"2020-03-11T04:32:51","guid":{"rendered":"http:\/\/www.xiaoyebailong.com\/?p=68510"},"modified":"2020-03-11T12:32:53","modified_gmt":"2020-03-11T04:32:53","slug":"wordpress%e6%97%a0%e6%8f%92%e4%bb%b6%e8%b0%83%e7%94%a8%e6%b5%8f%e8%a7%88%e6%ac%a1%e6%95%b0%e6%9c%80%e5%a4%9a%e7%9a%84%e6%96%87%e7%ab%a0%e5%88%97%e8%a1%a8","status":"publish","type":"post","link":"http:\/\/www.xiaoyebailong.com\/index.php\/2020\/03\/11\/68510.htm","title":{"rendered":"WordPress\u65e0\u63d2\u4ef6\u8c03\u7528\u6d4f\u89c8\u6b21\u6570\u6700\u591a\u7684\u6587\u7ae0\u5217\u8868"},"content":{"rendered":"\n

\u65b9\u6cd5\/\u6b65\u9aa4<\/h2>\n\n\n\n
  1. \u9996\u5148\u8981\u4f7f\u7528\u7eaf\u4ee3\u7801\u7edf\u8ba1\u6587\u7ae0\u6d4f\u89c8\u6b21\u6570\u3002<\/li>
  2. \u5c06\u4ee5\u4e0b\u6a21\u677f\u51fd\u6570\u653e\u5230\u81ea\u5df1\u7f51\u7ad9\u6a21\u677f\u7684\u6a21\u677f\u51fd\u6570functions.php\u91cc\uff1b\/\/\u83b7\u53d6\u9605\u8bfb\u6700\u591a\u7684\u6587\u7ae0 \u00a0<\/em>
    \/\/\u4ee3\u7801\u6765\u6e90\uff1a\u5b66\u505a\u7f51\u7ad9\u8bba\u575bhttps:\/\/www.xuewangzhan.net\/\u00a0<\/em>
    function<\/strong>\u00a0get_most_viewed_format($mode\u00a0=\u00a0”,\u00a0$limit\u00a0=\u00a010,\u00a0$show_date\u00a0=\u00a00,\u00a0$term_id\u00a0=\u00a00,$beforedate=\u00a0‘(‘,\u00a0$afterdate\u00a0=\u00a0‘)’,\u00a0$beforecount=\u00a0‘(‘,\u00a0$aftercount\u00a0=\u00a0‘)’)\u00a0{\u00a0\u00a0\u00a0
    \u00a0\u00a0global<\/strong>\u00a0$wpdb,\u00a0$post;\u00a0\u00a0\u00a0
    \u00a0\u00a0$output\u00a0=\u00a0”;\u00a0\u00a0\u00a0
    \u00a0\u00a0$mode\u00a0=\u00a0($mode\u00a0==\u00a0”)\u00a0?\u00a0‘post’\u00a0:\u00a0$mode;\u00a0\u00a0\u00a0
    \u00a0\u00a0$type_sql\u00a0=\u00a0($mode\u00a0!=\u00a0‘both’)\u00a0?\u00a0“AND post_type=’$mode<\/strong>‘”\u00a0:\u00a0”;\u00a0\u00a0\u00a0
    \u00a0\u00a0$term_sql\u00a0=\u00a0(is_array($term_id))\u00a0?\u00a0“AND\u00a0$wpdb->term_taxonomy<\/strong>.term_id IN (”\u00a0.\u00a0join(‘,’,$term_id)\u00a0.\u00a0‘)’\u00a0:\u00a0($term_id\u00a0!=\u00a00\u00a0?\u00a0“AND\u00a0$wpdb->term_taxonomy<\/strong>.term_id =\u00a0$term_id<\/strong>”\u00a0:\u00a0”);\u00a0\u00a0\u00a0
    \u00a0\u00a0$term_sql.=\u00a0$term_id\u00a0?\u00a0” AND\u00a0$wpdb->term_taxonomy<\/strong>.taxonomy != ‘link_category'”\u00a0:\u00a0”;\u00a0\u00a0\u00a0
    \u00a0\u00a0$inr_join\u00a0=\u00a0$term_id\u00a0?\u00a0“INNER JOIN\u00a0$wpdb->term_relationships<\/strong>\u00a0ON ($wpdb->posts<\/strong>.ID =\u00a0$wpdb->term_relationships<\/strong>.object_id) INNER JOIN\u00a0$wpdb->term_taxonomy<\/strong>\u00a0ON ($wpdb->term_relationships<\/strong>.term_taxonomy_id =\u00a0$wpdb->term_taxonomy<\/strong>.term_taxonomy_id)”\u00a0:\u00a0”;\u00a0\u00a0\u00a0
    \u00a0\u00a0\/\/ database query \u00a0\u00a0<\/em>
    \u00a0\u00a0$most_viewed\u00a0=\u00a0$wpdb->get_results(“SELECT ID, post_date, post_title, (meta_value+0) AS views FROM\u00a0$wpdb->posts<\/strong>\u00a0LEFT JOIN\u00a0$wpdb->postmeta<\/strong>\u00a0ON ($wpdb->posts<\/strong>.ID =\u00a0$wpdb->postmeta<\/strong>.post_id)\u00a0$inr_join<\/strong>\u00a0WHERE post_status = ‘publish’ AND post_password = ”\u00a0$term_sql<\/strong>\u00a0$type_sql<\/strong>\u00a0AND meta_key = ‘views’ GROUP BY ID ORDER BY views DESC LIMIT\u00a0$limit<\/strong>“);\u00a0\u00a0\u00a0
    \u00a0\u00a0if\u00a0($most_viewed)\u00a0{\u00a0\u00a0\u00a0
    \u00a0 \u00a0foreach\u00a0($most_viewed\u00a0as\u00a0$viewed)\u00a0{\u00a0\u00a0\u00a0
    \u00a0 \u00a0\u00a0$post_ID\u00a0\u00a0 \u00a0=\u00a0$viewed->ID;\u00a0\u00a0\u00a0
    \u00a0 \u00a0\u00a0$post_views\u00a0=\u00a0number_format($viewed->views);\u00a0\u00a0\u00a0
    \u00a0 \u00a0\u00a0$post_title\u00a0=\u00a0esc_attr($viewed->post_title);\u00a0\u00a0\u00a0
    \u00a0 \u00a0\u00a0$get_permalink\u00a0=\u00a0esc_attr(get_permalink($post_ID));\u00a0\u00a0\u00a0
    \u00a0 \u00a0\u00a0$output\u00a0.=\u00a0“<li><a href=’$get_permalink<\/strong>‘>$post_title<\/strong>“;\u00a0\u00a0\u00a0
    \u00a0 \u00a0\u00a0if\u00a0($show_date)\u00a0{\u00a0\u00a0\u00a0
    \u00a0 \u00a0 \u00a0\u00a0$posted\u00a0=\u00a0date(get_option(‘date_format’),\u00a0strtotime($viewed->post_date));\u00a0\u00a0\u00a0
    \u00a0 \u00a0 \u00a0\u00a0$output\u00a0.=\u00a0“$beforedate<\/strong>\u00a0$posted<\/strong>\u00a0$afterdate<\/strong>“;\u00a0\u00a0\u00a0
    \u00a0 \u00a0\u00a0}\u00a0\u00a0\u00a0
    \u00a0 \u00a0\u00a0$output\u00a0.=\u00a0“$beforecount<\/strong>\u00a0$post_views<\/strong>\u00a0$aftercount<\/strong><\/a><\/li>”;\u00a0\u00a0\u00a0
    \u00a0 \u00a0}\u00a0\u00a0\u00a0
    \u00a0\u00a0}\u00a0else\u00a0{\u00a0\u00a0\u00a0
    \u00a0 \u00a0$output\u00a0=\u00a0“<li>N\/A<\/li>n”;\u00a0\u00a0\u00a0
    \u00a0\u00a0}\u00a0\u00a0\u00a0
    \u00a0\u00a0echo\u00a0$output;\u00a0\u00a0\u00a0
    }<\/li>
  3. \u4f7f\u7528\u4ee5\u4e0b\u7684\u4ee3\u7801\u6765\u8c03\u7528\u6d4f\u89c8\u6b21\u6570\u6700\u591a\u7684\u6587\u7ae0\u5217\u8868\u3002<?php<\/strong>\u00a0get_most_viewed_format();\u00a0?><\/strong><\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"

    \u65b9\u6cd5\/\u6b65\u9aa4 \u9996\u5148\u8981\u4f7f\u7528\u7eaf\u4ee3\u7801\u7edf\u8ba1\u6587\u7ae0\u6d4f\u89c8\u6b21\u6570\u3002 \u5c06\u4ee5\u4e0b\u6a21\u677f\u51fd\u6570\u653e\u5230\u81ea\u5df1\u7f51\u7ad9\u6a21\u677f\u7684\u6a21\u677f\u51fd\u6570functions.php\u91cc\uff1b\/\/\u83b7\u53d6\u9605\u8bfb\u6700\u591a\u7684\u6587\u7ae0 \u00a0\/\/\u4ee3\u7801\u6765\u6e90\uff1a\u5b66\u505a\u7f51\u7ad9\u8bba\u575bhttps:\/\/www.xuewangzhan.net\/\u00a0functi…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,6],"tags":[47],"topic":[],"class_list":["post-68510","post","type-post","status-publish","format-standard","hentry","category-htmlcss","category-phps","tag-wordpress"],"_links":{"self":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/68510","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/comments?post=68510"}],"version-history":[{"count":1,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/68510\/revisions"}],"predecessor-version":[{"id":68511,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/68510\/revisions\/68511"}],"wp:attachment":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/media?parent=68510"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/categories?post=68510"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/tags?post=68510"},{"taxonomy":"topic","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/topic?post=68510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}