How to view joomla user in frontend with profile data?

Question

I use Joomla 3.4.4

I would like to view list of users in front end. Along with username i need to view profile data, email and phone, in front end. Is there and extension/plugin/component available?

I checked many plugins but no one give phone number. They provide registration date, and other data, but for me email and phone no are important.

Thanks.

Answer 1

You can write a module or plugin to get this done.

https://docs.joomla.org/J3.x:Creating_a_simple_module/Developing_a_Basic_Module

A shorter way is to download a module which shows your user list and edit the view file (modules/mod_xyz/tmpl/default.php). If not badly written you can just replace unnecessary things.

To know which one you need, just print_r or var_dump your db user object (see zeidanbm answer) like this:

echo '<pre>';
print_r($result);
die;

(Don't do that on a live site.)

You will get a print out of the object and the available fields.

Sorry, can't offer a more detailed answer, I just would write down a complete module...

Answer 2

One way of doing this is to create a new article and insert a php code which will connect to the database and read from the users table. To do that you will need an extension that lets you use php in articles. I personally use Sourcere but you can use any. Here's a sample of the code that can get you started.

<?php
$db = JFactory::getDbo(); 

$query = $db->getQuery(true)
        ->select($db->quoteName(array('username', 'email')))
        ->from($db->quoteName('#__users'));

$db->setQuery($query);

$result = $db->loadObjectList();

foreach ($result as $row) {
echo $row->username.'|'.$row->email;
}
?>

And for the phone number and other profile things you can do the same but change the name of the table to __user_profiles. So the code will look something like below. Also, check the database tables to see the column and row values.

<?php
$db = JFactory::getDbo();

$query = $db->getQuery(true)
        ->select($db->quoteName(array('profile_key')))
        ->from($db->quoteName('#__user_profiles'));

$db->setQuery($query);

$result = $db->loadObjectList();

foreach ($result as $row) {
if( ($row->profile_key) == "profile.phone")
echo $row->profile_value;
}
?>

Answer 3

I realise this is old, but I came on it searching for something similar. So here it is:

https://extensions.joomla.org/extensions/extension/clients-a-communities/user-management/frontend-user-manager/