文章根据浏览量从多到少进行排序的

WordPress程序适合新手使用，但是想要二次开发一些功能还是需要有一定变成基础的，WordPress如何根据浏览量进行排序呢？今天就分享一下文章根据浏览量从多到少进行排序的WordPress教程。

将下方代码添加进functions.php外加一个php文件即可实现：

//根据浏览量从多到少进行排序

function get_most_viewed_format($mode = \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’, $limit = 10, $show_date = 0, $term_id = 0, $beforetitle= \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'(\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’, $aftertitle = \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’, $beforedate= \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'(\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’, $afterdate = \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’, $beforecount= \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'(\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’, $aftercount = \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’) {

global $wpdb, $post;

$output = \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’;

$mode = ($mode == \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’) ? \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’post\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’ : $mode;

$type_sql = ($mode != \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’both\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’) ? \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\”AND post_type=\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’$mode\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\” : \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’;

$term_sql = (is_array($term_id)) ? \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\”AND $wpdb->term_taxonomy.term_id IN (\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\” . join(\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’,\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’, $term_id) . \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’ : ($term_id != 0 ? \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\”AND $wpdb->term_taxonomy.term_id = $term_id\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\” : \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’);

$term_sql.= $term_id ? \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\” AND $wpdb->term_taxonomy.taxonomy != \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’link_category\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\” : \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’;

$inr_join = $term_id ? \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\”INNER JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id) INNER JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\” : \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’;

// database query

$most_viewed = $wpdb->get_results(\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\”SELECT ID, post_date, post_title, (meta_value+0) AS views FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON ($wpdb->posts.ID = $wpdb->postmeta.post_id) $inr_join WHERE post_status = \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’publish\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’ AND post_password = \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’ $term_sql $type_sql AND meta_key = \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’views\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’ GROUP BY ID ORDER BY views DESC LIMIT $limit\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\”);

if ($most_viewed) {

foreach ($most_viewed as $viewed) {

$post_ID = $viewed->ID;

$post_views = number_format($viewed->views);

$post_title = esc_attr($viewed->post_title);

$get_permalink = esc_attr(get_permalink($post_ID));

$output .= \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'<li><a href=\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\”\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’.get_permalink($post_ID).\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\”>\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’.$post_title.\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’;

if ($show_date) {

$posted = date(get_option(\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’date_format\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\’), strtotime($viewed->post_date));

$output .= \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\”$beforedate $posted $afterdate\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\”;

}

$output .= \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\”$beforecount $post_views $aftercount</a></li>\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\”;

}

} else {

$output = \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\”<li>N/A</li>n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\”;

}

echo $output;

}

//在需要调用的地方插入下方代码

<?php get_most_viewed_format(); ?>