WP Engineer

WordPress News, Hacks, Tips, Tutorials, Plugins and Themes

Display The Total Number Of Registered Users

Posted in: WordPress Hacks

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 );

Posted by

Webworker by passion, works with priority in WordPress, developing Plugins, themes and solutions. Frank writes in German language on his private blog bueltge.de [by:ltge.de]. He is member of WordPress Germany and writes about news in WordPress Deutschland blog and is author of a book for WordPress.

Comments are closed.

5 comments

  1. Miss K

    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

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

  3. Michael

    @wahnfried: Use

    global $wpdb;

    before query.

2 pingbacks

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