dss087358 2018-08-16 12:06
浏览 108
已采纳

如何从wordpress中的wp_users表中获取所有user_nicename?

I have this function here:

function displaymeta(){
        global $post;
        global $wpdb;
        $authors = $wpdb->get_results("select id,user_nicename from $wpdb->users");
        foreach($authors as $auth){
                $authorname = get_the_author_meta('user_nicename',$auth->ID);
                echo $authorname;
        }
}
add_filter( 'the_content', 'displaymeta' );

It should retrieve all the user_nicename from wp_users table in database. But when I execute this code, I just get the first username twice, even though there are two distinct users. What am I missing here? Thanks!

UPDATE I need to do something like this:

 $arr=array();
 global $wpdb;
 $authors = $wpdb->get_results("SELECT ID, user_nicename from $wpdb->users 
                                ORDER BY display_name");
 foreach($authors as $auth)
 {
    $arr[]=get_author_meta('user_nicename', $auth->ID);
 }

I want to store the user_nicename in an array of all users in the wp_users table.

  • 写回答

1条回答 默认 最新

  • dqe9657 2018-08-16 12:18
    关注

    You can do it very simple like this:

    $users = get_users();
    foreach($users as $user) {
        echo $user->user_nicename;
    }
    

    More info here -> https://codex.wordpress.org/Function_Reference/get_users

    If you simply want an array with just the user_nicenames you can do it like this:

    global $wpdb
    
    $user_nicenames = $wpdb->get_results("SELECT user_nicename FROM {$wpdb->prefix}users", ARRAY_A);
    
    foreach($user_nicenames as $nice_name) {
        echo $nice_name;
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 GD模块安装出错,libgd无法正常安装
  • ¥20 求有缘人帮我把笛卡尔坐标系转换为经纬度 有偿
  • ¥15 vue2中使用计算属性
  • ¥50 远程桌面打开Mastercam、没有许可证、物理机打开正常
  • ¥15 ubuntu安装gdal后java读取tif文件报错
  • ¥15 请问lammps怎么做两种金属连接的原子浓度分布图
  • ¥15 求jacquard数据集
  • ¥15 w10部分软件不能联网
  • ¥15 关于安装hbase的问题(操作系统-windows)
  • ¥15 novnc连接pve虚拟机报错安全协议不支持262