Display The Total Number Of Registered Users

December 9th, 2009 by Frank • WordPress Hacks • 5 Comments

WordPress-Christmas-09Anyone who operates a community using WordPress, and would like to display the total number of registered users, can easily and quickly use the following small code snippet.

It reads via SQL the content of the table "users", and the numbers of IDs getting counted. This value simply gets wrapped around a text.

$myusers = $wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->users");
echo sprintf( __('We have %s registered user.', 'myTextDomain') , $myusers );

3 Comments
  1. Miss K says:
    January 9, 2010 at 1:16 am

    this is very usefull (at least for me :-)!
    thank you...
    but i try to implement this into a php sidebar widget
    get_var("SELECT COUNT(ID) FROM $wpdb->users");
    echo sprintf( __('We have %s registered user.', 'myTextDomain') , $myusers );
    ?>
    and I get the following error :
    Fatal error: Call to a member function on a non-object in --/versatile-k/wp-content/plugins/php-code-widget/execphp.php(37) : eval()'d code on line 2

  2. wahnfried says:
    February 24, 2010 at 2:17 pm

    hello,
    so i have the same problem, the snippet doesnt work in the sidebar.maybe you can help?
    thx
    regards
    Wahnfried

  3. Michael says:
    February 24, 2010 at 3:04 pm

    @wahnfried: Use

    global $wpdb;

    before query.

2 Pings
  1. Die Anzahl der registrierten Benutzer anzeigen | galuba dot net
  2. 11 Awesome Wordpress Development Blogs
WP Engineer Tags