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
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- phpMyAdmin – Error > Incorrect format parameter?
- Why is my database import losing text widget data?
- Will it break my site if I delete all transient records in wp_options table?
- Please explain how WordPress works with MySQL character set and collation at a low level
- Reset Post IDs to less than 64bit integer
- Automatically delete inactive users after 2 months
- Does WordPress use the InnoDB engine for MySQL by default?
- Performance tips for a large user base [closed]
- SQL query equivalent to WP User Query
- How to sort results from a custom database table
- Custom DB_COLLATE (collation) value not working on fresh install?
- What causes the “max_user_connections” warning on WordPress frontend?
- what to do when your WordPress database is too large?
- WordPress and automated MySQL backups to a different host
- How Do I Merge Categories With phpMyAdmin
- Size article thumbnails and retrieve them directly from database
- WordPress site uses MyISAM, should I switch to InnoDB necessary?
- update_user_meta() does not work
- Query from a different database than the default
- Getting all the users who have author privilege
- Does WordPress always create unique passwords?
- WordPress mysql table double prefixes
- How to get a list of all possible values of a specific user meta key?
- WordPress database import: Row size too large
- Why do mass updates to post_content shows in front end, but not in edit screen?
- Is it safe to delete unnecessary user metadata?
- How to replicate a user plugin made table value, to this user’s custom meta table value?
- Improve performance by removing unnecessary database queries
- Redirecting to old domain after migration website
- WordPress Database Huge wp_usermeta Table
- Switching Databases in LocalHost
- cache specific data?
- Unable to set a default serialized array using dbdelta()
- 2 WordPress sites with 2 databases but sharing the same users
- Check if an option exists and get its value in one hit
- Is there a way to execute a php script outside WordPress?
- Share users across multiple sites on same database, but with different domains
- Why does changing Database Table Prefixes result in loss of content?
- Moving WordPress site to new domain – database import [duplicate]
- How to connect and insert data in database of wordpress?
- How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
- $wpdb->get_var – What value is returned when zero records are found?
- Installing local to live WP into subdirectory
- Select From wpdb – Author/User Directory page
- Only allow user to access a link once a year, based on their joining date
- Counting post and changing roles in mysql database. Query not code
- MSQL database wp_postmeta has meta key tve_revision
- Best Practice? – Saving multiple Values as Serialized Data / Saving each Value per Row / Dedicated Table
- I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
- Display user data in numbered list
- “BS_” rows in postmeta table
- How can I find user role in Mysql?
- Featured image from custom to WordPress database
- How to save dropdown slection by a user in the DB
- mySQL database size large, but tables size less
- spambot registering without providing email or password, bypassing registration process
- After renaming MySQL database, I can no longer access my Blog page
- How To connect to the same WordPress database with different database user
- Get multisite count without php?
- Create a new table on the database and save parameters from a contact form
- Preventing concurrent update of data
- Calling update_user_meta inside of another function doesn’t work
- How to back-up a database on IIS
- why you don’t Implement PDO for access every thing to database
- WordPress database connection failed, while mysql client is working [closed]