Display WP Users in Table format filter by Role

markz said:

Hello all, I need help on display Users List on my Page in Table format filter by Role.

Currently I'm using Ultimate Members and it's Member Directory feature only show users in individual Card format. Unable to make it to show in Table format.

Respected expert here please advise, which Plugin or Shortcode I can use to achieve what I need? Please advice, thank you.

Click to expand...

1. Navigate to your CPanel
2. Navigate to PhpMyAdmin
3. Then on the left-hand side, find the database that has your WordPress is installed in and select it
4. Now, on the middle of the screen on the top, find SQL tab, then simply put in the below code:

SELECT * FROM TableNaameHere;

SELECT * FROM wpqb_users;

SELECT * FROM wpqb_posts;

markz said:

I find it easy to find a plugin to display Custom Post Type, such as WPdataTables.

But I can't find anything for Users with custom fields yet.

Click to expand...

markz said:

@Jano Buddy, can advice on this part? I'm not very familiar with SQL query.

I wanted to try get users data as what you advice, but I need to get link data from "usermeta" table as well.

The relation field is "user_id" on "usermeta" table.

How the MySQL query will look like? Can you give me an example so that I can learn from your example, thanks in advance.

Click to expand...

SELECT * FROM wpqb_usermeta;

markz said:

Please allow me to explain again.

I have this two table in my WP DB, wp_users and wp_usermeta.

To get the list of users, yes the following query do the job:

SQL:

SELECT * FROM wpqb_usermeta;

But I also need the wp_usermate included in the query result as well. The wp_usermeta include the custom fields I need for users.

I hope this explain better.

Click to expand...