You can just call get_user_meta
without specifying a key, and it will return all MetaValues for the user.
$userdata = get_user_meta( $userID );
You may have to do a mapping for displaytitles of the Metavalue, as they are returned in an array
, where the keys
are the databasevalues of your metakeys
.
For example, you may get
$userdata['f711_email_first_name']
If you want to display all these elements in a table, create an array
like this:
$displaytitles = array(
'f711_email_first_name' => 'Email first name',
...
);
When you loop through $userdata
, you may output it like this:
foreach ( $userdata as $thisdata => $value ) {
echo $displaytitles[$thisdata] . ': ' . $value[0];
}
Related Posts:
- Extend the wp_users table
- Change all http to https in mysql databse?
- WooCommerce – Query for ordered products
- Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
- Query WordPress database by registered date and role
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Which is more efficient? Using usermeta, or creating a new MySQL table?
- CRUD operations using WordPress database API
- In what part of the WordPress core does the users table and usermeta table get joined?
- Modify Database in Multi-Site wp_usermeta table
- Advanced SELECT query with condtional statements
- Using GROUP CONCAT in my-sql query with wp_usermeta table
- Slow queries constantly getting stuck on WordPress database of ~100,000 posts
- How to Access wp_usermeta Data Immediately After a New User is Created
- Query multiple tables at once?
- Custom WordPress Table wpdb
- Best practice to limit results in get_row()?
- Users table missing from Database [closed]
- SQL query to set posts in bulk based on the post content
- Query Column of Specific ID from Database Table
- Recovering the table wp_usermeta from users
- Buddypress avatar image in database [closed]
- Storing user submitted forms [closed]
- wp_insert_user not creating account correctly when ID is manually set
- Compare User meta_value with Product meta_value
- Join Query on WP_USERMETA Table
- how add more field to wp user and save it to database
- Move Non-WordPress users table to WordPress database
- WordPress Database Query works in phpMyAdmin but not in the code
- How to get the id of recently registered user from database?
- update multiple user meta field based on another meta field
- Let users register weight each day and save it in DB
- Import Excel (or csv) Table with user-data as subscribers to wordpress
- SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
- SQL errors when querying for something with apostrophes
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- MySQL SELECT increment counter
- phpMyAdmin – Error > Incorrect format parameter?
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Using wpdb to connect to a separate database
- MySQL Database User: Which Privileges are needed?
- Why is my database import losing text widget data?
- Multiple developers / editors working on a site in progress
- get_results using wpdb
- Will it break my site if I delete all transient records in wp_options table?
- Checking if Database Table exists
- WordPress (MyISAM) database is slow, should I switch to InnoDB?
- Please explain how WordPress works with MySQL character set and collation at a low level
- The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
- How many users can WordPress handle?
- How to fetch Data in WordPress using MySQLi or $wpdb
- WordPress Database lost auto increment
- Count & Display Database Queries
- Connect to database using wordpress wp-config file
- wpdb->insert multiple record at once
- Reset Post IDs to less than 64bit integer
- Automatically delete inactive users after 2 months
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- Restoring WordPress posts from database only
- WordPress database scalability from the code perspective
- How to define composite keys with dbDelta()
- How to track user progress?
- Is it possible to define two databases for one installation?
- Does WordPress use the InnoDB engine for MySQL by default?
- Slow wp_term_relationships query
- How to use “TRUNCATE TABLE” MySQL statement?
- Can I use MariaDB instead of MySQL in wordpress?
- Performance tips for a large user base [closed]
- Export wordpress table to excel
- Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
- WordPress for a very large website
- Changing user_nicename
- What are conventions about the schema of the $table_prefix
- Split WP install between 2 databases?
- Inserting Post Meta From SQL
- Search multiple meta keys at once
- WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
- Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
- Why does dbDelta() not catch MysqlErrors?
- SQL query equivalent to WP User Query
- Efficiency on displaying random authors based on large database
- Is deleting orphaned wp_options entries safe?
- Is altering a default WordPress database table update safe?
- How best to inject ads between posts in the loop?
- What’s the most efficient database method to add and query usermeta?
- How to solve slow WordPress site caused by attachment_metadata
- Huge wp_options table
- “MySQL server has gone away” since update to 3.8
- Change SQL get_results to search for posts with custom term in custom taxonomy
- How to sort results from a custom database table
- Delete all post meta except featured image
- Custom DB_COLLATE (collation) value not working on fresh install?
- What causes the “max_user_connections” warning on WordPress frontend?
- How to track a users progress through pages by inserting data into WordPress Database?
- what to do when your WordPress database is too large?
- How to find if a post with custom_field == X exists?