如何为Sql lite数据库提供连接字符串？(How to give Connection String for Sql lite database?)

 首先，我们需要确保帖子有一个自定义的post_meta字段，您将在其上进行缩短。 
 
function whpp_track_post_views($post_id) {
    if (!is_single())
        return;
    if (empty($post_id)) {
        global $post;
        $post_id = $post->ID;
    }
    whpp_set_post_views($post_id);
}

add_action('wp_head', 'whpp_track_post_views');

function whpp_set_post_views($post_id) {
    $count_key = 'whpp_track_post_views';
    $count = get_post_meta($post_id, $count_key, TRUE);
    if ($count == '') {
        $count = 0;
        delete_post_meta($post_id, $count_key);
        add_post_meta($post_id, $count_key, '0');
    } else {
        $count++;
        update_post_meta($post_id, $count_key, $count);
    }
}

//To keep the count accurate, lets get rid of prefetching
remove_action('wp_head', 'adjacent_posts_rel_link_wp_head', 10, 0);

//Short code function
function wh_must_post_read() {
    $html = '';

    $args = [
        'meta_key' => 'whpp_track_post_views', //<--  Check This
        'orderby' => 'meta_value_num',
        'order' => 'DESC',
        'posts_per_page' => 5
    ];

    $my_query_2 = new WP_Query($args);

    if ($my_query_2->have_posts()) :
        while ($my_query_2->have_posts()) : $my_query_2->the_post();

            $html .= "<p class=\"title\">" . get_the_title() . " </p>";
            $html .= "<p>" . get_the_excerpt() . "</p>";
            $html .= "<a href=\"" . get_permalink() . "\" class=\"readmore\">Read more</a>";

        endwhile;
        wp_reset_postdata();
    endif;
    return $html;
}

add_shortcode('wh_must_post', 'wh_must_post_read');
 
 用法 
 在PHP中 
 
echo do_shortcode('[wh_must_post]');
 
 在WP编辑器中 
 
[wh_must_post]
 
 请注意： 要查看此代码的实际操作，请访问几个帖子单页，以便whpp_set_post_views() mehord将whpp_track_post_views meta_key添加到该帖子。 
 
 以上所有代码都在您的活动子主题（或主题）的function.php文件中。 或者也可以在任何插件的php文件中。 
 代码经过测试和运行。 
 
 相关文章： 在没有插件的WordPress中按视图显示热门帖子 
 相关问题： 如何在wordpress中按日期而不是按日期更改帖子的顺序 
 
 希望这可以帮助！ 

First we need to make sure post has a custom post_meta fields on which you 'll be doing your shorting.
 
function whpp_track_post_views($post_id) {
    if (!is_single())
        return;
    if (empty($post_id)) {
        global $post;
        $post_id = $post->ID;
    }
    whpp_set_post_views($post_id);
}

add_action('wp_head', 'whpp_track_post_views');

function whpp_set_post_views($post_id) {
    $count_key = 'whpp_track_post_views';
    $count = get_post_meta($post_id, $count_key, TRUE);
    if ($count == '') {
        $count = 0;
        delete_post_meta($post_id, $count_key);
        add_post_meta($post_id, $count_key, '0');
    } else {
        $count++;
        update_post_meta($post_id, $count_key, $count);
    }
}

//To keep the count accurate, lets get rid of prefetching
remove_action('wp_head', 'adjacent_posts_rel_link_wp_head', 10, 0);

//Short code function
function wh_must_post_read() {
    $html = '';

    $args = [
        'meta_key' => 'whpp_track_post_views', //<--  Check This
        'orderby' => 'meta_value_num',
        'order' => 'DESC',
        'posts_per_page' => 5
    ];

    $my_query_2 = new WP_Query($args);

    if ($my_query_2->have_posts()) :
        while ($my_query_2->have_posts()) : $my_query_2->the_post();

            $html .= "<p class=\"title\">" . get_the_title() . " </p>";
            $html .= "<p>" . get_the_excerpt() . "</p>";
            $html .= "<a href=\"" . get_permalink() . "\" class=\"readmore\">Read more</a>";

        endwhile;
        wp_reset_postdata();
    endif;
    return $html;
}

add_shortcode('wh_must_post', 'wh_must_post_read');
 
USAGE
 In PHP
 
echo do_shortcode('[wh_must_post]');
 
In WP Editor
 
[wh_must_post]
 
Please Note: To see this code in action visit few post single page so that whpp_set_post_views() mehord will add whpp_track_post_views meta_key to that post.
 
All the above code goes in function.php file of your active child theme (or theme). Or also in any plugin php files.
 Code is tested and works.
 
Related Article: Display Popular Posts by Views in WordPress without a Plugin
 Related Question : How to change the order of posts by number of views not by date in wordpress
 
Hope this helps!