wordpress 统计所有用户某天发帖数

01378
<?php
//Include WordPress
define('WP_USE_THEMES', false); //无需使用主题
include_once('./wp-load.php');  //根据wordpress路径来调用 需要同服务器下
global $wpdb;
//时间规划
$date_0=date('Y-m-d', time());//今天
$date_1=date("Y-m-d",strtotime("-1 day"));//昨天
$date_2=date("Y-m-d",strtotime("-2 day"));//前天
$date_3=date("Y-m-d",strtotime("-3 day"));//大前天
$date_4=date("Y-m-d",strtotime("-4 day"));//大大前天
$date_5=date("Y-m-d",strtotime("-5 day"));//大大大前天
//时间规划
//获取某人某天的发帖量，不传$date为某人所有文章数
function get_posts_count($userid,$date) {
   global $wpdb;
   if($date){
   $numposts = $wpdb->get_var(
       $wpdb->prepare("SELECT COUNT(ID) FROM `wp_posts`  WHERE  
       `post_author` = $userid
       AND post_type= 'post'
       AND post_status= 'publish'
       AND post_date between '$date 00:00:00' and '$date 23:59:59';")
       );
   }else{
   $numposts = $wpdb->get_var(
       $wpdb->prepare("SELECT COUNT(ID) FROM `wp_posts`  WHERE  
       `post_author` = $userid
       AND post_type= 'post'
       AND post_status= 'publish';")
       );
   }
   return $numposts;
}
if($_REQUEST["date"] == "-1"){
   $date = $date_1;
}elseif ($_REQUEST["date"] == "-2") {
   $date = $date_2;
}elseif ($_REQUEST["date"] == "-3") {
   $date = $date_3;
}elseif ($_REQUEST["date"] == "-4") {
   $date = $date_4;
}elseif ($_REQUEST["date"] == "-5") {
   $date = $date_5;
}
else{
   $date = $date_0;
}
$row = $wpdb->get_results("SELECT * FROM `wp_users`");//获取所有用户信息
//var_dump($row);
$usernum=count($row);//获取用户总数
for ($i = 0; $i < $usernum; $i++) {
    $userid[$i]=$row[$i]->ID;//用户ID
    $userpostnum[$i]=get_posts_count($row[$i]->ID,$date);//用户今天的文章数
    $username[$i]=$row[$i]->display_name;//用户名字
   
}
//print_r(json_encode($userid));
//print_r(json_encode($username));
?>
<!DOCTYPE html>
<html style="height: 100%">
   <head>
       <meta charset="utf-8">
   </head>
   <body style="height: 100%; margin: 0">
       <div id="container" style="height: 100%"></div>
       <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/echarts@5/dist/echarts.min.js"></script>
       <script type="text/javascript">
var dom = document.getElementById("container");
var myChart = echarts.init(dom);
var app = {};
var option;
option = {
   xAxis: {
       type: 'category',
       data: <?php print_r(json_encode($username));?>
   },
   yAxis: {
       type: 'value'
   },
   series: [{
       data: <?php print_r(json_encode($userpostnum));?>,
       type: 'bar',
       showBackground: true,
       backgroundStyle: {
           color: 'rgba(180, 180, 180, 0.2)'
       }
   }]
};
if (option && typeof option === 'object') {
   myChart.setOption(option);
}
       </script>
   </body>
</html>
<?php
//Include WordPress
define('WP_USE_THEMES', false); //无需使用主题
include_once('./wp-load.php');  //根据wordpress路径来调用 需要同服务器下
global $wpdb;
//时间规划
$date_0=date('Y-m-d', time());//今天
$date_1=date("Y-m-d",strtotime("-1 day"));//昨天
$date_2=date("Y-m-d",strtotime("-2 day"));//前天
$date_3=date("Y-m-d",strtotime("-3 day"));//大前天
$date_4=date("Y-m-d",strtotime("-4 day"));//大大前天
$date_5=date("Y-m-d",strtotime("-5 day"));//大大大前天
//时间规划
//获取某人某天的发帖量，不传$date为某人所有文章数
function get_posts_count($userid,$date) {
   global $wpdb;
   if($date){
   $numposts = $wpdb->get_var(
       $wpdb->prepare("SELECT COUNT(ID) FROM `wp_posts`  WHERE  
       `post_author` = $userid
       AND post_type= 'post'
       AND post_status= 'publish'
       AND post_date between '$date 00:00:00' and '$date 23:59:59';")
       );
   }else{
   $numposts = $wpdb->get_var(
       $wpdb->prepare("SELECT COUNT(ID) FROM `wp_posts`  WHERE  
       `post_author` = $userid
       AND post_type= 'post'
       AND post_status= 'publish';")
       );
   }
   return $numposts;
}
if($_REQUEST["date"] == "-1"){
   $date = $date_1;
}elseif ($_REQUEST["date"] == "-2") {
   $date = $date_2;
}elseif ($_REQUEST["date"] == "-3") {
   $date = $date_3;
}elseif ($_REQUEST["date"] == "-4") {
   $date = $date_4;
}elseif ($_REQUEST["date"] == "-5") {
   $date = $date_5;
}
else{
   $date = $date_0;
}
$row = $wpdb->get_results("SELECT * FROM `wp_users`");//获取所有用户信息
//var_dump($row);
$usernum=count($row);//获取用户总数
for ($i = 0; $i < $usernum; $i++) {
    $userid[$i]=$row[$i]->ID;//用户ID
    $userpostnum[$i]=get_posts_count($row[$i]->ID,$date);//用户今天的文章数
    $username[$i]=$row[$i]->display_name;//用户名字
   
}
//print_r(json_encode($userid));
//print_r(json_encode($username));
?>
<!DOCTYPE html>
<html style="height: 100%">
   <head>
       <meta charset="utf-8">
   </head>
   <body style="height: 100%; margin: 0">
       <div id="container" style="height: 100%"></div>
       <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/echarts@5/dist/echarts.min.js"></script>
       <script type="text/javascript">
var dom = document.getElementById("container");
var myChart = echarts.init(dom);
var app = {};
var option;
option = {
   xAxis: {
       type: 'category',
       data: <?php print_r(json_encode($username));?>
   },
   yAxis: {
       type: 'value'
   },
   series: [{
       data: <?php print_r(json_encode($userpostnum));?>,
       type: 'bar',
       showBackground: true,
       backgroundStyle: {
           color: 'rgba(180, 180, 180, 0.2)'
       }
   }]
};
if (option && typeof option === 'object') {
   myChart.setOption(option);
}
       </script>
   </body>
</html>
<?php
//Include WordPress
define('WP_USE_THEMES', false); //无需使用主题
include_once('./wp-load.php');  //根据wordpress路径来调用 需要同服务器下
global $wpdb;
//时间规划
$date_0=date('Y-m-d', time());//今天
$date_1=date("Y-m-d",strtotime("-1 day"));//昨天
$date_2=date("Y-m-d",strtotime("-2 day"));//前天
$date_3=date("Y-m-d",strtotime("-3 day"));//大前天
$date_4=date("Y-m-d",strtotime("-4 day"));//大大前天
$date_5=date("Y-m-d",strtotime("-5 day"));//大大大前天
//时间规划
//获取某人某天的发帖量，不传$date为某人所有文章数
function get_posts_count($userid,$date) {
   global $wpdb;
   if($date){
   $numposts = $wpdb->get_var(
       $wpdb->prepare("SELECT COUNT(ID) FROM `wp_posts`  WHERE  
       `post_author` = $userid
       AND post_type= 'post'
       AND post_status= 'publish'
       AND post_date between '$date 00:00:00' and '$date 23:59:59';")
       );
   }else{
   $numposts = $wpdb->get_var(
       $wpdb->prepare("SELECT COUNT(ID) FROM `wp_posts`  WHERE  
       `post_author` = $userid
       AND post_type= 'post'
       AND post_status= 'publish';")
       );
   }
   return $numposts;
}
if($_REQUEST["date"] == "-1"){
   $date = $date_1;
}elseif ($_REQUEST["date"] == "-2") {
   $date = $date_2;
}elseif ($_REQUEST["date"] == "-3") {
   $date = $date_3;
}elseif ($_REQUEST["date"] == "-4") {
   $date = $date_4;
}elseif ($_REQUEST["date"] == "-5") {
   $date = $date_5;
}
else{
   $date = $date_0;
}
$row = $wpdb->get_results("SELECT * FROM `wp_users`");//获取所有用户信息
//var_dump($row);
$usernum=count($row);//获取用户总数
for ($i = 0; $i < $usernum; $i++) {
    $userid[$i]=$row[$i]->ID;//用户ID
    $userpostnum[$i]=get_posts_count($row[$i]->ID,$date);//用户今天的文章数
    $username[$i]=$row[$i]->display_name;//用户名字
   
}
//print_r(json_encode($userid));
//print_r(json_encode($username));
?>
<!DOCTYPE html>
<html style="height: 100%">
   <head>
       <meta charset="utf-8">
   </head>
   <body style="height: 100%; margin: 0">
       <div id="container" style="height: 100%"></div>
       <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/echarts@5/dist/echarts.min.js"></script>
       <script type="text/javascript">
var dom = document.getElementById("container");
var myChart = echarts.init(dom);
var app = {};
var option;
option = {
   xAxis: {
       type: 'category',
       data: <?php print_r(json_encode($username));?>
   },
   yAxis: {
       type: 'value'
   },
   series: [{
       data: <?php print_r(json_encode($userpostnum));?>,
       type: 'bar',
       showBackground: true,
       backgroundStyle: {
           color: 'rgba(180, 180, 180, 0.2)'
       }
   }]
};
if (option && typeof option === 'object') {
   myChart.setOption(option);
}
       </script>
   </body>
</html>
wordpress 统计所有用户某天发帖数 第1张
© 版权声明
文章版权声明 1、本网站名称：KEKC博客
2、本站网址：https://www.kekc.cn
3、本网站的文章部分内容可能来源于网络，仅供大家学习与参考，如有侵权，请联系站长QQ2551654928进行删除处理。
4、本站一律禁止以任何方式发布或转载任何违法的相关信息，访客发现请向站长举报

THE END
oldwordpresswordpress
喜欢就支持一下吧
点赞8 分享
Making the absolute best of ourselves is not an easy task. It is a pleasurable pursuit...but it requires patience, persistence, and perseverance.
做最好的自己并不容易，这是很美好的愿望，需要耐心、坚持和毅力
KEKC的头像-KEKC博客
相关推荐
评论 抢沙发
头像
欢迎您留下宝贵的见解！
提交
头像

昵称

取消
昵称

请填写用户信息：

  • 昵称(必填)
  • 邮箱(必填)
常用语
请选择评论常用语：
  • 1、谢谢博主分享！
  • 2、博主NB，666
  • 3、感谢楼主分享！
  • 4、感谢大佬分享！
  • 5、教程很好用，谢谢！
 夸夸
夸夸
还有吗！没看够！
表情
[aoman][baiyan][bishi][bizui][cahan][ciya][dabing][daku][deyi][doge][fadai][fanu][fendou][ganga][guzhang][haixiu][hanxiao][zuohengheng][zhuakuang][zhouma][zhemo][zhayanjian][zaijian][yun][youhengheng][yiwen][yinxian][xu][xieyanxiao][xiaoku][xiaojiujie][xia][wunai][wozuimei][weixiao][weiqu][tuosai][tu][touxiao][tiaopi][shui][se][saorao][qiudale][qinqin][qiaoda][piezui][penxue][nanguo][liulei][liuhan][lenghan][leiben][kun][kuaikule][ku][koubi][kelian][keai][jingya][jingxi][jingkong][jie][huaixiao][haqian][aini][OK][qiang][quantou][shengli][woshou][gouyin][baoquan][aixin][bangbangtang][xiaoyanger][xigua][hexie][pijiu][lanqiu][juhua][hecai][haobang][caidao][baojin][chi][dan][kulou][shuai][shouqiang][yangtuo][youling]
代码

请输入代码：

确认
图片
快捷回复
谢谢你的分享，我从中学到了很多！
教程很好用，谢谢！
好东西，学习一下！
楼主听话，快到碗里来！
路过一下，我只是来打酱油的！
水帖美如花，养护靠大家！

    暂无评论内容

随机文章

1Linux Centos挂载硬盘命令，为Kangle挂载额外硬盘记录

2【投稿】QQ乐易支付程序免费版1.0

3WordPress中的options表的存储、修改、删除、获取流程

4Kangle一键脚本 – 咖啡Kangle一键脚本

5如何通过网页版百度网盘下载大文件

6《漂洋过海来看你》背后的故事