How to show number of entries on database?

To show number of entries on a form simply add {PRINTCOUNT:formname} to any page.

If you would like to show totals for the logged-in user, add this instead:
{QUERY:self_entries}
{PRINTCOUNT:formname}

If you would like to show totals for the owner of the displayed entry, use this:
{QUERY:own_entries}
{PRINTCOUNT:formname}

You can even create a custom query using Query Builder to get specific kind of entries(i.e. number of members with uploaded pictures), then use PRINTCOUNT tag to show the statistics.

Add a new comment