Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 438
  • Last Modified:

trying pulling back all users

I'm trying to pull back all users from my db using a php script.  What do I need to adjust to make that happen?
<?php
    foreach(get_users() as $user)
        {
            $user = new WP_User($user);
            // print_r($user); for a list of properties available for display.
        }
    ?>

Open in new window

0
COwebmaster
Asked:
COwebmaster
8 Solutions
 
boon86Commented:
0
 
COwebmasterAuthor Commented:
I'm using the wp membership plugin called s2member but the following does not pull back any users at all yet I have 10 users with the role s2member_level1

Any idea what I'm missing?
<?php
    foreach(get_users("role=s2member_level1") as $user)
        {
            $user = new WP_User($user);
            // print_r($user); for a list of properties available for display.
        }
    ?>

Open in new window

0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
COwebmasterAuthor Commented:
Also, in phpmyadmin, I see listed out in the usermeta table the following on each user:

a:1:{s:15:"s2member_level1";s:1:"1";}

Is that the role that I'm referring to in that query above?
0
 
jeremyjared74Commented:
Use this piece of code to print all users for your blog:

<?php
    $wp_user_search = $wpdb->get_results("SELECT ID, display_name FROM $wpdb->users ORDER BY ID");
    foreach ( $wp_user_search as $userid ) {
    $user_id = (int) $userid->ID;
    $user_login = stripslashes($userid->user_login);
    $display_name = stripslashes($userid->display_name);
    $return = '';
    $return .= "\t" . '<li>'. $display_name .'</li>' . "\n";
    print($return);
    }
?>

Open in new window

0
 
jeremyjared74Commented:
The code can go anywhere in your themes template files.
0
 
COwebmasterAuthor Commented:
Okay, I place on a page (I have the plugin php execution installed) but nothing shows up on the page.  It's just blank.  I have 10 users in that table.
0
 
jeremyjared74Commented:
It works for me. Try placing it at the very bottom of the header.php file just to make sure it is printing.

You need to add it to a template file for it to work.
0
 
jeremyjared74Commented:
If you want to use it in your theme, you should make it a shortcode.
0
 
jeremyjared74Commented:
"If you want to place it inside of a page or post"

It should be made into a shortcode.
0
 
COwebmasterAuthor Commented:
but I have php execution installed so I should be able to view that inside a page, right?
0
 
COwebmasterAuthor Commented:
okay, I placed the code above in a separate php page outside of wordpress and nothing gets displayed in the output.  Permissions on all directories off of root are at 777 too.
<?php
    $wp_user_search = $wpdb->get_results("SELECT ID, display_name FROM $wpdb->users ORDER BY ID");
    foreach ( $wp_user_search as $userid ) {
    $user_id = (int) $userid->ID;
    $user_login = stripslashes($userid->user_login);
    $display_name = stripslashes($userid->display_name);
    $return = '';
    $return .= "\t" . '<li>'. $display_name .'</li>' . "\n";
    print($return);
    }
?>

Open in new window

0
 
COwebmasterAuthor Commented:
Okay, I placed the code inside my functions.php page and names were displayed so that's good.  I realized that it had to fall under wordpress framework.  There is no header.php with this theme I'm using.

So if I can get it to pull back data through the functions.php page, then the issue is why can't I have that data display on a page?
0
 
Ray PaseurCommented:
You might want to try something like this before you start trying to use the contents of $wp_user_search

var_dump($wp_user_search);
0
 
COwebmasterAuthor Commented:
If I the code in above, then view the source code on the page, the source code stops at <div class="entry-content">

What would that indicate?
0
 
COwebmasterAuthor Commented:
Okay, I tried var_dump($wp_user_search); and yes it display the results.  Also, I put up a header.php page and can list out the display names just fine.  It's just that when I try to add that php code in the html tab on a page, no names appear and in the source code, it stops at this line of code: <div class="entry-content">
0
 
COwebmasterAuthor Commented:
Okay, I have it pulling back data now on the page using the following:

<?php
foreach (get_users () as $user)
{
$user = new WP_User ($user->ID);
echo get_user_field ("age", $user->ID);
print_r(get_s2member_custom_fields($user->ID));
print_r($user);
}
?>

However, it pulls back all the data on the user in an array.  How then would I parse out just the display name using the above code?
0
 
COwebmasterAuthor Commented:
Thanks!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now